== Physical Plan ==
Execute SaveIntoDataSourceCommand (1)
+- SaveIntoDataSourceCommand (2)
+- Project (459)
+- Project (458)
+- Join (457)
:- Project (449)
: +- Project (448)
: +- Project (447)
: +- Join (446)
: :- Project (4)
: : +- LocalRelation (3)
: +- Aggregate (445)
: +- Project (444)
: +- Project (443)
: +- Project (442)
: +- Project (441)
: +- Project (440)
: +- Join (439)
: :- Project (436)
: : +- Filter (435)
: : +- Project (434)
: : +- Generate (433)
: : +- Project (432)
: : +- Aggregate (431)
: : +- Project (430)
: : +- Join (429)
: : :- Deduplicate (212)
: : : +- Project (211)
: : : +- Project (210)
: : : +- Join (209)
: : : :- Deduplicate (103)
: : : : +- Project (102)
: : : : +- Project (101)
: : : : +- Project (100)
: : : : +- Project (99)
: : : : +- Project (98)
: : : : +- Project (97)
: : : : +- Join (96)
: : : : :- Project (91)
: : : : : +- Project (90)
: : : : : +- Project (89)
: : : : : +- Join (88)
: : : : : :- Project (84)
: : : : : : +- Join (83)
: : : : : : :- Project (79)
: : : : : : : +- Project (78)
: : : : : : : +- Project (77)
: : : : : : : +- Project (76)
: : : : : : : +- Project (75)
: : : : : : : +- Project (74)
: : : : : : : +- Project (73)
: : : : : : : +- Project (72)
: : : : : : : +- Project (71)
: : : : : : : +- Project (70)
: : : : : : : +- Project (69)
: : : : : : : +- Join (68)
: : : : : : : :- Project (64)
: : : : : : : : +- Project (63)
: : : : : : : : +- Project (62)
: : : : : : : : +- Project (61)
: : : : : : : : +- Project (60)
: : : : : : : : +- Project (59)
: : : : : : : : +- Join (58)
: : : : : : : : :- Project (55)
: : : : : : : : : +- Join (54)
: : : : : : : : : :- Project (51)
: : : : : : : : : : +- Project (50)
: : : : : : : : : : +- Project (49)
: : : : : : : : : : +- Project (48)
: : : : : : : : : : +- Project (47)
: : : : : : : : : : +- Join (46)
: : : : : : : : : : :- Project (43)
: : : : : : : : : : : +- Project (42)
: : : : : : : : : : : +- Join (41)
: : : : : : : : : : : :- Join (37)
: : : : : : : : : : : : :- SubqueryAlias (34)
: : : : : : : : : : : : : +- Project (33)
: : : : : : : : : : : : : +- Project (32)
: : : : : : : : : : : : : +- Project (31)
: : : : : : : : : : : : : +- Project (30)
: : : : : : : : : : : : : +- Project (29)
: : : : : : : : : : : : : +- Project (28)
: : : : : : : : : : : : : +- Project (27)
: : : : : : : : : : : : : +- Project (26)
: : : : : : : : : : : : : +- Join (25)
: : : : : : : : : : : : : :- Project (21)
: : : : : : : : : : : : : : +- Project (20)
: : : : : : : : : : : : : : +- Project (19)
: : : : : : : : : : : : : : +- Project (18)
: : : : : : : : : : : : : : +- Join (17)
: : : : : : : : : : : : : : :- Project (12)
: : : : : : : : : : : : : : : +- Project (11)
: : : : : : : : : : : : : : : +- Join (10)
: : : : : : : : : : : : : : : :- RepartitionByExpression (6)
: : : : : : : : : : : : : : : : +- LogicalRelation (5)
: : : : : : : : : : : : : : : +- SubqueryAlias (9)
: : : : : : : : : : : : : : : +- Repartition (8)
: : : : : : : : : : : : : : : +- LogicalRelation (7)
: : : : : : : : : : : : : : +- SubqueryAlias (16)
: : : : : : : : : : : : : : +- Filter (15)
: : : : : : : : : : : : : : +- Repartition (14)
: : : : : : : : : : : : : : +- LogicalRelation (13)
: : : : : : : : : : : : : +- SubqueryAlias (24)
: : : : : : : : : : : : : +- Repartition (23)
: : : : : : : : : : : : : +- LogicalRelation (22)
: : : : : : : : : : : : +- SubqueryAlias (36)
: : : : : : : : : : : : +- LocalRelation (35)
: : : : : : : : : : : +- SubqueryAlias (40)
: : : : : : : : : : : +- Filter (39)
: : : : : : : : : : : +- LocalRelation (38)
: : : : : : : : : : +- Aggregate (45)
: : : : : : : : : : +- LocalRelation (44)
: : : : : : : : : +- Repartition (53)
: : : : : : : : : +- LogicalRelation (52)
: : : : : : : : +- Repartition (57)
: : : : : : : : +- LogicalRelation (56)
: : : : : : : +- Project (67)
: : : : : : : +- Project (66)
: : : : : : : +- LocalRelation (65)
: : : : : : +- SubqueryAlias (82)
: : : : : : +- Repartition (81)
: : : : : : +- LogicalRelation (80)
: : : : : +- SubqueryAlias (87)
: : : : : +- Repartition (86)
: : : : : +- LogicalRelation (85)
: : : : +- Project (95)
: : : : +- Project (94)
: : : : +- Repartition (93)
: : : : +- LogicalRelation (92)
: : : +- Project (208)
: : : +- Join (207)
: : : :- Deduplicate (203)
: : : : +- Project (202)
: : : : +- Generate (201)
: : : : +- Project (200)
: : : : +- Project (199)
: : : : +- Project (198)
: : : : +- Project (197)
: : : : +- Project (196)
: : : : +- Join (195)
: : : : :- Project (190)
: : : : : +- Project (189)
: : : : : +- Project (188)
: : : : : +- Join (187)
: : : : : :- Project (183)
: : : : : : +- Join (182)
: : : : : : :- Project (178)
: : : : : : : +- Project (177)
: : : : : : : +- Project (176)
: : : : : : : +- Project (175)
: : : : : : : +- Project (174)
: : : : : : : +- Project (173)
: : : : : : : +- Project (172)
: : : : : : : +- Project (171)
: : : : : : : +- Project (170)
: : : : : : : +- Project (169)
: : : : : : : +- Project (168)
: : : : : : : +- Join (167)
: : : : : : : :- Project (163)
: : : : : : : : +- Project (162)
: : : : : : : : +- Project (161)
: : : : : : : : +- Project (160)
: : : : : : : : +- Project (159)
: : : : : : : : +- Project (158)
: : : : : : : : +- Join (157)
: : : : : : : : :- Project (154)
: : : : : : : : : +- Join (153)
: : : : : : : : : :- Project (150)
: : : : : : : : : : +- Project (149)
: : : : : : : : : : +- Project (148)
: : : : : : : : : : +- Project (147)
: : : : : : : : : : +- Project (146)
: : : : : : : : : : +- Join (145)
: : : : : : : : : : :- Project (142)
: : : : : : : : : : : +- Project (141)
: : : : : : : : : : : +- Join (140)
: : : : : : : : : : : :- Join (136)
: : : : : : : : : : : : :- SubqueryAlias (133)
: : : : : : : : : : : : : +- Project (132)
: : : : : : : : : : : : : +- Project (131)
: : : : : : : : : : : : : +- Project (130)
: : : : : : : : : : : : : +- Project (129)
: : : : : : : : : : : : : +- Project (128)
: : : : : : : : : : : : : +- Project (127)
: : : : : : : : : : : : : +- Project (126)
: : : : : : : : : : : : : +- Project (125)
: : : : : : : : : : : : : +- Join (124)
: : : : : : : : : : : : : :- Project (120)
: : : : : : : : : : : : : : +- Project (119)
: : : : : : : : : : : : : : +- Project (118)
: : : : : : : : : : : : : : +- Project (117)
: : : : : : : : : : : : : : +- Join (116)
: : : : : : : : : : : : : : :- Project (111)
: : : : : : : : : : : : : : : +- Project (110)
: : : : : : : : : : : : : : : +- Join (109)
: : : : : : : : : : : : : : : :- RepartitionByExpression (105)
: : : : : : : : : : : : : : : : +- LogicalRelation (104)
: : : : : : : : : : : : : : : +- SubqueryAlias (108)
: : : : : : : : : : : : : : : +- Repartition (107)
: : : : : : : : : : : : : : : +- LogicalRelation (106)
: : : : : : : : : : : : : : +- SubqueryAlias (115)
: : : : : : : : : : : : : : +- Filter (114)
: : : : : : : : : : : : : : +- Repartition (113)
: : : : : : : : : : : : : : +- LogicalRelation (112)
: : : : : : : : : : : : : +- SubqueryAlias (123)
: : : : : : : : : : : : : +- Repartition (122)
: : : : : : : : : : : : : +- LogicalRelation (121)
: : : : : : : : : : : : +- SubqueryAlias (135)
: : : : : : : : : : : : +- LocalRelation (134)
: : : : : : : : : : : +- SubqueryAlias (139)
: : : : : : : : : : : +- Filter (138)
: : : : : : : : : : : +- LocalRelation (137)
: : : : : : : : : : +- Aggregate (144)
: : : : : : : : : : +- LocalRelation (143)
: : : : : : : : : +- Repartition (152)
: : : : : : : : : +- LogicalRelation (151)
: : : : : : : : +- Repartition (156)
: : : : : : : : +- LogicalRelation (155)
: : : : : : : +- Project (166)
: : : : : : : +- Project (165)
: : : : : : : +- LocalRelation (164)
: : : : : : +- SubqueryAlias (181)
: : : : : : +- Repartition (180)
: : : : : : +- LogicalRelation (179)
: : : : : +- SubqueryAlias (186)
: : : : : +- Repartition (185)
: : : : : +- LogicalRelation (184)
: : : : +- Project (194)
: : : : +- Project (193)
: : : : +- Repartition (192)
: : : : +- LogicalRelation (191)
: : : +- Filter (206)
: : : +- Repartition (205)
: : : +- LogicalRelation (204)
: : +- Project (428)
: : +- Project (427)
: : +- Project (426)
: : +- Project (425)
: : +- Join (424)
: : :- Join (421)
: : : :- Project (418)
: : : : +- Join (417)
: : : : :- Deduplicate (311)
: : : : : +- Project (310)
: : : : : +- Project (309)
: : : : : +- Project (308)
: : : : : +- Project (307)
: : : : : +- Project (306)
: : : : : +- Project (305)
: : : : : +- Join (304)
: : : : : :- Project (299)
: : : : : : +- Project (298)
: : : : : : +- Project (297)
: : : : : : +- Join (296)
: : : : : : :- Project (292)
: : : : : : : +- Join (291)
: : : : : : : :- Project (287)
: : : : : : : : +- Project (286)
: : : : : : : : +- Project (285)
: : : : : : : : +- Project (284)
: : : : : : : : +- Project (283)
: : : : : : : : +- Project (282)
: : : : : : : : +- Project (281)
: : : : : : : : +- Project (280)
: : : : : : : : +- Project (279)
: : : : : : : : +- Project (278)
: : : : : : : : +- Project (277)
: : : : : : : : +- Join (276)
: : : : : : : : :- Project (272)
: : : : : : : : : +- Project (271)
: : : : : : : : : +- Project (270)
: : : : : : : : : +- Project (269)
: : : : : : : : : +- Project (268)
: : : : : : : : : +- Project (267)
: : : : : : : : : +- Join (266)
: : : : : : : : : :- Project (263)
: : : : : : : : : : +- Join (262)
: : : : : : : : : : :- Project (259)
: : : : : : : : : : : +- Project (258)
: : : : : : : : : : : +- Project (257)
: : : : : : : : : : : +- Project (256)
: : : : : : : : : : : +- Project (255)
: : : : : : : : : : : +- Join (254)
: : : : : : : : : : : :- Project (251)
: : : : : : : : : : : : +- Project (250)
: : : : : : : : : : : : +- Join (249)
: : : : : : : : : : : : :- Join (245)
: : : : : : : : : : : : : :- SubqueryAlias (242)
: : : : : : : : : : : : : : +- Project (241)
: : : : : : : : : : : : : : +- Project (240)
: : : : : : : : : : : : : : +- Project (239)
: : : : : : : : : : : : : : +- Project (238)
: : : : : : : : : : : : : : +- Project (237)
: : : : : : : : : : : : : : +- Project (236)
: : : : : : : : : : : : : : +- Project (235)
: : : : : : : : : : : : : : +- Project (234)
: : : : : : : : : : : : : : +- Join (233)
: : : : : : : : : : : : : : :- Project (229)
: : : : : : : : : : : : : : : +- Project (228)
: : : : : : : : : : : : : : : +- Project (227)
: : : : : : : : : : : : : : : +- Project (226)
: : : : : : : : : : : : : : : +- Join (225)
: : : : : : : : : : : : : : : :- Project (220)
: : : : : : : : : : : : : : : : +- Project (219)
: : : : : : : : : : : : : : : : +- Join (218)
: : : : : : : : : : : : : : : : :- RepartitionByExpression (214)
: : : : : : : : : : : : : : : : : +- LogicalRelation (213)
: : : : : : : : : : : : : : : : +- SubqueryAlias (217)
: : : : : : : : : : : : : : : : +- Repartition (216)
: : : : : : : : : : : : : : : : +- LogicalRelation (215)
: : : : : : : : : : : : : : : +- SubqueryAlias (224)
: : : : : : : : : : : : : : : +- Filter (223)
: : : : : : : : : : : : : : : +- Repartition (222)
: : : : : : : : : : : : : : : +- LogicalRelation (221)
: : : : : : : : : : : : : : +- SubqueryAlias (232)
: : : : : : : : : : : : : : +- Repartition (231)
: : : : : : : : : : : : : : +- LogicalRelation (230)
: : : : : : : : : : : : : +- SubqueryAlias (244)
: : : : : : : : : : : : : +- LocalRelation (243)
: : : : : : : : : : : : +- SubqueryAlias (248)
: : : : : : : : : : : : +- Filter (247)
: : : : : : : : : : : : +- LocalRelation (246)
: : : : : : : : : : : +- Aggregate (253)
: : : : : : : : : : : +- LocalRelation (252)
: : : : : : : : : : +- Repartition (261)
: : : : : : : : : : +- LogicalRelation (260)
: : : : : : : : : +- Repartition (265)
: : : : : : : : : +- LogicalRelation (264)
: : : : : : : : +- Project (275)
: : : : : : : : +- Project (274)
: : : : : : : : +- LocalRelation (273)
: : : : : : : +- SubqueryAlias (290)
: : : : : : : +- Repartition (289)
: : : : : : : +- LogicalRelation (288)
: : : : : : +- SubqueryAlias (295)
: : : : : : +- Repartition (294)
: : : : : : +- LogicalRelation (293)
: : : : : +- Project (303)
: : : : : +- Project (302)
: : : : : +- Repartition (301)
: : : : : +- LogicalRelation (300)
: : : : +- Project (416)
: : : : +- Join (415)
: : : : :- Deduplicate (411)
: : : : : +- Project (410)
: : : : : +- Generate (409)
: : : : : +- Project (408)
: : : : : +- Project (407)
: : : : : +- Project (406)
: : : : : +- Project (405)
: : : : : +- Project (404)
: : : : : +- Join (403)
: : : : : :- Project (398)
: : : : : : +- Project (397)
: : : : : : +- Project (396)
: : : : : : +- Join (395)
: : : : : : :- Project (391)
: : : : : : : +- Join (390)
: : : : : : : :- Project (386)
: : : : : : : : +- Project (385)
: : : : : : : : +- Project (384)
: : : : : : : : +- Project (383)
: : : : : : : : +- Project (382)
: : : : : : : : +- Project (381)
: : : : : : : : +- Project (380)
: : : : : : : : +- Project (379)
: : : : : : : : +- Project (378)
: : : : : : : : +- Project (377)
: : : : : : : : +- Project (376)
: : : : : : : : +- Join (375)
: : : : : : : : :- Project (371)
: : : : : : : : : +- Project (370)
: : : : : : : : : +- Project (369)
: : : : : : : : : +- Project (368)
: : : : : : : : : +- Project (367)
: : : : : : : : : +- Project (366)
: : : : : : : : : +- Join (365)
: : : : : : : : : :- Project (362)
: : : : : : : : : : +- Join (361)
: : : : : : : : : : :- Project (358)
: : : : : : : : : : : +- Project (357)
: : : : : : : : : : : +- Project (356)
: : : : : : : : : : : +- Project (355)
: : : : : : : : : : : +- Project (354)
: : : : : : : : : : : +- Join (353)
: : : : : : : : : : : :- Project (350)
: : : : : : : : : : : : +- Project (349)
: : : : : : : : : : : : +- Join (348)
: : : : : : : : : : : : :- Join (344)
: : : : : : : : : : : : : :- SubqueryAlias (341)
: : : : : : : : : : : : : : +- Project (340)
: : : : : : : : : : : : : : +- Project (339)
: : : : : : : : : : : : : : +- Project (338)
: : : : : : : : : : : : : : +- Project (337)
: : : : : : : : : : : : : : +- Project (336)
: : : : : : : : : : : : : : +- Project (335)
: : : : : : : : : : : : : : +- Project (334)
: : : : : : : : : : : : : : +- Project (333)
: : : : : : : : : : : : : : +- Join (332)
: : : : : : : : : : : : : : :- Project (328)
: : : : : : : : : : : : : : : +- Project (327)
: : : : : : : : : : : : : : : +- Project (326)
: : : : : : : : : : : : : : : +- Project (325)
: : : : : : : : : : : : : : : +- Join (324)
: : : : : : : : : : : : : : : :- Project (319)
: : : : : : : : : : : : : : : : +- Project (318)
: : : : : : : : : : : : : : : : +- Join (317)
: : : : : : : : : : : : : : : : :- RepartitionByExpression (313)
: : : : : : : : : : : : : : : : : +- LogicalRelation (312)
: : : : : : : : : : : : : : : : +- SubqueryAlias (316)
: : : : : : : : : : : : : : : : +- Repartition (315)
: : : : : : : : : : : : : : : : +- LogicalRelation (314)
: : : : : : : : : : : : : : : +- SubqueryAlias (323)
: : : : : : : : : : : : : : : +- Filter (322)
: : : : : : : : : : : : : : : +- Repartition (321)
: : : : : : : : : : : : : : : +- LogicalRelation (320)
: : : : : : : : : : : : : : +- SubqueryAlias (331)
: : : : : : : : : : : : : : +- Repartition (330)
: : : : : : : : : : : : : : +- LogicalRelation (329)
: : : : : : : : : : : : : +- SubqueryAlias (343)
: : : : : : : : : : : : : +- LocalRelation (342)
: : : : : : : : : : : : +- SubqueryAlias (347)
: : : : : : : : : : : : +- Filter (346)
: : : : : : : : : : : : +- LocalRelation (345)
: : : : : : : : : : : +- Aggregate (352)
: : : : : : : : : : : +- LocalRelation (351)
: : : : : : : : : : +- Repartition (360)
: : : : : : : : : : +- LogicalRelation (359)
: : : : : : : : : +- Repartition (364)
: : : : : : : : : +- LogicalRelation (363)
: : : : : : : : +- Project (374)
: : : : : : : : +- Project (373)
: : : : : : : : +- LocalRelation (372)
: : : : : : : +- SubqueryAlias (389)
: : : : : : : +- Repartition (388)
: : : : : : : +- LogicalRelation (387)
: : : : : : +- SubqueryAlias (394)
: : : : : : +- Repartition (393)
: : : : : : +- LogicalRelation (392)
: : : : : +- Project (402)
: : : : : +- Project (401)
: : : : : +- Repartition (400)
: : : : : +- LogicalRelation (399)
: : : : +- Filter (414)
: : : : +- Repartition (413)
: : : : +- LogicalRelation (412)
: : : +- Repartition (420)
: : : +- LogicalRelation (419)
: : +- Repartition (423)
: : +- LogicalRelation (422)
: +- Repartition (438)
: +- LogicalRelation (437)
+- Aggregate (456)
+- Project (455)
+- Filter (454)
+- Aggregate (453)
+- Filter (452)
+- Repartition (451)
+- LogicalRelation (450)
(1) Execute SaveIntoDataSourceCommand
Output: []
(2) SaveIntoDataSourceCommand
Arguments: org.apache.spark.sql.delta.sources.DeltaDataSource@5b2bbcc6, [__partition_columns=["shardId"], path=hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-qty-opt-service/internal/common-data-snapshot/10000002111], Overwrite
(3) LocalRelation
(4) Project
Arguments: [dummy AS dummy#1005130]
(5) LogicalRelation
Arguments: parquet, [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994], false
(6) RepartitionByExpression
Arguments: [product#1000977, plant#1000972], 25
(7) LogicalRelation
Arguments: parquet, [systemId#1000996, internalUUID#1000997, supplier#1000998, receiver#1000999, product#1001000, receivingPlant#1001001, sourceOfSupplyType#1001002, purchasingGroup#1001003, purchasingOrganization#1001004, productGroup#1001005, validFrom#1001006, validTo#1001007, priority#1001008, isPurchasingBlocked#1001009, isConsignment#1001010, isDeleted#1001011, supplierSubrange#1001012, plannedDeliveryTimeDays#1001013, orderQuantityUnit#1001014, purchasingPriceAspect#1001015, orderCurrency#1001016, minimumOrderQuantity#1001017, logisticalRoundingProfile#1001018, supplyingPlant#1001019], false
(8) Repartition
Arguments: 25, true
(9) SubqueryAlias
Arguments: sos
(10) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#1000982 <=> internalUUID#1000997)
(11) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 25 more fields]
(12) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 1 more fields]
(13) LogicalRelation
Arguments: parquet, [systemId#1001024, internalUUID#1001025, plant#1001026, product#1001027, blockedForReplenishmentStartingFrom#1001028, productionAspect#1001029, salesPlant#1001030, listing#1001031], false
(14) Repartition
Arguments: 25, true
(15) Filter
Arguments: plant#1001026.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,1c037502c75549dc72c6fc87c802bcec,45f9c5206af43e1e6acbe19d9a246289,24a9ebb440508219166784d4d1c19eef)
(16) SubqueryAlias
Arguments: pp
(17) Join
Arguments: LeftOuter, ((product#1000977 <=> product#1001027.internalRefUUID) AND (plant#1000972 <=> plant#1001026.internalRefUUID))
(18) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 10 more fields]
(19) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 11 more fields]
(20) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 12 more fields]
(21) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 4 more fields]
(22) LogicalRelation
Arguments: parquet, [systemId#1001041, internalUUID#1001042, id#1001043, displayId#1001044, name#1001045, baseUnitOfMeasure#1001046, unitOfMeasures#1001047, unitOfMeasureConversions#1001048, productionAspect#1001049, salesAspect#1001050, procurementAspect#1001051, productGroup#1001052], false
(23) Repartition
Arguments: 25, true
(24) SubqueryAlias
Arguments: tmp
(25) Join
Arguments: LeftOuter, (product#1000977 = internalUUID#1001042)
(26) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 17 more fields]
(27) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 5 more fields]
(28) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 6 more fields]
(29) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 7 more fields]
(30) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 8 more fields]
(31) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 8 more fields]
(32) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 9 more fields]
(33) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 10 more fields]
(34) SubqueryAlias
Arguments: worklist
(35) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#1001084, plant#1001085, logisticalRoundingRule#1001086]
(36) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(37) Join
Arguments: LeftOuter, ((preferredRoundingProfile#1001077 <=> logisticalRoundingProfile#1001084) AND (plant#1000972 <=> plant#1001085.internalRefUUID))
(38) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#1001111, plant#1001112, logisticalRoundingRule#1001113]
(39) Filter
Arguments: isnull(plant#1001112.internalRefUUID)
(40) SubqueryAlias
Arguments: allPlantRoundingProfiles
(41) Join
Arguments: LeftOuter, (preferredRoundingProfile#1001077 <=> logisticalRoundingProfile#1001111)
(42) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 17 more fields]
(43) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 11 more fields]
(44) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#1001102, unitOfMeasure#1001103]
(45) Aggregate
Arguments: [logisticalRoundingRule#1001102], [logisticalRoundingRule#1001102, collect_list(unitOfMeasure#1001103.internalRefUUID, 0, 0) AS preferredUOMs#1001104]
(46) Join
Arguments: LeftOuter, (logisticalRoundingRule#1001115.logisticalRoundingRule = logisticalRoundingRule#1001102)
(47) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 11 more fields]
(48) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 11 more fields]
(49) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 11 more fields]
(50) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 8 more fields]
(51) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 9 more fields]
(52) LogicalRelation
Arguments: parquet, [product#1001128, plant#1001129, orderDateTime#1001130, constraintprofile#1001131], false
(53) Repartition
Arguments: 25, true
(54) Join
Arguments: LeftOuter, (((product#1000977 <=> product#1001128) AND (plant#1000972 <=> plant#1001129)) AND (orderDateTime#1000978 <=> orderDateTime#1001130))
(55) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 10 more fields]
(56) LogicalRelation
Arguments: parquet, [constraintProfile#1001132, descriptions#1001133, minServiceLevel#1001134, minServiceLevelMinStock#1001135, maxServiceLevelEndListing#1001136, maxRangeCoverage#1001137, minOrderQuantity#1001138, profileType#1001139, eventtype#1001140], false
(57) Repartition
Arguments: 25, true
(58) Join
Arguments: LeftOuter, (constraintProfile#1001131 <=> constraintProfile#1001132)
(59) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 20 more fields]
(60) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 10 more fields]
(61) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 10 more fields]
(62) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 15 more fields]
(63) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 15 more fields]
(64) Project
Arguments: [supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalId#1000986L, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, orderProposalItemId#1000994, ... 14 more fields]
(65) LocalRelation
Arguments: <empty>, [orderProposalId#1001169, orderProposalItemId#1001170, constraintOverwrites#1001171]
(66) Project
Arguments: [orderProposalId#1001169, orderProposalItemId#1001170, filter(constraintOverwrites#1001171, lambdafunction(((isnotnull(lambda x_2606#1001173.label) AND isnotnull(lambda x_2606#1001173.isActive)) AND (((lambda x_2606#1001173.isActive = false) OR isnotnull(lambda x_2606#1001173.value)) OR (lambda x_2606#1001173.label <=> minOrderQuantity))), lambda x_2606#1001173, false)) AS constraintOverwrites#1001172]
(67) Project
Arguments: [orderProposalId#1001169, orderProposalItemId#1001170, transform(constraintOverwrites#1001172, lambdafunction(struct(label, lambda x_2607#1001178.label, value, CASE WHEN ((lambda x_2607#1001178.label = minOrderQuantity) OR (lambda x_2607#1001178.label = lockedOrderQuantity)) THEN round(lambda x_2607#1001178.value, 0) ELSE lambda x_2607#1001178.value END, isActive, lambda x_2607#1001178.isActive), lambda x_2607#1001178, false)) AS constraintOverwrites#1001177]
(68) Join
Arguments: LeftOuter, ((orderProposalId#1000986L = cast(orderProposalId#1001169 as bigint)) AND (orderProposalItemId#1000994 = orderProposalItemId#1001170))
(69) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 15 more fields]
(70) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 15 more fields]
(71) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 15 more fields]
(72) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 15 more fields]
(73) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 14 more fields]
(74) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 15 more fields]
(75) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 16 more fields]
(76) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 17 more fields]
(77) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 18 more fields]
(78) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 19 more fields]
(79) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 20 more fields]
(80) LogicalRelation
Arguments: parquet, [systemId#1001208, internalUUID#1001209, code#1001210, name#1001211, commercialCode#1001212, isoCode#1001213], false
(81) Repartition
Arguments: 25, true
(82) SubqueryAlias
Arguments: unitOfMeasure
(83) Join
Arguments: LeftOuter, (filter(filter(productInformation#1001053.unitOfMeasures, lambdafunction((lambda x_2618#1001223.measurementUnit.internalRefUUID = productInformation#1001053.baseUnitOfMeasure.internalRefUUID), lambda x_2618#1001223, false))[0].productDimensions, lambdafunction((lambda x_2619#1001225.dimensionName.code = VOLUME), lambda x_2619#1001225, false))[0].measurementUnit.internalRefUUID <=> internalUUID#1001209)
(84) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 21 more fields]
(85) LogicalRelation
Arguments: parquet, [systemId#1001244, internalUUID#1001245, code#1001246, name#1001247, commercialCode#1001248, isoCode#1001249], false
(86) Repartition
Arguments: 25, true
(87) SubqueryAlias
Arguments: unitOfMeasure
(88) Join
Arguments: LeftOuter, (filter(filter(productInformation#1001053.unitOfMeasures, lambdafunction((lambda x_2620#1001251.measurementUnit.internalRefUUID = productInformation#1001053.baseUnitOfMeasure.internalRefUUID), lambda x_2620#1001251, false))[0].productDimensions, lambdafunction((lambda x_2621#1001253.dimensionName.code = GROSS_WT), lambda x_2621#1001253, false))[0].measurementUnit.internalRefUUID <=> internalUUID#1001245)
(89) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 22 more fields]
(90) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 20 more fields]
(91) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 21 more fields]
(92) LogicalRelation
Arguments: parquet, [supplier#1001275, subrange#1001276, plant#1001277, deliverydatetime#1001278, ordergroupingprofile#1001279, supplierGroup#1001280, locationGroup#1001281, optimizationGroups#1001282], false
(93) Repartition
Arguments: 25, true
(94) Project
Arguments: [supplier#1001275, subrange#1001276, plant#1001277, deliverydatetime#1001278, ordergroupingprofile#1001279, supplierGroup#1001280, locationGroup#1001281, optimizationGroups#1001282, cast(null as string) AS supplyingPlant#1001284]
(95) Project
Arguments: [supplier#1001275, subrange#1001276, plant#1001277, deliverydatetime#1001278, ordergroupingprofile#1001279, supplierGroup#1001280, locationGroup#1001281, optimizationGroups#1001282, supplyingPlant#1001284, cast(null as string) AS productGroup#1001285]
(96) Join
Arguments: LeftOuter, (((((((supplierGroup#1000970 <=> supplierGroup#1001280) AND (supplier#1000971 <=> supplier#1001275)) AND (subrange#1000974 <=> subrange#1001276)) AND (plant#1000972 <=> plant#1001277)) AND (deliveryDateTime#1000973 <=> deliveryDateTime#1001278)) AND (supplyingPlant#1000975 <=> supplyingPlant#1001284)) AND (productGroup#1000976 <=> productGroup#1001285))
(97) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 22 more fields]
(98) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 22 more fields]
(99) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 21 more fields]
(100) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 20 more fields]
(101) Project
Arguments: [orderProposalId#1000986L, orderProposalItemId#1000994, supplierGroup#1000970, supplier#1000971, plant#1000972, deliveryDateTime#1000973, subrange#1000974, supplyingPlant#1000975, productGroup#1000976, product#1000977, orderDateTime#1000978, availabilityDateTime#1000979, nextAvailabilityDateTime#1000980, mrpController#1000981, sourceOfSupplyUuid#1000982, purchasingOrg#1000983, purchasingGroup#1000984, isFallbackOrderOnly#1000985, orderProposalHorizonGroupingId#1000987L, splitIndicator#1000988L, previousOrderProposal#1000989L, clusterId#1000990L, sequenceId#1000991, worklistShardItemId#1000992L, orderProposalItemGroupId#1000993, ... 19 more fields]
(102) Project
Arguments: [orderProposalId#1000986L, sequenceId#1000991]
(103) Deduplicate
Arguments: [orderProposalId#1000986L, sequenceId#1000991]
(104) LogicalRelation
Arguments: parquet, [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018], false
(105) RepartitionByExpression
Arguments: [product#1002001, plant#1001996], 25
(106) LogicalRelation
Arguments: parquet, [systemId#1002019, internalUUID#1002020, supplier#1002021, receiver#1002022, product#1002023, receivingPlant#1002024, sourceOfSupplyType#1002025, purchasingGroup#1002026, purchasingOrganization#1002027, productGroup#1002028, validFrom#1002029, validTo#1002030, priority#1002031, isPurchasingBlocked#1002032, isConsignment#1002033, isDeleted#1002034, supplierSubrange#1002035, plannedDeliveryTimeDays#1002036, orderQuantityUnit#1002037, purchasingPriceAspect#1002038, orderCurrency#1002039, minimumOrderQuantity#1002040, logisticalRoundingProfile#1002041, supplyingPlant#1002042], false
(107) Repartition
Arguments: 25, true
(108) SubqueryAlias
Arguments: sos
(109) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#1002006 <=> internalUUID#1002020)
(110) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 25 more fields]
(111) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 1 more fields]
(112) LogicalRelation
Arguments: parquet, [systemId#1002044, internalUUID#1002045, plant#1002046, product#1002047, blockedForReplenishmentStartingFrom#1002048, productionAspect#1002049, salesPlant#1002050, listing#1002051], false
(113) Repartition
Arguments: 25, true
(114) Filter
Arguments: plant#1002046.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,1c037502c75549dc72c6fc87c802bcec,45f9c5206af43e1e6acbe19d9a246289,24a9ebb440508219166784d4d1c19eef)
(115) SubqueryAlias
Arguments: pp
(116) Join
Arguments: LeftOuter, ((product#1002001 <=> product#1002047.internalRefUUID) AND (plant#1001996 <=> plant#1002046.internalRefUUID))
(117) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 10 more fields]
(118) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 11 more fields]
(119) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 12 more fields]
(120) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 4 more fields]
(121) LogicalRelation
Arguments: parquet, [systemId#1002055, internalUUID#1002056, id#1002057, displayId#1002058, name#1002059, baseUnitOfMeasure#1002060, unitOfMeasures#1002061, unitOfMeasureConversions#1002062, productionAspect#1002063, salesAspect#1002064, procurementAspect#1002065, productGroup#1002066], false
(122) Repartition
Arguments: 25, true
(123) SubqueryAlias
Arguments: tmp
(124) Join
Arguments: LeftOuter, (product#1002001 = internalUUID#1002056)
(125) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 17 more fields]
(126) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 5 more fields]
(127) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 6 more fields]
(128) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 7 more fields]
(129) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 8 more fields]
(130) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 8 more fields]
(131) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 9 more fields]
(132) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 10 more fields]
(133) SubqueryAlias
Arguments: worklist
(134) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#1002074, plant#1002075, logisticalRoundingRule#1002076]
(135) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(136) Join
Arguments: LeftOuter, ((preferredRoundingProfile#1002073 <=> logisticalRoundingProfile#1002074) AND (plant#1001996 <=> plant#1002075.internalRefUUID))
(137) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#1002077, plant#1002078, logisticalRoundingRule#1002079]
(138) Filter
Arguments: isnull(plant#1002078.internalRefUUID)
(139) SubqueryAlias
Arguments: allPlantRoundingProfiles
(140) Join
Arguments: LeftOuter, (preferredRoundingProfile#1002073 <=> logisticalRoundingProfile#1002077)
(141) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 17 more fields]
(142) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 11 more fields]
(143) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#1002082, unitOfMeasure#1002083]
(144) Aggregate
Arguments: [logisticalRoundingRule#1002082], [logisticalRoundingRule#1002082, collect_list(unitOfMeasure#1002083.internalRefUUID, 0, 0) AS preferredUOMs#1002084]
(145) Join
Arguments: LeftOuter, (logisticalRoundingRule#1002081.logisticalRoundingRule = logisticalRoundingRule#1002082)
(146) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 11 more fields]
(147) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 11 more fields]
(148) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 11 more fields]
(149) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 8 more fields]
(150) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 9 more fields]
(151) LogicalRelation
Arguments: parquet, [product#1002088, plant#1002089, orderDateTime#1002090, constraintprofile#1002091], false
(152) Repartition
Arguments: 25, true
(153) Join
Arguments: LeftOuter, (((product#1002001 <=> product#1002088) AND (plant#1001996 <=> plant#1002089)) AND (orderDateTime#1002002 <=> orderDateTime#1002090))
(154) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 10 more fields]
(155) LogicalRelation
Arguments: parquet, [constraintProfile#1002092, descriptions#1002093, minServiceLevel#1002094, minServiceLevelMinStock#1002095, maxServiceLevelEndListing#1002096, maxRangeCoverage#1002097, minOrderQuantity#1002098, profileType#1002099, eventtype#1002100], false
(156) Repartition
Arguments: 25, true
(157) Join
Arguments: LeftOuter, (constraintProfile#1002091 <=> constraintProfile#1002092)
(158) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 20 more fields]
(159) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 10 more fields]
(160) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 10 more fields]
(161) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 15 more fields]
(162) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 15 more fields]
(163) Project
Arguments: [supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalId#1002010L, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, orderProposalItemId#1002018, ... 14 more fields]
(164) LocalRelation
Arguments: <empty>, [orderProposalId#1002109, orderProposalItemId#1002110, constraintOverwrites#1002111]
(165) Project
Arguments: [orderProposalId#1002109, orderProposalItemId#1002110, filter(constraintOverwrites#1002111, lambdafunction(((isnotnull(lambda x_2606#1001173.label) AND isnotnull(lambda x_2606#1001173.isActive)) AND (((lambda x_2606#1001173.isActive = false) OR isnotnull(lambda x_2606#1001173.value)) OR (lambda x_2606#1001173.label <=> minOrderQuantity))), lambda x_2606#1001173, false)) AS constraintOverwrites#1002112]
(166) Project
Arguments: [orderProposalId#1002109, orderProposalItemId#1002110, transform(constraintOverwrites#1002112, lambdafunction(struct(label, lambda x_2607#1001178.label, value, CASE WHEN ((lambda x_2607#1001178.label = minOrderQuantity) OR (lambda x_2607#1001178.label = lockedOrderQuantity)) THEN round(lambda x_2607#1001178.value, 0) ELSE lambda x_2607#1001178.value END, isActive, lambda x_2607#1001178.isActive), lambda x_2607#1001178, false)) AS constraintOverwrites#1002113]
(167) Join
Arguments: LeftOuter, ((orderProposalId#1002010L = cast(orderProposalId#1002109 as bigint)) AND (orderProposalItemId#1002018 = orderProposalItemId#1002110))
(168) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 15 more fields]
(169) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 15 more fields]
(170) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 15 more fields]
(171) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 15 more fields]
(172) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 14 more fields]
(173) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 15 more fields]
(174) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 16 more fields]
(175) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 17 more fields]
(176) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 18 more fields]
(177) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 19 more fields]
(178) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 20 more fields]
(179) LogicalRelation
Arguments: parquet, [systemId#1002123, internalUUID#1002124, code#1002125, name#1002126, commercialCode#1002127, isoCode#1002128], false
(180) Repartition
Arguments: 25, true
(181) SubqueryAlias
Arguments: unitOfMeasure
(182) Join
Arguments: LeftOuter, (filter(filter(productInformation#1002067.unitOfMeasures, lambdafunction((lambda x_2618#1001223.measurementUnit.internalRefUUID = productInformation#1002067.baseUnitOfMeasure.internalRefUUID), lambda x_2618#1001223, false))[0].productDimensions, lambdafunction((lambda x_2619#1001225.dimensionName.code = VOLUME), lambda x_2619#1001225, false))[0].measurementUnit.internalRefUUID <=> internalUUID#1002124)
(183) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 21 more fields]
(184) LogicalRelation
Arguments: parquet, [systemId#1002130, internalUUID#1002131, code#1002132, name#1002133, commercialCode#1002134, isoCode#1002135], false
(185) Repartition
Arguments: 25, true
(186) SubqueryAlias
Arguments: unitOfMeasure
(187) Join
Arguments: LeftOuter, (filter(filter(productInformation#1002067.unitOfMeasures, lambdafunction((lambda x_2620#1001251.measurementUnit.internalRefUUID = productInformation#1002067.baseUnitOfMeasure.internalRefUUID), lambda x_2620#1001251, false))[0].productDimensions, lambdafunction((lambda x_2621#1001253.dimensionName.code = GROSS_WT), lambda x_2621#1001253, false))[0].measurementUnit.internalRefUUID <=> internalUUID#1002131)
(188) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 22 more fields]
(189) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 20 more fields]
(190) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 21 more fields]
(191) LogicalRelation
Arguments: parquet, [supplier#1002139, subrange#1002140, plant#1002141, deliverydatetime#1002142, ordergroupingprofile#1002143, supplierGroup#1002144, locationGroup#1002145, optimizationGroups#1002146], false
(192) Repartition
Arguments: 25, true
(193) Project
Arguments: [supplier#1002139, subrange#1002140, plant#1002141, deliverydatetime#1002142, ordergroupingprofile#1002143, supplierGroup#1002144, locationGroup#1002145, optimizationGroups#1002146, cast(null as string) AS supplyingPlant#1002147]
(194) Project
Arguments: [supplier#1002139, subrange#1002140, plant#1002141, deliverydatetime#1002142, ordergroupingprofile#1002143, supplierGroup#1002144, locationGroup#1002145, optimizationGroups#1002146, supplyingPlant#1002147, cast(null as string) AS productGroup#1002148]
(195) Join
Arguments: LeftOuter, (((((((supplierGroup#1001994 <=> supplierGroup#1002144) AND (supplier#1001995 <=> supplier#1002139)) AND (subrange#1001998 <=> subrange#1002140)) AND (plant#1001996 <=> plant#1002141)) AND (deliveryDateTime#1001997 <=> deliveryDateTime#1002142)) AND (supplyingPlant#1001999 <=> supplyingPlant#1002147)) AND (productGroup#1002000 <=> productGroup#1002148))
(196) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 22 more fields]
(197) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 22 more fields]
(198) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 21 more fields]
(199) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 20 more fields]
(200) Project
Arguments: [orderProposalId#1002010L, orderProposalItemId#1002018, supplierGroup#1001994, supplier#1001995, plant#1001996, deliveryDateTime#1001997, subrange#1001998, supplyingPlant#1001999, productGroup#1002000, product#1002001, orderDateTime#1002002, availabilityDateTime#1002003, nextAvailabilityDateTime#1002004, mrpController#1002005, sourceOfSupplyUuid#1002006, purchasingOrg#1002007, purchasingGroup#1002008, isFallbackOrderOnly#1002009, orderProposalHorizonGroupingId#1002011L, splitIndicator#1002012L, previousOrderProposal#1002013L, clusterId#1002014L, sequenceId#1002015, worklistShardItemId#1002016L, orderProposalItemGroupId#1002017, ... 19 more fields]
(201) Generate
Arguments: explode(optimizationGroups#1002149), true, [optGroupId#1001993]
(202) Project
Arguments: [orderProposalId#1002010L, optGroupId#1001993]
(203) Deduplicate
Arguments: [orderProposalId#1002010L, optGroupId#1001993]
(204) LogicalRelation
Arguments: parquet, [optGroupId#1001987, assignmentDetails#1001988, minOrderProfile#1001989, multiplerestrictionprofile#1001990], false
(205) Repartition
Arguments: 25, true
(206) Filter
Arguments: (isnotnull(optGroupId#1001987) AND isnotnull(minOrderProfile#1001989))
(207) Join
Arguments: Inner, (optGroupId#1001993 = optGroupId#1001987)
(208) Project
Arguments: [optGroupId#1001993, orderProposalId#1002010L, assignmentDetails#1001988, minOrderProfile#1001989, multiplerestrictionprofile#1001990]
(209) Join
Arguments: LeftOuter, (orderProposalId#1000986L = orderProposalId#1002010L)
(210) Project
Arguments: [orderProposalId#1000986L, sequenceId#1000991, optGroupId#1001993, assignmentDetails#1001988, minOrderProfile#1001989, multiplerestrictionprofile#1001990]
(211) Project
Arguments: [orderProposalId#1000986L, sequenceId#1000991]
(212) Deduplicate
Arguments: [orderProposalId#1000986L, sequenceId#1000991]
(213) LogicalRelation
Arguments: parquet, [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206], false
(214) RepartitionByExpression
Arguments: [product#1002189, plant#1002184], 25
(215) LogicalRelation
Arguments: parquet, [systemId#1002207, internalUUID#1002208, supplier#1002209, receiver#1002210, product#1002211, receivingPlant#1002212, sourceOfSupplyType#1002213, purchasingGroup#1002214, purchasingOrganization#1002215, productGroup#1002216, validFrom#1002217, validTo#1002218, priority#1002219, isPurchasingBlocked#1002220, isConsignment#1002221, isDeleted#1002222, supplierSubrange#1002223, plannedDeliveryTimeDays#1002224, orderQuantityUnit#1002225, purchasingPriceAspect#1002226, orderCurrency#1002227, minimumOrderQuantity#1002228, logisticalRoundingProfile#1002229, supplyingPlant#1002230], false
(216) Repartition
Arguments: 25, true
(217) SubqueryAlias
Arguments: sos
(218) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#1002194 <=> internalUUID#1002208)
(219) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 25 more fields]
(220) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 1 more fields]
(221) LogicalRelation
Arguments: parquet, [systemId#1002232, internalUUID#1002233, plant#1002234, product#1002235, blockedForReplenishmentStartingFrom#1002236, productionAspect#1002237, salesPlant#1002238, listing#1002239], false
(222) Repartition
Arguments: 25, true
(223) Filter
Arguments: plant#1002234.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,1c037502c75549dc72c6fc87c802bcec,45f9c5206af43e1e6acbe19d9a246289,24a9ebb440508219166784d4d1c19eef)
(224) SubqueryAlias
Arguments: pp
(225) Join
Arguments: LeftOuter, ((product#1002189 <=> product#1002235.internalRefUUID) AND (plant#1002184 <=> plant#1002234.internalRefUUID))
(226) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 10 more fields]
(227) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 11 more fields]
(228) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 12 more fields]
(229) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 4 more fields]
(230) LogicalRelation
Arguments: parquet, [systemId#1002243, internalUUID#1002244, id#1002245, displayId#1002246, name#1002247, baseUnitOfMeasure#1002248, unitOfMeasures#1002249, unitOfMeasureConversions#1002250, productionAspect#1002251, salesAspect#1002252, procurementAspect#1002253, productGroup#1002254], false
(231) Repartition
Arguments: 25, true
(232) SubqueryAlias
Arguments: tmp
(233) Join
Arguments: LeftOuter, (product#1002189 = internalUUID#1002244)
(234) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 17 more fields]
(235) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 5 more fields]
(236) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 6 more fields]
(237) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 7 more fields]
(238) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 8 more fields]
(239) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 8 more fields]
(240) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 9 more fields]
(241) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 10 more fields]
(242) SubqueryAlias
Arguments: worklist
(243) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#1002262, plant#1002263, logisticalRoundingRule#1002264]
(244) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(245) Join
Arguments: LeftOuter, ((preferredRoundingProfile#1002261 <=> logisticalRoundingProfile#1002262) AND (plant#1002184 <=> plant#1002263.internalRefUUID))
(246) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#1002265, plant#1002266, logisticalRoundingRule#1002267]
(247) Filter
Arguments: isnull(plant#1002266.internalRefUUID)
(248) SubqueryAlias
Arguments: allPlantRoundingProfiles
(249) Join
Arguments: LeftOuter, (preferredRoundingProfile#1002261 <=> logisticalRoundingProfile#1002265)
(250) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 17 more fields]
(251) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 11 more fields]
(252) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#1002270, unitOfMeasure#1002271]
(253) Aggregate
Arguments: [logisticalRoundingRule#1002270], [logisticalRoundingRule#1002270, collect_list(unitOfMeasure#1002271.internalRefUUID, 0, 0) AS preferredUOMs#1002272]
(254) Join
Arguments: LeftOuter, (logisticalRoundingRule#1002269.logisticalRoundingRule = logisticalRoundingRule#1002270)
(255) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 11 more fields]
(256) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 11 more fields]
(257) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 11 more fields]
(258) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 8 more fields]
(259) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 9 more fields]
(260) LogicalRelation
Arguments: parquet, [product#1002276, plant#1002277, orderDateTime#1002278, constraintprofile#1002279], false
(261) Repartition
Arguments: 25, true
(262) Join
Arguments: LeftOuter, (((product#1002189 <=> product#1002276) AND (plant#1002184 <=> plant#1002277)) AND (orderDateTime#1002190 <=> orderDateTime#1002278))
(263) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 10 more fields]
(264) LogicalRelation
Arguments: parquet, [constraintProfile#1002280, descriptions#1002281, minServiceLevel#1002282, minServiceLevelMinStock#1002283, maxServiceLevelEndListing#1002284, maxRangeCoverage#1002285, minOrderQuantity#1002286, profileType#1002287, eventtype#1002288], false
(265) Repartition
Arguments: 25, true
(266) Join
Arguments: LeftOuter, (constraintProfile#1002279 <=> constraintProfile#1002280)
(267) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 20 more fields]
(268) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 10 more fields]
(269) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 10 more fields]
(270) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 15 more fields]
(271) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 15 more fields]
(272) Project
Arguments: [supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalId#1002198L, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, orderProposalItemId#1002206, ... 14 more fields]
(273) LocalRelation
Arguments: <empty>, [orderProposalId#1002297, orderProposalItemId#1002298, constraintOverwrites#1002299]
(274) Project
Arguments: [orderProposalId#1002297, orderProposalItemId#1002298, filter(constraintOverwrites#1002299, lambdafunction(((isnotnull(lambda x_2606#1001173.label) AND isnotnull(lambda x_2606#1001173.isActive)) AND (((lambda x_2606#1001173.isActive = false) OR isnotnull(lambda x_2606#1001173.value)) OR (lambda x_2606#1001173.label <=> minOrderQuantity))), lambda x_2606#1001173, false)) AS constraintOverwrites#1002300]
(275) Project
Arguments: [orderProposalId#1002297, orderProposalItemId#1002298, transform(constraintOverwrites#1002300, lambdafunction(struct(label, lambda x_2607#1001178.label, value, CASE WHEN ((lambda x_2607#1001178.label = minOrderQuantity) OR (lambda x_2607#1001178.label = lockedOrderQuantity)) THEN round(lambda x_2607#1001178.value, 0) ELSE lambda x_2607#1001178.value END, isActive, lambda x_2607#1001178.isActive), lambda x_2607#1001178, false)) AS constraintOverwrites#1002301]
(276) Join
Arguments: LeftOuter, ((orderProposalId#1002198L = cast(orderProposalId#1002297 as bigint)) AND (orderProposalItemId#1002206 = orderProposalItemId#1002298))
(277) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 15 more fields]
(278) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 15 more fields]
(279) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 15 more fields]
(280) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 15 more fields]
(281) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 14 more fields]
(282) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 15 more fields]
(283) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 16 more fields]
(284) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 17 more fields]
(285) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 18 more fields]
(286) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 19 more fields]
(287) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 20 more fields]
(288) LogicalRelation
Arguments: parquet, [systemId#1002311, internalUUID#1002312, code#1002313, name#1002314, commercialCode#1002315, isoCode#1002316], false
(289) Repartition
Arguments: 25, true
(290) SubqueryAlias
Arguments: unitOfMeasure
(291) Join
Arguments: LeftOuter, (filter(filter(productInformation#1002255.unitOfMeasures, lambdafunction((lambda x_2618#1001223.measurementUnit.internalRefUUID = productInformation#1002255.baseUnitOfMeasure.internalRefUUID), lambda x_2618#1001223, false))[0].productDimensions, lambdafunction((lambda x_2619#1001225.dimensionName.code = VOLUME), lambda x_2619#1001225, false))[0].measurementUnit.internalRefUUID <=> internalUUID#1002312)
(292) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 21 more fields]
(293) LogicalRelation
Arguments: parquet, [systemId#1002318, internalUUID#1002319, code#1002320, name#1002321, commercialCode#1002322, isoCode#1002323], false
(294) Repartition
Arguments: 25, true
(295) SubqueryAlias
Arguments: unitOfMeasure
(296) Join
Arguments: LeftOuter, (filter(filter(productInformation#1002255.unitOfMeasures, lambdafunction((lambda x_2620#1001251.measurementUnit.internalRefUUID = productInformation#1002255.baseUnitOfMeasure.internalRefUUID), lambda x_2620#1001251, false))[0].productDimensions, lambdafunction((lambda x_2621#1001253.dimensionName.code = GROSS_WT), lambda x_2621#1001253, false))[0].measurementUnit.internalRefUUID <=> internalUUID#1002319)
(297) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 22 more fields]
(298) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 20 more fields]
(299) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 21 more fields]
(300) LogicalRelation
Arguments: parquet, [supplier#1002327, subrange#1002328, plant#1002329, deliverydatetime#1002330, ordergroupingprofile#1002331, supplierGroup#1002332, locationGroup#1002333, optimizationGroups#1002334], false
(301) Repartition
Arguments: 25, true
(302) Project
Arguments: [supplier#1002327, subrange#1002328, plant#1002329, deliverydatetime#1002330, ordergroupingprofile#1002331, supplierGroup#1002332, locationGroup#1002333, optimizationGroups#1002334, cast(null as string) AS supplyingPlant#1002335]
(303) Project
Arguments: [supplier#1002327, subrange#1002328, plant#1002329, deliverydatetime#1002330, ordergroupingprofile#1002331, supplierGroup#1002332, locationGroup#1002333, optimizationGroups#1002334, supplyingPlant#1002335, cast(null as string) AS productGroup#1002336]
(304) Join
Arguments: LeftOuter, (((((((supplierGroup#1002182 <=> supplierGroup#1002332) AND (supplier#1002183 <=> supplier#1002327)) AND (subrange#1002186 <=> subrange#1002328)) AND (plant#1002184 <=> plant#1002329)) AND (deliveryDateTime#1002185 <=> deliveryDateTime#1002330)) AND (supplyingPlant#1002187 <=> supplyingPlant#1002335)) AND (productGroup#1002188 <=> productGroup#1002336))
(305) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 22 more fields]
(306) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 22 more fields]
(307) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 21 more fields]
(308) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 20 more fields]
(309) Project
Arguments: [orderProposalId#1002198L, orderProposalItemId#1002206, supplierGroup#1002182, supplier#1002183, plant#1002184, deliveryDateTime#1002185, subrange#1002186, supplyingPlant#1002187, productGroup#1002188, product#1002189, orderDateTime#1002190, availabilityDateTime#1002191, nextAvailabilityDateTime#1002192, mrpController#1002193, sourceOfSupplyUuid#1002194, purchasingOrg#1002195, purchasingGroup#1002196, isFallbackOrderOnly#1002197, orderProposalHorizonGroupingId#1002199L, splitIndicator#1002200L, previousOrderProposal#1002201L, clusterId#1002202L, sequenceId#1002203, worklistShardItemId#1002204L, orderProposalItemGroupId#1002205, ... 19 more fields]
(310) Project
Arguments: [orderProposalId#1002198L, sequenceId#1002203]
(311) Deduplicate
Arguments: [orderProposalId#1002198L, sequenceId#1002203]
(312) LogicalRelation
Arguments: parquet, [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362], false
(313) RepartitionByExpression
Arguments: [product#1002345, plant#1002340], 25
(314) LogicalRelation
Arguments: parquet, [systemId#1002363, internalUUID#1002364, supplier#1002365, receiver#1002366, product#1002367, receivingPlant#1002368, sourceOfSupplyType#1002369, purchasingGroup#1002370, purchasingOrganization#1002371, productGroup#1002372, validFrom#1002373, validTo#1002374, priority#1002375, isPurchasingBlocked#1002376, isConsignment#1002377, isDeleted#1002378, supplierSubrange#1002379, plannedDeliveryTimeDays#1002380, orderQuantityUnit#1002381, purchasingPriceAspect#1002382, orderCurrency#1002383, minimumOrderQuantity#1002384, logisticalRoundingProfile#1002385, supplyingPlant#1002386], false
(315) Repartition
Arguments: 25, true
(316) SubqueryAlias
Arguments: sos
(317) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#1002350 <=> internalUUID#1002364)
(318) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 25 more fields]
(319) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 1 more fields]
(320) LogicalRelation
Arguments: parquet, [systemId#1002388, internalUUID#1002389, plant#1002390, product#1002391, blockedForReplenishmentStartingFrom#1002392, productionAspect#1002393, salesPlant#1002394, listing#1002395], false
(321) Repartition
Arguments: 25, true
(322) Filter
Arguments: plant#1002390.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,1c037502c75549dc72c6fc87c802bcec,45f9c5206af43e1e6acbe19d9a246289,24a9ebb440508219166784d4d1c19eef)
(323) SubqueryAlias
Arguments: pp
(324) Join
Arguments: LeftOuter, ((product#1002345 <=> product#1002391.internalRefUUID) AND (plant#1002340 <=> plant#1002390.internalRefUUID))
(325) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 10 more fields]
(326) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 11 more fields]
(327) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 12 more fields]
(328) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 4 more fields]
(329) LogicalRelation
Arguments: parquet, [systemId#1002399, internalUUID#1002400, id#1002401, displayId#1002402, name#1002403, baseUnitOfMeasure#1002404, unitOfMeasures#1002405, unitOfMeasureConversions#1002406, productionAspect#1002407, salesAspect#1002408, procurementAspect#1002409, productGroup#1002410], false
(330) Repartition
Arguments: 25, true
(331) SubqueryAlias
Arguments: tmp
(332) Join
Arguments: LeftOuter, (product#1002345 = internalUUID#1002400)
(333) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 17 more fields]
(334) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 5 more fields]
(335) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 6 more fields]
(336) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 7 more fields]
(337) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 8 more fields]
(338) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 8 more fields]
(339) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 9 more fields]
(340) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 10 more fields]
(341) SubqueryAlias
Arguments: worklist
(342) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#1002418, plant#1002419, logisticalRoundingRule#1002420]
(343) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(344) Join
Arguments: LeftOuter, ((preferredRoundingProfile#1002417 <=> logisticalRoundingProfile#1002418) AND (plant#1002340 <=> plant#1002419.internalRefUUID))
(345) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#1002421, plant#1002422, logisticalRoundingRule#1002423]
(346) Filter
Arguments: isnull(plant#1002422.internalRefUUID)
(347) SubqueryAlias
Arguments: allPlantRoundingProfiles
(348) Join
Arguments: LeftOuter, (preferredRoundingProfile#1002417 <=> logisticalRoundingProfile#1002421)
(349) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 17 more fields]
(350) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 11 more fields]
(351) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#1002426, unitOfMeasure#1002427]
(352) Aggregate
Arguments: [logisticalRoundingRule#1002426], [logisticalRoundingRule#1002426, collect_list(unitOfMeasure#1002427.internalRefUUID, 0, 0) AS preferredUOMs#1002428]
(353) Join
Arguments: LeftOuter, (logisticalRoundingRule#1002425.logisticalRoundingRule = logisticalRoundingRule#1002426)
(354) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 11 more fields]
(355) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 11 more fields]
(356) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 11 more fields]
(357) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 8 more fields]
(358) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 9 more fields]
(359) LogicalRelation
Arguments: parquet, [product#1002432, plant#1002433, orderDateTime#1002434, constraintprofile#1002435], false
(360) Repartition
Arguments: 25, true
(361) Join
Arguments: LeftOuter, (((product#1002345 <=> product#1002432) AND (plant#1002340 <=> plant#1002433)) AND (orderDateTime#1002346 <=> orderDateTime#1002434))
(362) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 10 more fields]
(363) LogicalRelation
Arguments: parquet, [constraintProfile#1002436, descriptions#1002437, minServiceLevel#1002438, minServiceLevelMinStock#1002439, maxServiceLevelEndListing#1002440, maxRangeCoverage#1002441, minOrderQuantity#1002442, profileType#1002443, eventtype#1002444], false
(364) Repartition
Arguments: 25, true
(365) Join
Arguments: LeftOuter, (constraintProfile#1002435 <=> constraintProfile#1002436)
(366) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 20 more fields]
(367) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 10 more fields]
(368) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 10 more fields]
(369) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 15 more fields]
(370) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 15 more fields]
(371) Project
Arguments: [supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalId#1002354L, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, orderProposalItemId#1002362, ... 14 more fields]
(372) LocalRelation
Arguments: <empty>, [orderProposalId#1002453, orderProposalItemId#1002454, constraintOverwrites#1002455]
(373) Project
Arguments: [orderProposalId#1002453, orderProposalItemId#1002454, filter(constraintOverwrites#1002455, lambdafunction(((isnotnull(lambda x_2606#1001173.label) AND isnotnull(lambda x_2606#1001173.isActive)) AND (((lambda x_2606#1001173.isActive = false) OR isnotnull(lambda x_2606#1001173.value)) OR (lambda x_2606#1001173.label <=> minOrderQuantity))), lambda x_2606#1001173, false)) AS constraintOverwrites#1002456]
(374) Project
Arguments: [orderProposalId#1002453, orderProposalItemId#1002454, transform(constraintOverwrites#1002456, lambdafunction(struct(label, lambda x_2607#1001178.label, value, CASE WHEN ((lambda x_2607#1001178.label = minOrderQuantity) OR (lambda x_2607#1001178.label = lockedOrderQuantity)) THEN round(lambda x_2607#1001178.value, 0) ELSE lambda x_2607#1001178.value END, isActive, lambda x_2607#1001178.isActive), lambda x_2607#1001178, false)) AS constraintOverwrites#1002457]
(375) Join
Arguments: LeftOuter, ((orderProposalId#1002354L = cast(orderProposalId#1002453 as bigint)) AND (orderProposalItemId#1002362 = orderProposalItemId#1002454))
(376) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 15 more fields]
(377) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 15 more fields]
(378) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 15 more fields]
(379) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 15 more fields]
(380) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 14 more fields]
(381) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 15 more fields]
(382) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 16 more fields]
(383) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 17 more fields]
(384) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 18 more fields]
(385) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 19 more fields]
(386) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 20 more fields]
(387) LogicalRelation
Arguments: parquet, [systemId#1002467, internalUUID#1002468, code#1002469, name#1002470, commercialCode#1002471, isoCode#1002472], false
(388) Repartition
Arguments: 25, true
(389) SubqueryAlias
Arguments: unitOfMeasure
(390) Join
Arguments: LeftOuter, (filter(filter(productInformation#1002411.unitOfMeasures, lambdafunction((lambda x_2618#1001223.measurementUnit.internalRefUUID = productInformation#1002411.baseUnitOfMeasure.internalRefUUID), lambda x_2618#1001223, false))[0].productDimensions, lambdafunction((lambda x_2619#1001225.dimensionName.code = VOLUME), lambda x_2619#1001225, false))[0].measurementUnit.internalRefUUID <=> internalUUID#1002468)
(391) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 21 more fields]
(392) LogicalRelation
Arguments: parquet, [systemId#1002474, internalUUID#1002475, code#1002476, name#1002477, commercialCode#1002478, isoCode#1002479], false
(393) Repartition
Arguments: 25, true
(394) SubqueryAlias
Arguments: unitOfMeasure
(395) Join
Arguments: LeftOuter, (filter(filter(productInformation#1002411.unitOfMeasures, lambdafunction((lambda x_2620#1001251.measurementUnit.internalRefUUID = productInformation#1002411.baseUnitOfMeasure.internalRefUUID), lambda x_2620#1001251, false))[0].productDimensions, lambdafunction((lambda x_2621#1001253.dimensionName.code = GROSS_WT), lambda x_2621#1001253, false))[0].measurementUnit.internalRefUUID <=> internalUUID#1002475)
(396) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 22 more fields]
(397) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 20 more fields]
(398) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 21 more fields]
(399) LogicalRelation
Arguments: parquet, [supplier#1002483, subrange#1002484, plant#1002485, deliverydatetime#1002486, ordergroupingprofile#1002487, supplierGroup#1002488, locationGroup#1002489, optimizationGroups#1002490], false
(400) Repartition
Arguments: 25, true
(401) Project
Arguments: [supplier#1002483, subrange#1002484, plant#1002485, deliverydatetime#1002486, ordergroupingprofile#1002487, supplierGroup#1002488, locationGroup#1002489, optimizationGroups#1002490, cast(null as string) AS supplyingPlant#1002491]
(402) Project
Arguments: [supplier#1002483, subrange#1002484, plant#1002485, deliverydatetime#1002486, ordergroupingprofile#1002487, supplierGroup#1002488, locationGroup#1002489, optimizationGroups#1002490, supplyingPlant#1002491, cast(null as string) AS productGroup#1002492]
(403) Join
Arguments: LeftOuter, (((((((supplierGroup#1002338 <=> supplierGroup#1002488) AND (supplier#1002339 <=> supplier#1002483)) AND (subrange#1002342 <=> subrange#1002484)) AND (plant#1002340 <=> plant#1002485)) AND (deliveryDateTime#1002341 <=> deliveryDateTime#1002486)) AND (supplyingPlant#1002343 <=> supplyingPlant#1002491)) AND (productGroup#1002344 <=> productGroup#1002492))
(404) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 22 more fields]
(405) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 22 more fields]
(406) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 21 more fields]
(407) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 20 more fields]
(408) Project
Arguments: [orderProposalId#1002354L, orderProposalItemId#1002362, supplierGroup#1002338, supplier#1002339, plant#1002340, deliveryDateTime#1002341, subrange#1002342, supplyingPlant#1002343, productGroup#1002344, product#1002345, orderDateTime#1002346, availabilityDateTime#1002347, nextAvailabilityDateTime#1002348, mrpController#1002349, sourceOfSupplyUuid#1002350, purchasingOrg#1002351, purchasingGroup#1002352, isFallbackOrderOnly#1002353, orderProposalHorizonGroupingId#1002355L, splitIndicator#1002356L, previousOrderProposal#1002357L, clusterId#1002358L, sequenceId#1002359, worklistShardItemId#1002360L, orderProposalItemGroupId#1002361, ... 19 more fields]
(409) Generate
Arguments: explode(optimizationGroups#1002493), true, [optGroupId#1002494]
(410) Project
Arguments: [orderProposalId#1002354L, optGroupId#1002494]
(411) Deduplicate
Arguments: [orderProposalId#1002354L, optGroupId#1002494]
(412) LogicalRelation
Arguments: parquet, [optGroupId#1002495, assignmentDetails#1002496, minOrderProfile#1002497, multiplerestrictionprofile#1002498], false
(413) Repartition
Arguments: 25, true
(414) Filter
Arguments: (isnotnull(optGroupId#1002495) AND isnotnull(minOrderProfile#1002497))
(415) Join
Arguments: Inner, (optGroupId#1002494 = optGroupId#1002495)
(416) Project
Arguments: [optGroupId#1002494, orderProposalId#1002354L, assignmentDetails#1002496, minOrderProfile#1002497, multiplerestrictionprofile#1002498]
(417) Join
Arguments: LeftOuter, (orderProposalId#1002198L = orderProposalId#1002354L)
(418) Project
Arguments: [orderProposalId#1002198L, sequenceId#1002203, optGroupId#1002494, assignmentDetails#1002496, minOrderProfile#1002497, multiplerestrictionprofile#1002498]
(419) LogicalRelation
Arguments: parquet, [supplierminimumprofilename#1002155, descriptions#1002156, dimensionType#1002157, dimensionValue#1002158, dimensionUnit#1002159, acceptanceThreshold#1002160, profileType#1002161, eventtype#1002162], false
(420) Repartition
Arguments: 25, true
(421) Join
Arguments: Inner, (minOrderProfile#1002497 <=> supplierminimumprofilename#1002155)
(422) LogicalRelation
Arguments: parquet, [systemId#1002163, internalUUID#1002164, code#1002165, name#1002166, commercialCode#1002167, isoCode#1002168], false
(423) Repartition
Arguments: 25, true
(424) Join
Arguments: LeftOuter, (dimensionUnit#1002159.dimensionCodeUuid <=> internalUUID#1002164)
(425) Project
Arguments: [orderProposalId#1002198L, sequenceId#1002203, optGroupId#1002494, assignmentDetails#1002496, minOrderProfile#1002497, multiplerestrictionprofile#1002498, supplierminimumprofilename#1002155, descriptions#1002156, dimensionType#1002157, dimensionValue#1002158, dimensionUnit#1002159, acceptanceThreshold#1002160, profileType#1002161, eventtype#1002162, systemId#1002163, internalUUID#1002164, code#1002165, name#1002166, commercialCode#1002167, isoCode#1002168, struct(minOrderValue, dimensionValue#1002158, dimensionType, dimensionType#1002157, unit, dimensionUnit#1002159.dimensionCode, unitUuid, dimensionUnit#1002159.dimensionCodeUuid, negligibleQuantitiesThreshold, 0.0, acceptanceThreshold, (acceptanceThreshold#1002160 / cast(100 as double)), isoCode, isoCode#1002168.code) AS minOrderGoal#1002178]
(426) Project
Arguments: [orderProposalId#1002198L, sequenceId#1002203, optGroupId#1002494, assignmentDetails#1002496, minOrderProfile#1002497, multiplerestrictionprofile#1002498, systemId#1002163, internalUUID#1002164, code#1002165, name#1002166, commercialCode#1002167, isoCode#1002168, minOrderGoal#1002178]
(427) Project
Arguments: [orderProposalId#1002198L, sequenceId#1002203, optGroupId#1002494, assignmentDetails#1002496, minOrderProfile#1002497, multiplerestrictionprofile#1002498, minOrderGoal#1002178]
(428) Project
Arguments: [orderProposalId#1002198L, optGroupId#1002494, assignmentDetails#1002496, minOrderProfile#1002497, multiplerestrictionprofile#1002498, minOrderGoal#1002178]
(429) Join
Arguments: LeftOuter, (orderProposalId#1000986L = orderProposalId#1002198L)
(430) Project
Arguments: [orderProposalId#1000986L, sequenceId#1000991, optGroupId#1002494, assignmentDetails#1002496, minOrderProfile#1002497, multiplerestrictionprofile#1002498, minOrderGoal#1002178]
(431) Aggregate
Arguments: [orderProposalId#1000986L, sequenceId#1000991], [orderProposalId#1000986L, sequenceId#1000991, collect_list(struct(optGroupId, optGroupId#1002494, assignmentDetails, assignmentDetails#1002496, minOrderProfile, minOrderProfile#1002497, multiplerestrictionprofile, multiplerestrictionprofile#1002498, minOrderGoal, minOrderGoal#1002178), 0, 0) AS optimizationGroups#1002510]
(432) Project
Arguments: [orderProposalId#1000986L, sequenceId#1000991, filter(optimizationGroups#1002510, lambdafunction(isnotnull(lambda x_2623#1002520.optGroupId), lambda x_2623#1002520, false)) AS optimizationGroups#1002519]
(433) Generate
Arguments: explode(optimizationGroups#1002519.minOrderGoal), false, [minOrderGoal#1005109]
(434) Project
Arguments: [minOrderGoal#1005109]
(435) Filter
Arguments: (minOrderGoal#1005109.dimensionType <=> 2)
(436) Project
Arguments: [minOrderGoal#1005109.unit AS uomCategoryName#1005111]
(437) LogicalRelation
Arguments: parquet, [uomCategoryName#1005102, descriptions#1005103, uoms#1005104, validTo#1005105, eventtype#1005106], false
(438) Repartition
Arguments: 25, true
(439) Join
Arguments: LeftOuter, (uomCategoryName#1005111 = uomCategoryName#1005102)
(440) Project
Arguments: [uomCategoryName#1005111, descriptions#1005103, uoms#1005104, validTo#1005105, eventtype#1005106]
(441) Project
Arguments: [uomCategoryName#1005111, descriptions#1005103, coalesce(uoms#1005104, cast(array() as array<struct<internalRefUUID:string,id:string>>)) AS uoms#1005114, validTo#1005105, eventtype#1005106]
(442) Project
Arguments: [uomCategoryName#1005111, descriptions#1005103, transform(uoms#1005114, lambdafunction(struct(uom, lambda x_2624#1005118.id, uomUuid, lambda x_2624#1005118.internalRefUUID), lambda x_2624#1005118, false)) AS uoms#1005117, validTo#1005105, eventtype#1005106]
(443) Project
Arguments: [uomCategoryName#1005111, descriptions#1005103, uoms#1005117, validTo#1005105, eventtype#1005106, struct(uomCategoryName, uomCategoryName#1005111, uoms, uoms#1005117) AS uomCategory#1005119]
(444) Project
Arguments: [uomCategoryName#1005111, descriptions#1005103, uoms#1005117, validTo#1005105, eventtype#1005106, uomCategory#1005119, dummy AS dummy#1005120]
(445) Aggregate
Arguments: [dummy#1005120], [dummy#1005120, collect_set(uomCategory#1005119, 0, 0) AS uomCategories#1005121]
(446) Join
Arguments: LeftOuter, (dummy#1005130 = dummy#1005120)
(447) Project
Arguments: [dummy#1005130, uomCategories#1005121]
(448) Project
Arguments: [dummy#1005130, coalesce(uomCategories#1005121, cast(array() as array<struct<uomCategoryName:string,uoms:array<struct<uom:string,uomUuid:string>>>>)) AS uomCategories#1005131]
(449) Project
Arguments: [uomCategories#1005131]
(450) LogicalRelation
Arguments: parquet, [name#1005132, category#1005133, status#1005134, configurationVersion#1005135, businessContext#1005136, message#1005137, settings#1005138, eventtype#1005139], false
(451) Repartition
Arguments: 25, true
(452) Filter
Arguments: (isnotnull(configurationVersion#1005135) AND isnotnull(name#1005132))
(453) Aggregate
Arguments: [name#1005132], [name#1005132, max(struct(configurationVersion, configurationVersion#1005135, status, status#1005134, settings, settings#1005138)) AS best#1005141]
(454) Filter
Arguments: (best#1005141.status = ACTIVE)
(455) Project
Arguments: [name#1005132, best#1005141.settings AS settings#1005152, best#1005141.configurationVersion AS configurationVersion#1005153]
(456) Aggregate
Arguments: [map_from_entries(collect_list(struct(name, name#1005132, configValue, struct(configurationVersion, configurationVersion#1005153, name, name#1005132, settings, settings#1005152, status, ACTIVE)), 0, 0)) AS insightConfigurations#1005156]
(457) Join
Arguments: Cross
(458) Project
Arguments: [uomCategories#1005131, coalesce(insightConfigurations#1005156, cast(map() as map<string,struct<configurationVersion:string,name:string,settings:array<struct<name:string,type:string,value:string>>,status:string>>)) AS insightConfigurations#1005161]
(459) Project
Arguments: [uomCategories#1005131, insightConfigurations#1005161, 0_1_10000002111 AS shardId#1008226]