== 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@610381dc, [__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/10000002108], Overwrite
(3) LocalRelation
(4) Project
Arguments: [dummy AS dummy#736435]
(5) LogicalRelation
Arguments: parquet, [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299], false
(6) RepartitionByExpression
Arguments: [product#732282, plant#732277], 25
(7) LogicalRelation
Arguments: parquet, [systemId#732301, internalUUID#732302, supplier#732303, receiver#732304, product#732305, receivingPlant#732306, sourceOfSupplyType#732307, purchasingGroup#732308, purchasingOrganization#732309, productGroup#732310, validFrom#732311, validTo#732312, priority#732313, isPurchasingBlocked#732314, isConsignment#732315, isDeleted#732316, supplierSubrange#732317, plannedDeliveryTimeDays#732318, orderQuantityUnit#732319, purchasingPriceAspect#732320, orderCurrency#732321, minimumOrderQuantity#732322, logisticalRoundingProfile#732323, supplyingPlant#732324], false
(8) Repartition
Arguments: 25, true
(9) SubqueryAlias
Arguments: sos
(10) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#732287 <=> internalUUID#732302)
(11) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 25 more fields]
(12) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 1 more fields]
(13) LogicalRelation
Arguments: parquet, [systemId#732329, internalUUID#732330, plant#732331, product#732332, blockedForReplenishmentStartingFrom#732333, productionAspect#732334, salesPlant#732335, listing#732336], false
(14) Repartition
Arguments: 25, true
(15) Filter
Arguments: plant#732331.internalRefUUID IN (1c037502c75549dc72c6fc87c802bcec,717937a4d5db853d3359b6a0623cfdf0,4d233bd0bf112aded9d852448354b078,fca7a07ad5f143db2beafbd1d0401ea1,45f9c5206af43e1e6acbe19d9a246289,6d24a939f4bbd79f6acb8684d6e45c97,3d84243e56ebf98292ed5dba2fd51543,24a9ebb440508219166784d4d1c19eef,f80b06f7b2102a5f5c63b031eb5d8e03,25c0d9731dd07bb53999d9a8f04398e0)
(16) SubqueryAlias
Arguments: pp
(17) Join
Arguments: LeftOuter, ((product#732282 <=> product#732332.internalRefUUID) AND (plant#732277 <=> plant#732331.internalRefUUID))
(18) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 10 more fields]
(19) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 11 more fields]
(20) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 12 more fields]
(21) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 4 more fields]
(22) LogicalRelation
Arguments: parquet, [systemId#732346, internalUUID#732347, id#732348, displayId#732349, name#732350, baseUnitOfMeasure#732351, unitOfMeasures#732352, unitOfMeasureConversions#732353, productionAspect#732354, salesAspect#732355, procurementAspect#732356, productGroup#732357], false
(23) Repartition
Arguments: 25, true
(24) SubqueryAlias
Arguments: tmp
(25) Join
Arguments: LeftOuter, (product#732282 = internalUUID#732347)
(26) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 17 more fields]
(27) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 5 more fields]
(28) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 6 more fields]
(29) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 7 more fields]
(30) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 8 more fields]
(31) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 8 more fields]
(32) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 9 more fields]
(33) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 10 more fields]
(34) SubqueryAlias
Arguments: worklist
(35) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#732389, plant#732390, logisticalRoundingRule#732391]
(36) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(37) Join
Arguments: LeftOuter, ((preferredRoundingProfile#732382 <=> logisticalRoundingProfile#732389) AND (plant#732277 <=> plant#732390.internalRefUUID))
(38) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#732416, plant#732417, logisticalRoundingRule#732418]
(39) Filter
Arguments: isnull(plant#732417.internalRefUUID)
(40) SubqueryAlias
Arguments: allPlantRoundingProfiles
(41) Join
Arguments: LeftOuter, (preferredRoundingProfile#732382 <=> logisticalRoundingProfile#732416)
(42) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 17 more fields]
(43) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 11 more fields]
(44) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#732407, unitOfMeasure#732408]
(45) Aggregate
Arguments: [logisticalRoundingRule#732407], [logisticalRoundingRule#732407, collect_list(unitOfMeasure#732408.internalRefUUID, 0, 0) AS preferredUOMs#732409]
(46) Join
Arguments: LeftOuter, (logisticalRoundingRule#732420.logisticalRoundingRule = logisticalRoundingRule#732407)
(47) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 11 more fields]
(48) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 11 more fields]
(49) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 11 more fields]
(50) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 8 more fields]
(51) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 9 more fields]
(52) LogicalRelation
Arguments: parquet, [product#732433, plant#732434, orderDateTime#732435, constraintprofile#732436], false
(53) Repartition
Arguments: 25, true
(54) Join
Arguments: LeftOuter, (((product#732282 <=> product#732433) AND (plant#732277 <=> plant#732434)) AND (orderDateTime#732283 <=> orderDateTime#732435))
(55) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 10 more fields]
(56) LogicalRelation
Arguments: parquet, [constraintProfile#732437, descriptions#732438, minServiceLevel#732439, minServiceLevelMinStock#732440, maxServiceLevelEndListing#732441, maxRangeCoverage#732442, minOrderQuantity#732443, profileType#732444, eventtype#732445], false
(57) Repartition
Arguments: 25, true
(58) Join
Arguments: LeftOuter, (constraintProfile#732436 <=> constraintProfile#732437)
(59) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 20 more fields]
(60) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 10 more fields]
(61) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 10 more fields]
(62) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 15 more fields]
(63) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 15 more fields]
(64) Project
Arguments: [supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalId#732291L, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, orderProposalItemId#732299, ... 14 more fields]
(65) LocalRelation
Arguments: <empty>, [orderProposalId#732474, orderProposalItemId#732475, constraintOverwrites#732476]
(66) Project
Arguments: [orderProposalId#732474, orderProposalItemId#732475, filter(constraintOverwrites#732476, lambdafunction(((isnotnull(lambda x_1925#732478.label) AND isnotnull(lambda x_1925#732478.isActive)) AND (((lambda x_1925#732478.isActive = false) OR isnotnull(lambda x_1925#732478.value)) OR (lambda x_1925#732478.label <=> minOrderQuantity))), lambda x_1925#732478, false)) AS constraintOverwrites#732477]
(67) Project
Arguments: [orderProposalId#732474, orderProposalItemId#732475, transform(constraintOverwrites#732477, lambdafunction(struct(label, lambda x_1926#732483.label, value, CASE WHEN ((lambda x_1926#732483.label = minOrderQuantity) OR (lambda x_1926#732483.label = lockedOrderQuantity)) THEN round(lambda x_1926#732483.value, 0) ELSE lambda x_1926#732483.value END, isActive, lambda x_1926#732483.isActive), lambda x_1926#732483, false)) AS constraintOverwrites#732482]
(68) Join
Arguments: LeftOuter, ((orderProposalId#732291L = cast(orderProposalId#732474 as bigint)) AND (orderProposalItemId#732299 = orderProposalItemId#732475))
(69) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 15 more fields]
(70) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 15 more fields]
(71) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 15 more fields]
(72) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 15 more fields]
(73) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 14 more fields]
(74) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 15 more fields]
(75) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 16 more fields]
(76) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 17 more fields]
(77) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 18 more fields]
(78) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 19 more fields]
(79) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 20 more fields]
(80) LogicalRelation
Arguments: parquet, [systemId#732513, internalUUID#732514, code#732515, name#732516, commercialCode#732517, isoCode#732518], false
(81) Repartition
Arguments: 25, true
(82) SubqueryAlias
Arguments: unitOfMeasure
(83) Join
Arguments: LeftOuter, (filter(filter(productInformation#732358.unitOfMeasures, lambdafunction((lambda x_1937#732528.measurementUnit.internalRefUUID = productInformation#732358.baseUnitOfMeasure.internalRefUUID), lambda x_1937#732528, false))[0].productDimensions, lambdafunction((lambda x_1938#732530.dimensionName.code = VOLUME), lambda x_1938#732530, false))[0].measurementUnit.internalRefUUID <=> internalUUID#732514)
(84) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 21 more fields]
(85) LogicalRelation
Arguments: parquet, [systemId#732549, internalUUID#732550, code#732551, name#732552, commercialCode#732553, isoCode#732554], false
(86) Repartition
Arguments: 25, true
(87) SubqueryAlias
Arguments: unitOfMeasure
(88) Join
Arguments: LeftOuter, (filter(filter(productInformation#732358.unitOfMeasures, lambdafunction((lambda x_1939#732556.measurementUnit.internalRefUUID = productInformation#732358.baseUnitOfMeasure.internalRefUUID), lambda x_1939#732556, false))[0].productDimensions, lambdafunction((lambda x_1940#732558.dimensionName.code = GROSS_WT), lambda x_1940#732558, false))[0].measurementUnit.internalRefUUID <=> internalUUID#732550)
(89) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 22 more fields]
(90) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 20 more fields]
(91) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 21 more fields]
(92) LogicalRelation
Arguments: parquet, [supplier#732580, subrange#732581, plant#732582, deliverydatetime#732583, ordergroupingprofile#732584, supplierGroup#732585, locationGroup#732586, optimizationGroups#732587], false
(93) Repartition
Arguments: 25, true
(94) Project
Arguments: [supplier#732580, subrange#732581, plant#732582, deliverydatetime#732583, ordergroupingprofile#732584, supplierGroup#732585, locationGroup#732586, optimizationGroups#732587, cast(null as string) AS supplyingPlant#732589]
(95) Project
Arguments: [supplier#732580, subrange#732581, plant#732582, deliverydatetime#732583, ordergroupingprofile#732584, supplierGroup#732585, locationGroup#732586, optimizationGroups#732587, supplyingPlant#732589, cast(null as string) AS productGroup#732590]
(96) Join
Arguments: LeftOuter, (((((((supplierGroup#732275 <=> supplierGroup#732585) AND (supplier#732276 <=> supplier#732580)) AND (subrange#732279 <=> subrange#732581)) AND (plant#732277 <=> plant#732582)) AND (deliveryDateTime#732278 <=> deliveryDateTime#732583)) AND (supplyingPlant#732280 <=> supplyingPlant#732589)) AND (productGroup#732281 <=> productGroup#732590))
(97) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 22 more fields]
(98) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 22 more fields]
(99) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 21 more fields]
(100) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 20 more fields]
(101) Project
Arguments: [orderProposalId#732291L, orderProposalItemId#732299, supplierGroup#732275, supplier#732276, plant#732277, deliveryDateTime#732278, subrange#732279, supplyingPlant#732280, productGroup#732281, product#732282, orderDateTime#732283, availabilityDateTime#732284, nextAvailabilityDateTime#732285, mrpController#732286, sourceOfSupplyUuid#732287, purchasingOrg#732288, purchasingGroup#732289, isFallbackOrderOnly#732290, orderProposalHorizonGroupingId#732292L, splitIndicator#732293L, previousOrderProposal#732294L, clusterId#732295L, sequenceId#732296, worklistShardItemId#732297L, orderProposalItemGroupId#732298, ... 19 more fields]
(102) Project
Arguments: [orderProposalId#732291L, sequenceId#732296]
(103) Deduplicate
Arguments: [orderProposalId#732291L, sequenceId#732296]
(104) LogicalRelation
Arguments: parquet, [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323], false
(105) RepartitionByExpression
Arguments: [product#733306, plant#733301], 25
(106) LogicalRelation
Arguments: parquet, [systemId#733324, internalUUID#733325, supplier#733326, receiver#733327, product#733328, receivingPlant#733329, sourceOfSupplyType#733330, purchasingGroup#733331, purchasingOrganization#733332, productGroup#733333, validFrom#733334, validTo#733335, priority#733336, isPurchasingBlocked#733337, isConsignment#733338, isDeleted#733339, supplierSubrange#733340, plannedDeliveryTimeDays#733341, orderQuantityUnit#733342, purchasingPriceAspect#733343, orderCurrency#733344, minimumOrderQuantity#733345, logisticalRoundingProfile#733346, supplyingPlant#733347], false
(107) Repartition
Arguments: 25, true
(108) SubqueryAlias
Arguments: sos
(109) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#733311 <=> internalUUID#733325)
(110) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 25 more fields]
(111) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 1 more fields]
(112) LogicalRelation
Arguments: parquet, [systemId#733349, internalUUID#733350, plant#733351, product#733352, blockedForReplenishmentStartingFrom#733353, productionAspect#733354, salesPlant#733355, listing#733356], false
(113) Repartition
Arguments: 25, true
(114) Filter
Arguments: plant#733351.internalRefUUID IN (1c037502c75549dc72c6fc87c802bcec,717937a4d5db853d3359b6a0623cfdf0,4d233bd0bf112aded9d852448354b078,fca7a07ad5f143db2beafbd1d0401ea1,45f9c5206af43e1e6acbe19d9a246289,6d24a939f4bbd79f6acb8684d6e45c97,3d84243e56ebf98292ed5dba2fd51543,24a9ebb440508219166784d4d1c19eef,f80b06f7b2102a5f5c63b031eb5d8e03,25c0d9731dd07bb53999d9a8f04398e0)
(115) SubqueryAlias
Arguments: pp
(116) Join
Arguments: LeftOuter, ((product#733306 <=> product#733352.internalRefUUID) AND (plant#733301 <=> plant#733351.internalRefUUID))
(117) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 10 more fields]
(118) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 11 more fields]
(119) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 12 more fields]
(120) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 4 more fields]
(121) LogicalRelation
Arguments: parquet, [systemId#733360, internalUUID#733361, id#733362, displayId#733363, name#733364, baseUnitOfMeasure#733365, unitOfMeasures#733366, unitOfMeasureConversions#733367, productionAspect#733368, salesAspect#733369, procurementAspect#733370, productGroup#733371], false
(122) Repartition
Arguments: 25, true
(123) SubqueryAlias
Arguments: tmp
(124) Join
Arguments: LeftOuter, (product#733306 = internalUUID#733361)
(125) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 17 more fields]
(126) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 5 more fields]
(127) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 6 more fields]
(128) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 7 more fields]
(129) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 8 more fields]
(130) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 8 more fields]
(131) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 9 more fields]
(132) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 10 more fields]
(133) SubqueryAlias
Arguments: worklist
(134) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#733379, plant#733380, logisticalRoundingRule#733381]
(135) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(136) Join
Arguments: LeftOuter, ((preferredRoundingProfile#733378 <=> logisticalRoundingProfile#733379) AND (plant#733301 <=> plant#733380.internalRefUUID))
(137) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#733382, plant#733383, logisticalRoundingRule#733384]
(138) Filter
Arguments: isnull(plant#733383.internalRefUUID)
(139) SubqueryAlias
Arguments: allPlantRoundingProfiles
(140) Join
Arguments: LeftOuter, (preferredRoundingProfile#733378 <=> logisticalRoundingProfile#733382)
(141) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 17 more fields]
(142) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 11 more fields]
(143) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#733387, unitOfMeasure#733388]
(144) Aggregate
Arguments: [logisticalRoundingRule#733387], [logisticalRoundingRule#733387, collect_list(unitOfMeasure#733388.internalRefUUID, 0, 0) AS preferredUOMs#733389]
(145) Join
Arguments: LeftOuter, (logisticalRoundingRule#733386.logisticalRoundingRule = logisticalRoundingRule#733387)
(146) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 11 more fields]
(147) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 11 more fields]
(148) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 11 more fields]
(149) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 8 more fields]
(150) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 9 more fields]
(151) LogicalRelation
Arguments: parquet, [product#733393, plant#733394, orderDateTime#733395, constraintprofile#733396], false
(152) Repartition
Arguments: 25, true
(153) Join
Arguments: LeftOuter, (((product#733306 <=> product#733393) AND (plant#733301 <=> plant#733394)) AND (orderDateTime#733307 <=> orderDateTime#733395))
(154) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 10 more fields]
(155) LogicalRelation
Arguments: parquet, [constraintProfile#733397, descriptions#733398, minServiceLevel#733399, minServiceLevelMinStock#733400, maxServiceLevelEndListing#733401, maxRangeCoverage#733402, minOrderQuantity#733403, profileType#733404, eventtype#733405], false
(156) Repartition
Arguments: 25, true
(157) Join
Arguments: LeftOuter, (constraintProfile#733396 <=> constraintProfile#733397)
(158) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 20 more fields]
(159) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 10 more fields]
(160) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 10 more fields]
(161) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 15 more fields]
(162) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 15 more fields]
(163) Project
Arguments: [supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalId#733315L, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, orderProposalItemId#733323, ... 14 more fields]
(164) LocalRelation
Arguments: <empty>, [orderProposalId#733414, orderProposalItemId#733415, constraintOverwrites#733416]
(165) Project
Arguments: [orderProposalId#733414, orderProposalItemId#733415, filter(constraintOverwrites#733416, lambdafunction(((isnotnull(lambda x_1925#732478.label) AND isnotnull(lambda x_1925#732478.isActive)) AND (((lambda x_1925#732478.isActive = false) OR isnotnull(lambda x_1925#732478.value)) OR (lambda x_1925#732478.label <=> minOrderQuantity))), lambda x_1925#732478, false)) AS constraintOverwrites#733417]
(166) Project
Arguments: [orderProposalId#733414, orderProposalItemId#733415, transform(constraintOverwrites#733417, lambdafunction(struct(label, lambda x_1926#732483.label, value, CASE WHEN ((lambda x_1926#732483.label = minOrderQuantity) OR (lambda x_1926#732483.label = lockedOrderQuantity)) THEN round(lambda x_1926#732483.value, 0) ELSE lambda x_1926#732483.value END, isActive, lambda x_1926#732483.isActive), lambda x_1926#732483, false)) AS constraintOverwrites#733418]
(167) Join
Arguments: LeftOuter, ((orderProposalId#733315L = cast(orderProposalId#733414 as bigint)) AND (orderProposalItemId#733323 = orderProposalItemId#733415))
(168) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 15 more fields]
(169) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 15 more fields]
(170) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 15 more fields]
(171) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 15 more fields]
(172) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 14 more fields]
(173) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 15 more fields]
(174) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 16 more fields]
(175) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 17 more fields]
(176) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 18 more fields]
(177) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 19 more fields]
(178) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 20 more fields]
(179) LogicalRelation
Arguments: parquet, [systemId#733428, internalUUID#733429, code#733430, name#733431, commercialCode#733432, isoCode#733433], false
(180) Repartition
Arguments: 25, true
(181) SubqueryAlias
Arguments: unitOfMeasure
(182) Join
Arguments: LeftOuter, (filter(filter(productInformation#733372.unitOfMeasures, lambdafunction((lambda x_1937#732528.measurementUnit.internalRefUUID = productInformation#733372.baseUnitOfMeasure.internalRefUUID), lambda x_1937#732528, false))[0].productDimensions, lambdafunction((lambda x_1938#732530.dimensionName.code = VOLUME), lambda x_1938#732530, false))[0].measurementUnit.internalRefUUID <=> internalUUID#733429)
(183) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 21 more fields]
(184) LogicalRelation
Arguments: parquet, [systemId#733435, internalUUID#733436, code#733437, name#733438, commercialCode#733439, isoCode#733440], false
(185) Repartition
Arguments: 25, true
(186) SubqueryAlias
Arguments: unitOfMeasure
(187) Join
Arguments: LeftOuter, (filter(filter(productInformation#733372.unitOfMeasures, lambdafunction((lambda x_1939#732556.measurementUnit.internalRefUUID = productInformation#733372.baseUnitOfMeasure.internalRefUUID), lambda x_1939#732556, false))[0].productDimensions, lambdafunction((lambda x_1940#732558.dimensionName.code = GROSS_WT), lambda x_1940#732558, false))[0].measurementUnit.internalRefUUID <=> internalUUID#733436)
(188) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 22 more fields]
(189) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 20 more fields]
(190) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 21 more fields]
(191) LogicalRelation
Arguments: parquet, [supplier#733444, subrange#733445, plant#733446, deliverydatetime#733447, ordergroupingprofile#733448, supplierGroup#733449, locationGroup#733450, optimizationGroups#733451], false
(192) Repartition
Arguments: 25, true
(193) Project
Arguments: [supplier#733444, subrange#733445, plant#733446, deliverydatetime#733447, ordergroupingprofile#733448, supplierGroup#733449, locationGroup#733450, optimizationGroups#733451, cast(null as string) AS supplyingPlant#733452]
(194) Project
Arguments: [supplier#733444, subrange#733445, plant#733446, deliverydatetime#733447, ordergroupingprofile#733448, supplierGroup#733449, locationGroup#733450, optimizationGroups#733451, supplyingPlant#733452, cast(null as string) AS productGroup#733453]
(195) Join
Arguments: LeftOuter, (((((((supplierGroup#733299 <=> supplierGroup#733449) AND (supplier#733300 <=> supplier#733444)) AND (subrange#733303 <=> subrange#733445)) AND (plant#733301 <=> plant#733446)) AND (deliveryDateTime#733302 <=> deliveryDateTime#733447)) AND (supplyingPlant#733304 <=> supplyingPlant#733452)) AND (productGroup#733305 <=> productGroup#733453))
(196) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 22 more fields]
(197) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 22 more fields]
(198) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 21 more fields]
(199) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 20 more fields]
(200) Project
Arguments: [orderProposalId#733315L, orderProposalItemId#733323, supplierGroup#733299, supplier#733300, plant#733301, deliveryDateTime#733302, subrange#733303, supplyingPlant#733304, productGroup#733305, product#733306, orderDateTime#733307, availabilityDateTime#733308, nextAvailabilityDateTime#733309, mrpController#733310, sourceOfSupplyUuid#733311, purchasingOrg#733312, purchasingGroup#733313, isFallbackOrderOnly#733314, orderProposalHorizonGroupingId#733316L, splitIndicator#733317L, previousOrderProposal#733318L, clusterId#733319L, sequenceId#733320, worklistShardItemId#733321L, orderProposalItemGroupId#733322, ... 19 more fields]
(201) Generate
Arguments: explode(optimizationGroups#733454), true, [optGroupId#733298]
(202) Project
Arguments: [orderProposalId#733315L, optGroupId#733298]
(203) Deduplicate
Arguments: [orderProposalId#733315L, optGroupId#733298]
(204) LogicalRelation
Arguments: parquet, [optGroupId#733292, assignmentDetails#733293, minOrderProfile#733294, multiplerestrictionprofile#733295], false
(205) Repartition
Arguments: 25, true
(206) Filter
Arguments: (isnotnull(optGroupId#733292) AND isnotnull(minOrderProfile#733294))
(207) Join
Arguments: Inner, (optGroupId#733298 = optGroupId#733292)
(208) Project
Arguments: [optGroupId#733298, orderProposalId#733315L, assignmentDetails#733293, minOrderProfile#733294, multiplerestrictionprofile#733295]
(209) Join
Arguments: LeftOuter, (orderProposalId#732291L = orderProposalId#733315L)
(210) Project
Arguments: [orderProposalId#732291L, sequenceId#732296, optGroupId#733298, assignmentDetails#733293, minOrderProfile#733294, multiplerestrictionprofile#733295]
(211) Project
Arguments: [orderProposalId#732291L, sequenceId#732296]
(212) Deduplicate
Arguments: [orderProposalId#732291L, sequenceId#732296]
(213) LogicalRelation
Arguments: parquet, [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511], false
(214) RepartitionByExpression
Arguments: [product#733494, plant#733489], 25
(215) LogicalRelation
Arguments: parquet, [systemId#733512, internalUUID#733513, supplier#733514, receiver#733515, product#733516, receivingPlant#733517, sourceOfSupplyType#733518, purchasingGroup#733519, purchasingOrganization#733520, productGroup#733521, validFrom#733522, validTo#733523, priority#733524, isPurchasingBlocked#733525, isConsignment#733526, isDeleted#733527, supplierSubrange#733528, plannedDeliveryTimeDays#733529, orderQuantityUnit#733530, purchasingPriceAspect#733531, orderCurrency#733532, minimumOrderQuantity#733533, logisticalRoundingProfile#733534, supplyingPlant#733535], false
(216) Repartition
Arguments: 25, true
(217) SubqueryAlias
Arguments: sos
(218) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#733499 <=> internalUUID#733513)
(219) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 25 more fields]
(220) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 1 more fields]
(221) LogicalRelation
Arguments: parquet, [systemId#733537, internalUUID#733538, plant#733539, product#733540, blockedForReplenishmentStartingFrom#733541, productionAspect#733542, salesPlant#733543, listing#733544], false
(222) Repartition
Arguments: 25, true
(223) Filter
Arguments: plant#733539.internalRefUUID IN (1c037502c75549dc72c6fc87c802bcec,717937a4d5db853d3359b6a0623cfdf0,4d233bd0bf112aded9d852448354b078,fca7a07ad5f143db2beafbd1d0401ea1,45f9c5206af43e1e6acbe19d9a246289,6d24a939f4bbd79f6acb8684d6e45c97,3d84243e56ebf98292ed5dba2fd51543,24a9ebb440508219166784d4d1c19eef,f80b06f7b2102a5f5c63b031eb5d8e03,25c0d9731dd07bb53999d9a8f04398e0)
(224) SubqueryAlias
Arguments: pp
(225) Join
Arguments: LeftOuter, ((product#733494 <=> product#733540.internalRefUUID) AND (plant#733489 <=> plant#733539.internalRefUUID))
(226) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 10 more fields]
(227) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 11 more fields]
(228) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 12 more fields]
(229) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 4 more fields]
(230) LogicalRelation
Arguments: parquet, [systemId#733548, internalUUID#733549, id#733550, displayId#733551, name#733552, baseUnitOfMeasure#733553, unitOfMeasures#733554, unitOfMeasureConversions#733555, productionAspect#733556, salesAspect#733557, procurementAspect#733558, productGroup#733559], false
(231) Repartition
Arguments: 25, true
(232) SubqueryAlias
Arguments: tmp
(233) Join
Arguments: LeftOuter, (product#733494 = internalUUID#733549)
(234) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 17 more fields]
(235) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 5 more fields]
(236) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 6 more fields]
(237) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 7 more fields]
(238) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 8 more fields]
(239) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 8 more fields]
(240) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 9 more fields]
(241) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 10 more fields]
(242) SubqueryAlias
Arguments: worklist
(243) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#733567, plant#733568, logisticalRoundingRule#733569]
(244) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(245) Join
Arguments: LeftOuter, ((preferredRoundingProfile#733566 <=> logisticalRoundingProfile#733567) AND (plant#733489 <=> plant#733568.internalRefUUID))
(246) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#733570, plant#733571, logisticalRoundingRule#733572]
(247) Filter
Arguments: isnull(plant#733571.internalRefUUID)
(248) SubqueryAlias
Arguments: allPlantRoundingProfiles
(249) Join
Arguments: LeftOuter, (preferredRoundingProfile#733566 <=> logisticalRoundingProfile#733570)
(250) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 17 more fields]
(251) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 11 more fields]
(252) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#733575, unitOfMeasure#733576]
(253) Aggregate
Arguments: [logisticalRoundingRule#733575], [logisticalRoundingRule#733575, collect_list(unitOfMeasure#733576.internalRefUUID, 0, 0) AS preferredUOMs#733577]
(254) Join
Arguments: LeftOuter, (logisticalRoundingRule#733574.logisticalRoundingRule = logisticalRoundingRule#733575)
(255) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 11 more fields]
(256) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 11 more fields]
(257) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 11 more fields]
(258) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 8 more fields]
(259) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 9 more fields]
(260) LogicalRelation
Arguments: parquet, [product#733581, plant#733582, orderDateTime#733583, constraintprofile#733584], false
(261) Repartition
Arguments: 25, true
(262) Join
Arguments: LeftOuter, (((product#733494 <=> product#733581) AND (plant#733489 <=> plant#733582)) AND (orderDateTime#733495 <=> orderDateTime#733583))
(263) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 10 more fields]
(264) LogicalRelation
Arguments: parquet, [constraintProfile#733585, descriptions#733586, minServiceLevel#733587, minServiceLevelMinStock#733588, maxServiceLevelEndListing#733589, maxRangeCoverage#733590, minOrderQuantity#733591, profileType#733592, eventtype#733593], false
(265) Repartition
Arguments: 25, true
(266) Join
Arguments: LeftOuter, (constraintProfile#733584 <=> constraintProfile#733585)
(267) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 20 more fields]
(268) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 10 more fields]
(269) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 10 more fields]
(270) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 15 more fields]
(271) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 15 more fields]
(272) Project
Arguments: [supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalId#733503L, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, orderProposalItemId#733511, ... 14 more fields]
(273) LocalRelation
Arguments: <empty>, [orderProposalId#733602, orderProposalItemId#733603, constraintOverwrites#733604]
(274) Project
Arguments: [orderProposalId#733602, orderProposalItemId#733603, filter(constraintOverwrites#733604, lambdafunction(((isnotnull(lambda x_1925#732478.label) AND isnotnull(lambda x_1925#732478.isActive)) AND (((lambda x_1925#732478.isActive = false) OR isnotnull(lambda x_1925#732478.value)) OR (lambda x_1925#732478.label <=> minOrderQuantity))), lambda x_1925#732478, false)) AS constraintOverwrites#733605]
(275) Project
Arguments: [orderProposalId#733602, orderProposalItemId#733603, transform(constraintOverwrites#733605, lambdafunction(struct(label, lambda x_1926#732483.label, value, CASE WHEN ((lambda x_1926#732483.label = minOrderQuantity) OR (lambda x_1926#732483.label = lockedOrderQuantity)) THEN round(lambda x_1926#732483.value, 0) ELSE lambda x_1926#732483.value END, isActive, lambda x_1926#732483.isActive), lambda x_1926#732483, false)) AS constraintOverwrites#733606]
(276) Join
Arguments: LeftOuter, ((orderProposalId#733503L = cast(orderProposalId#733602 as bigint)) AND (orderProposalItemId#733511 = orderProposalItemId#733603))
(277) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 15 more fields]
(278) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 15 more fields]
(279) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 15 more fields]
(280) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 15 more fields]
(281) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 14 more fields]
(282) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 15 more fields]
(283) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 16 more fields]
(284) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 17 more fields]
(285) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 18 more fields]
(286) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 19 more fields]
(287) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 20 more fields]
(288) LogicalRelation
Arguments: parquet, [systemId#733616, internalUUID#733617, code#733618, name#733619, commercialCode#733620, isoCode#733621], false
(289) Repartition
Arguments: 25, true
(290) SubqueryAlias
Arguments: unitOfMeasure
(291) Join
Arguments: LeftOuter, (filter(filter(productInformation#733560.unitOfMeasures, lambdafunction((lambda x_1937#732528.measurementUnit.internalRefUUID = productInformation#733560.baseUnitOfMeasure.internalRefUUID), lambda x_1937#732528, false))[0].productDimensions, lambdafunction((lambda x_1938#732530.dimensionName.code = VOLUME), lambda x_1938#732530, false))[0].measurementUnit.internalRefUUID <=> internalUUID#733617)
(292) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 21 more fields]
(293) LogicalRelation
Arguments: parquet, [systemId#733623, internalUUID#733624, code#733625, name#733626, commercialCode#733627, isoCode#733628], false
(294) Repartition
Arguments: 25, true
(295) SubqueryAlias
Arguments: unitOfMeasure
(296) Join
Arguments: LeftOuter, (filter(filter(productInformation#733560.unitOfMeasures, lambdafunction((lambda x_1939#732556.measurementUnit.internalRefUUID = productInformation#733560.baseUnitOfMeasure.internalRefUUID), lambda x_1939#732556, false))[0].productDimensions, lambdafunction((lambda x_1940#732558.dimensionName.code = GROSS_WT), lambda x_1940#732558, false))[0].measurementUnit.internalRefUUID <=> internalUUID#733624)
(297) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 22 more fields]
(298) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 20 more fields]
(299) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 21 more fields]
(300) LogicalRelation
Arguments: parquet, [supplier#733632, subrange#733633, plant#733634, deliverydatetime#733635, ordergroupingprofile#733636, supplierGroup#733637, locationGroup#733638, optimizationGroups#733639], false
(301) Repartition
Arguments: 25, true
(302) Project
Arguments: [supplier#733632, subrange#733633, plant#733634, deliverydatetime#733635, ordergroupingprofile#733636, supplierGroup#733637, locationGroup#733638, optimizationGroups#733639, cast(null as string) AS supplyingPlant#733640]
(303) Project
Arguments: [supplier#733632, subrange#733633, plant#733634, deliverydatetime#733635, ordergroupingprofile#733636, supplierGroup#733637, locationGroup#733638, optimizationGroups#733639, supplyingPlant#733640, cast(null as string) AS productGroup#733641]
(304) Join
Arguments: LeftOuter, (((((((supplierGroup#733487 <=> supplierGroup#733637) AND (supplier#733488 <=> supplier#733632)) AND (subrange#733491 <=> subrange#733633)) AND (plant#733489 <=> plant#733634)) AND (deliveryDateTime#733490 <=> deliveryDateTime#733635)) AND (supplyingPlant#733492 <=> supplyingPlant#733640)) AND (productGroup#733493 <=> productGroup#733641))
(305) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 22 more fields]
(306) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 22 more fields]
(307) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 21 more fields]
(308) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 20 more fields]
(309) Project
Arguments: [orderProposalId#733503L, orderProposalItemId#733511, supplierGroup#733487, supplier#733488, plant#733489, deliveryDateTime#733490, subrange#733491, supplyingPlant#733492, productGroup#733493, product#733494, orderDateTime#733495, availabilityDateTime#733496, nextAvailabilityDateTime#733497, mrpController#733498, sourceOfSupplyUuid#733499, purchasingOrg#733500, purchasingGroup#733501, isFallbackOrderOnly#733502, orderProposalHorizonGroupingId#733504L, splitIndicator#733505L, previousOrderProposal#733506L, clusterId#733507L, sequenceId#733508, worklistShardItemId#733509L, orderProposalItemGroupId#733510, ... 19 more fields]
(310) Project
Arguments: [orderProposalId#733503L, sequenceId#733508]
(311) Deduplicate
Arguments: [orderProposalId#733503L, sequenceId#733508]
(312) LogicalRelation
Arguments: parquet, [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667], false
(313) RepartitionByExpression
Arguments: [product#733650, plant#733645], 25
(314) LogicalRelation
Arguments: parquet, [systemId#733668, internalUUID#733669, supplier#733670, receiver#733671, product#733672, receivingPlant#733673, sourceOfSupplyType#733674, purchasingGroup#733675, purchasingOrganization#733676, productGroup#733677, validFrom#733678, validTo#733679, priority#733680, isPurchasingBlocked#733681, isConsignment#733682, isDeleted#733683, supplierSubrange#733684, plannedDeliveryTimeDays#733685, orderQuantityUnit#733686, purchasingPriceAspect#733687, orderCurrency#733688, minimumOrderQuantity#733689, logisticalRoundingProfile#733690, supplyingPlant#733691], false
(315) Repartition
Arguments: 25, true
(316) SubqueryAlias
Arguments: sos
(317) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#733655 <=> internalUUID#733669)
(318) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 25 more fields]
(319) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 1 more fields]
(320) LogicalRelation
Arguments: parquet, [systemId#733693, internalUUID#733694, plant#733695, product#733696, blockedForReplenishmentStartingFrom#733697, productionAspect#733698, salesPlant#733699, listing#733700], false
(321) Repartition
Arguments: 25, true
(322) Filter
Arguments: plant#733695.internalRefUUID IN (1c037502c75549dc72c6fc87c802bcec,717937a4d5db853d3359b6a0623cfdf0,4d233bd0bf112aded9d852448354b078,fca7a07ad5f143db2beafbd1d0401ea1,45f9c5206af43e1e6acbe19d9a246289,6d24a939f4bbd79f6acb8684d6e45c97,3d84243e56ebf98292ed5dba2fd51543,24a9ebb440508219166784d4d1c19eef,f80b06f7b2102a5f5c63b031eb5d8e03,25c0d9731dd07bb53999d9a8f04398e0)
(323) SubqueryAlias
Arguments: pp
(324) Join
Arguments: LeftOuter, ((product#733650 <=> product#733696.internalRefUUID) AND (plant#733645 <=> plant#733695.internalRefUUID))
(325) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 10 more fields]
(326) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 11 more fields]
(327) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 12 more fields]
(328) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 4 more fields]
(329) LogicalRelation
Arguments: parquet, [systemId#733704, internalUUID#733705, id#733706, displayId#733707, name#733708, baseUnitOfMeasure#733709, unitOfMeasures#733710, unitOfMeasureConversions#733711, productionAspect#733712, salesAspect#733713, procurementAspect#733714, productGroup#733715], false
(330) Repartition
Arguments: 25, true
(331) SubqueryAlias
Arguments: tmp
(332) Join
Arguments: LeftOuter, (product#733650 = internalUUID#733705)
(333) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 17 more fields]
(334) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 5 more fields]
(335) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 6 more fields]
(336) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 7 more fields]
(337) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 8 more fields]
(338) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 8 more fields]
(339) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 9 more fields]
(340) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 10 more fields]
(341) SubqueryAlias
Arguments: worklist
(342) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#733723, plant#733724, logisticalRoundingRule#733725]
(343) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(344) Join
Arguments: LeftOuter, ((preferredRoundingProfile#733722 <=> logisticalRoundingProfile#733723) AND (plant#733645 <=> plant#733724.internalRefUUID))
(345) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#733726, plant#733727, logisticalRoundingRule#733728]
(346) Filter
Arguments: isnull(plant#733727.internalRefUUID)
(347) SubqueryAlias
Arguments: allPlantRoundingProfiles
(348) Join
Arguments: LeftOuter, (preferredRoundingProfile#733722 <=> logisticalRoundingProfile#733726)
(349) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 17 more fields]
(350) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 11 more fields]
(351) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#733731, unitOfMeasure#733732]
(352) Aggregate
Arguments: [logisticalRoundingRule#733731], [logisticalRoundingRule#733731, collect_list(unitOfMeasure#733732.internalRefUUID, 0, 0) AS preferredUOMs#733733]
(353) Join
Arguments: LeftOuter, (logisticalRoundingRule#733730.logisticalRoundingRule = logisticalRoundingRule#733731)
(354) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 11 more fields]
(355) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 11 more fields]
(356) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 11 more fields]
(357) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 8 more fields]
(358) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 9 more fields]
(359) LogicalRelation
Arguments: parquet, [product#733737, plant#733738, orderDateTime#733739, constraintprofile#733740], false
(360) Repartition
Arguments: 25, true
(361) Join
Arguments: LeftOuter, (((product#733650 <=> product#733737) AND (plant#733645 <=> plant#733738)) AND (orderDateTime#733651 <=> orderDateTime#733739))
(362) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 10 more fields]
(363) LogicalRelation
Arguments: parquet, [constraintProfile#733741, descriptions#733742, minServiceLevel#733743, minServiceLevelMinStock#733744, maxServiceLevelEndListing#733745, maxRangeCoverage#733746, minOrderQuantity#733747, profileType#733748, eventtype#733749], false
(364) Repartition
Arguments: 25, true
(365) Join
Arguments: LeftOuter, (constraintProfile#733740 <=> constraintProfile#733741)
(366) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 20 more fields]
(367) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 10 more fields]
(368) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 10 more fields]
(369) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 15 more fields]
(370) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 15 more fields]
(371) Project
Arguments: [supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalId#733659L, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, orderProposalItemId#733667, ... 14 more fields]
(372) LocalRelation
Arguments: <empty>, [orderProposalId#733758, orderProposalItemId#733759, constraintOverwrites#733760]
(373) Project
Arguments: [orderProposalId#733758, orderProposalItemId#733759, filter(constraintOverwrites#733760, lambdafunction(((isnotnull(lambda x_1925#732478.label) AND isnotnull(lambda x_1925#732478.isActive)) AND (((lambda x_1925#732478.isActive = false) OR isnotnull(lambda x_1925#732478.value)) OR (lambda x_1925#732478.label <=> minOrderQuantity))), lambda x_1925#732478, false)) AS constraintOverwrites#733761]
(374) Project
Arguments: [orderProposalId#733758, orderProposalItemId#733759, transform(constraintOverwrites#733761, lambdafunction(struct(label, lambda x_1926#732483.label, value, CASE WHEN ((lambda x_1926#732483.label = minOrderQuantity) OR (lambda x_1926#732483.label = lockedOrderQuantity)) THEN round(lambda x_1926#732483.value, 0) ELSE lambda x_1926#732483.value END, isActive, lambda x_1926#732483.isActive), lambda x_1926#732483, false)) AS constraintOverwrites#733762]
(375) Join
Arguments: LeftOuter, ((orderProposalId#733659L = cast(orderProposalId#733758 as bigint)) AND (orderProposalItemId#733667 = orderProposalItemId#733759))
(376) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 15 more fields]
(377) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 15 more fields]
(378) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 15 more fields]
(379) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 15 more fields]
(380) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 14 more fields]
(381) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 15 more fields]
(382) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 16 more fields]
(383) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 17 more fields]
(384) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 18 more fields]
(385) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 19 more fields]
(386) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 20 more fields]
(387) LogicalRelation
Arguments: parquet, [systemId#733772, internalUUID#733773, code#733774, name#733775, commercialCode#733776, isoCode#733777], false
(388) Repartition
Arguments: 25, true
(389) SubqueryAlias
Arguments: unitOfMeasure
(390) Join
Arguments: LeftOuter, (filter(filter(productInformation#733716.unitOfMeasures, lambdafunction((lambda x_1937#732528.measurementUnit.internalRefUUID = productInformation#733716.baseUnitOfMeasure.internalRefUUID), lambda x_1937#732528, false))[0].productDimensions, lambdafunction((lambda x_1938#732530.dimensionName.code = VOLUME), lambda x_1938#732530, false))[0].measurementUnit.internalRefUUID <=> internalUUID#733773)
(391) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 21 more fields]
(392) LogicalRelation
Arguments: parquet, [systemId#733779, internalUUID#733780, code#733781, name#733782, commercialCode#733783, isoCode#733784], false
(393) Repartition
Arguments: 25, true
(394) SubqueryAlias
Arguments: unitOfMeasure
(395) Join
Arguments: LeftOuter, (filter(filter(productInformation#733716.unitOfMeasures, lambdafunction((lambda x_1939#732556.measurementUnit.internalRefUUID = productInformation#733716.baseUnitOfMeasure.internalRefUUID), lambda x_1939#732556, false))[0].productDimensions, lambdafunction((lambda x_1940#732558.dimensionName.code = GROSS_WT), lambda x_1940#732558, false))[0].measurementUnit.internalRefUUID <=> internalUUID#733780)
(396) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 22 more fields]
(397) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 20 more fields]
(398) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 21 more fields]
(399) LogicalRelation
Arguments: parquet, [supplier#733788, subrange#733789, plant#733790, deliverydatetime#733791, ordergroupingprofile#733792, supplierGroup#733793, locationGroup#733794, optimizationGroups#733795], false
(400) Repartition
Arguments: 25, true
(401) Project
Arguments: [supplier#733788, subrange#733789, plant#733790, deliverydatetime#733791, ordergroupingprofile#733792, supplierGroup#733793, locationGroup#733794, optimizationGroups#733795, cast(null as string) AS supplyingPlant#733796]
(402) Project
Arguments: [supplier#733788, subrange#733789, plant#733790, deliverydatetime#733791, ordergroupingprofile#733792, supplierGroup#733793, locationGroup#733794, optimizationGroups#733795, supplyingPlant#733796, cast(null as string) AS productGroup#733797]
(403) Join
Arguments: LeftOuter, (((((((supplierGroup#733643 <=> supplierGroup#733793) AND (supplier#733644 <=> supplier#733788)) AND (subrange#733647 <=> subrange#733789)) AND (plant#733645 <=> plant#733790)) AND (deliveryDateTime#733646 <=> deliveryDateTime#733791)) AND (supplyingPlant#733648 <=> supplyingPlant#733796)) AND (productGroup#733649 <=> productGroup#733797))
(404) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 22 more fields]
(405) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 22 more fields]
(406) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 21 more fields]
(407) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 20 more fields]
(408) Project
Arguments: [orderProposalId#733659L, orderProposalItemId#733667, supplierGroup#733643, supplier#733644, plant#733645, deliveryDateTime#733646, subrange#733647, supplyingPlant#733648, productGroup#733649, product#733650, orderDateTime#733651, availabilityDateTime#733652, nextAvailabilityDateTime#733653, mrpController#733654, sourceOfSupplyUuid#733655, purchasingOrg#733656, purchasingGroup#733657, isFallbackOrderOnly#733658, orderProposalHorizonGroupingId#733660L, splitIndicator#733661L, previousOrderProposal#733662L, clusterId#733663L, sequenceId#733664, worklistShardItemId#733665L, orderProposalItemGroupId#733666, ... 19 more fields]
(409) Generate
Arguments: explode(optimizationGroups#733798), true, [optGroupId#733799]
(410) Project
Arguments: [orderProposalId#733659L, optGroupId#733799]
(411) Deduplicate
Arguments: [orderProposalId#733659L, optGroupId#733799]
(412) LogicalRelation
Arguments: parquet, [optGroupId#733800, assignmentDetails#733801, minOrderProfile#733802, multiplerestrictionprofile#733803], false
(413) Repartition
Arguments: 25, true
(414) Filter
Arguments: (isnotnull(optGroupId#733800) AND isnotnull(minOrderProfile#733802))
(415) Join
Arguments: Inner, (optGroupId#733799 = optGroupId#733800)
(416) Project
Arguments: [optGroupId#733799, orderProposalId#733659L, assignmentDetails#733801, minOrderProfile#733802, multiplerestrictionprofile#733803]
(417) Join
Arguments: LeftOuter, (orderProposalId#733503L = orderProposalId#733659L)
(418) Project
Arguments: [orderProposalId#733503L, sequenceId#733508, optGroupId#733799, assignmentDetails#733801, minOrderProfile#733802, multiplerestrictionprofile#733803]
(419) LogicalRelation
Arguments: parquet, [supplierminimumprofilename#733460, descriptions#733461, dimensionType#733462, dimensionValue#733463, dimensionUnit#733464, acceptanceThreshold#733465, profileType#733466, eventtype#733467], false
(420) Repartition
Arguments: 25, true
(421) Join
Arguments: Inner, (minOrderProfile#733802 <=> supplierminimumprofilename#733460)
(422) LogicalRelation
Arguments: parquet, [systemId#733468, internalUUID#733469, code#733470, name#733471, commercialCode#733472, isoCode#733473], false
(423) Repartition
Arguments: 25, true
(424) Join
Arguments: LeftOuter, (dimensionUnit#733464.dimensionCodeUuid <=> internalUUID#733469)
(425) Project
Arguments: [orderProposalId#733503L, sequenceId#733508, optGroupId#733799, assignmentDetails#733801, minOrderProfile#733802, multiplerestrictionprofile#733803, supplierminimumprofilename#733460, descriptions#733461, dimensionType#733462, dimensionValue#733463, dimensionUnit#733464, acceptanceThreshold#733465, profileType#733466, eventtype#733467, systemId#733468, internalUUID#733469, code#733470, name#733471, commercialCode#733472, isoCode#733473, struct(minOrderValue, dimensionValue#733463, dimensionType, dimensionType#733462, unit, dimensionUnit#733464.dimensionCode, unitUuid, dimensionUnit#733464.dimensionCodeUuid, negligibleQuantitiesThreshold, 0.0, acceptanceThreshold, (acceptanceThreshold#733465 / cast(100 as double)), isoCode, isoCode#733473.code) AS minOrderGoal#733483]
(426) Project
Arguments: [orderProposalId#733503L, sequenceId#733508, optGroupId#733799, assignmentDetails#733801, minOrderProfile#733802, multiplerestrictionprofile#733803, systemId#733468, internalUUID#733469, code#733470, name#733471, commercialCode#733472, isoCode#733473, minOrderGoal#733483]
(427) Project
Arguments: [orderProposalId#733503L, sequenceId#733508, optGroupId#733799, assignmentDetails#733801, minOrderProfile#733802, multiplerestrictionprofile#733803, minOrderGoal#733483]
(428) Project
Arguments: [orderProposalId#733503L, optGroupId#733799, assignmentDetails#733801, minOrderProfile#733802, multiplerestrictionprofile#733803, minOrderGoal#733483]
(429) Join
Arguments: LeftOuter, (orderProposalId#732291L = orderProposalId#733503L)
(430) Project
Arguments: [orderProposalId#732291L, sequenceId#732296, optGroupId#733799, assignmentDetails#733801, minOrderProfile#733802, multiplerestrictionprofile#733803, minOrderGoal#733483]
(431) Aggregate
Arguments: [orderProposalId#732291L, sequenceId#732296], [orderProposalId#732291L, sequenceId#732296, collect_list(struct(optGroupId, optGroupId#733799, assignmentDetails, assignmentDetails#733801, minOrderProfile, minOrderProfile#733802, multiplerestrictionprofile, multiplerestrictionprofile#733803, minOrderGoal, minOrderGoal#733483), 0, 0) AS optimizationGroups#733815]
(432) Project
Arguments: [orderProposalId#732291L, sequenceId#732296, filter(optimizationGroups#733815, lambdafunction(isnotnull(lambda x_1942#733825.optGroupId), lambda x_1942#733825, false)) AS optimizationGroups#733824]
(433) Generate
Arguments: explode(optimizationGroups#733824.minOrderGoal), false, [minOrderGoal#736414]
(434) Project
Arguments: [minOrderGoal#736414]
(435) Filter
Arguments: (minOrderGoal#736414.dimensionType <=> 2)
(436) Project
Arguments: [minOrderGoal#736414.unit AS uomCategoryName#736416]
(437) LogicalRelation
Arguments: parquet, [uomCategoryName#736407, descriptions#736408, uoms#736409, validTo#736410, eventtype#736411], false
(438) Repartition
Arguments: 25, true
(439) Join
Arguments: LeftOuter, (uomCategoryName#736416 = uomCategoryName#736407)
(440) Project
Arguments: [uomCategoryName#736416, descriptions#736408, uoms#736409, validTo#736410, eventtype#736411]
(441) Project
Arguments: [uomCategoryName#736416, descriptions#736408, coalesce(uoms#736409, cast(array() as array<struct<internalRefUUID:string,id:string>>)) AS uoms#736419, validTo#736410, eventtype#736411]
(442) Project
Arguments: [uomCategoryName#736416, descriptions#736408, transform(uoms#736419, lambdafunction(struct(uom, lambda x_1943#736423.id, uomUuid, lambda x_1943#736423.internalRefUUID), lambda x_1943#736423, false)) AS uoms#736422, validTo#736410, eventtype#736411]
(443) Project
Arguments: [uomCategoryName#736416, descriptions#736408, uoms#736422, validTo#736410, eventtype#736411, struct(uomCategoryName, uomCategoryName#736416, uoms, uoms#736422) AS uomCategory#736424]
(444) Project
Arguments: [uomCategoryName#736416, descriptions#736408, uoms#736422, validTo#736410, eventtype#736411, uomCategory#736424, dummy AS dummy#736425]
(445) Aggregate
Arguments: [dummy#736425], [dummy#736425, collect_set(uomCategory#736424, 0, 0) AS uomCategories#736426]
(446) Join
Arguments: LeftOuter, (dummy#736435 = dummy#736425)
(447) Project
Arguments: [dummy#736435, uomCategories#736426]
(448) Project
Arguments: [dummy#736435, coalesce(uomCategories#736426, cast(array() as array<struct<uomCategoryName:string,uoms:array<struct<uom:string,uomUuid:string>>>>)) AS uomCategories#736436]
(449) Project
Arguments: [uomCategories#736436]
(450) LogicalRelation
Arguments: parquet, [name#736437, category#736438, status#736439, configurationVersion#736440, businessContext#736441, message#736442, settings#736443, eventtype#736444], false
(451) Repartition
Arguments: 25, true
(452) Filter
Arguments: (isnotnull(configurationVersion#736440) AND isnotnull(name#736437))
(453) Aggregate
Arguments: [name#736437], [name#736437, max(struct(configurationVersion, configurationVersion#736440, status, status#736439, settings, settings#736443)) AS best#736446]
(454) Filter
Arguments: (best#736446.status = ACTIVE)
(455) Project
Arguments: [name#736437, best#736446.settings AS settings#736457, best#736446.configurationVersion AS configurationVersion#736458]
(456) Aggregate
Arguments: [map_from_entries(collect_list(struct(name, name#736437, configValue, struct(configurationVersion, configurationVersion#736458, name, name#736437, settings, settings#736457, status, ACTIVE)), 0, 0)) AS insightConfigurations#736461]
(457) Join
Arguments: Cross
(458) Project
Arguments: [uomCategories#736436, coalesce(insightConfigurations#736461, cast(map() as map<string,struct<configurationVersion:string,name:string,settings:array<struct<name:string,type:string,value:string>>,status:string>>)) AS insightConfigurations#736466]
(459) Project
Arguments: [uomCategories#736436, insightConfigurations#736466, 0_1_10000002108 AS shardId#739434]