== Physical Plan ==
Execute SaveIntoDataSourceCommand (1)
+- SaveIntoDataSourceCommand (2)
+- Project (431)
+- Project (430)
+- Aggregate (429)
+- Project (428)
+- Join (427)
:- Deduplicate (210)
: +- Project (209)
: +- Project (208)
: +- Join (207)
: :- Deduplicate (101)
: : +- Project (100)
: : +- Project (99)
: : +- Project (98)
: : +- Project (97)
: : +- Project (96)
: : +- Project (95)
: : +- Join (94)
: : :- Project (89)
: : : +- Project (88)
: : : +- Project (87)
: : : +- Join (86)
: : : :- Project (82)
: : : : +- Join (81)
: : : : :- Project (77)
: : : : : +- Project (76)
: : : : : +- Project (75)
: : : : : +- Project (74)
: : : : : +- Project (73)
: : : : : +- Project (72)
: : : : : +- Project (71)
: : : : : +- Project (70)
: : : : : +- Project (69)
: : : : : +- Project (68)
: : : : : +- Project (67)
: : : : : +- Join (66)
: : : : : :- Project (62)
: : : : : : +- Project (61)
: : : : : : +- Project (60)
: : : : : : +- Project (59)
: : : : : : +- Project (58)
: : : : : : +- Project (57)
: : : : : : +- Join (56)
: : : : : : :- Project (53)
: : : : : : : +- Join (52)
: : : : : : : :- Project (49)
: : : : : : : : +- Project (48)
: : : : : : : : +- Project (47)
: : : : : : : : +- Project (46)
: : : : : : : : +- Project (45)
: : : : : : : : +- Join (44)
: : : : : : : : :- Project (41)
: : : : : : : : : +- Project (40)
: : : : : : : : : +- Join (39)
: : : : : : : : : :- Join (35)
: : : : : : : : : : :- SubqueryAlias (32)
: : : : : : : : : : : +- Project (31)
: : : : : : : : : : : +- Project (30)
: : : : : : : : : : : +- Project (29)
: : : : : : : : : : : +- Project (28)
: : : : : : : : : : : +- Project (27)
: : : : : : : : : : : +- Project (26)
: : : : : : : : : : : +- Project (25)
: : : : : : : : : : : +- Project (24)
: : : : : : : : : : : +- Join (23)
: : : : : : : : : : : :- Project (19)
: : : : : : : : : : : : +- Project (18)
: : : : : : : : : : : : +- Project (17)
: : : : : : : : : : : : +- Project (16)
: : : : : : : : : : : : +- Join (15)
: : : : : : : : : : : : :- Project (10)
: : : : : : : : : : : : : +- Project (9)
: : : : : : : : : : : : : +- Join (8)
: : : : : : : : : : : : : :- RepartitionByExpression (4)
: : : : : : : : : : : : : : +- LogicalRelation (3)
: : : : : : : : : : : : : +- SubqueryAlias (7)
: : : : : : : : : : : : : +- Repartition (6)
: : : : : : : : : : : : : +- LogicalRelation (5)
: : : : : : : : : : : : +- SubqueryAlias (14)
: : : : : : : : : : : : +- Filter (13)
: : : : : : : : : : : : +- Repartition (12)
: : : : : : : : : : : : +- LogicalRelation (11)
: : : : : : : : : : : +- SubqueryAlias (22)
: : : : : : : : : : : +- Repartition (21)
: : : : : : : : : : : +- LogicalRelation (20)
: : : : : : : : : : +- SubqueryAlias (34)
: : : : : : : : : : +- LocalRelation (33)
: : : : : : : : : +- SubqueryAlias (38)
: : : : : : : : : +- Filter (37)
: : : : : : : : : +- LocalRelation (36)
: : : : : : : : +- Aggregate (43)
: : : : : : : : +- LocalRelation (42)
: : : : : : : +- Repartition (51)
: : : : : : : +- LogicalRelation (50)
: : : : : : +- Repartition (55)
: : : : : : +- LogicalRelation (54)
: : : : : +- Project (65)
: : : : : +- Project (64)
: : : : : +- LocalRelation (63)
: : : : +- SubqueryAlias (80)
: : : : +- Repartition (79)
: : : : +- LogicalRelation (78)
: : : +- SubqueryAlias (85)
: : : +- Repartition (84)
: : : +- LogicalRelation (83)
: : +- Project (93)
: : +- Project (92)
: : +- Repartition (91)
: : +- LogicalRelation (90)
: +- Project (206)
: +- Join (205)
: :- Deduplicate (201)
: : +- Project (200)
: : +- Generate (199)
: : +- Project (198)
: : +- Project (197)
: : +- Project (196)
: : +- Project (195)
: : +- Project (194)
: : +- Join (193)
: : :- Project (188)
: : : +- Project (187)
: : : +- Project (186)
: : : +- Join (185)
: : : :- Project (181)
: : : : +- Join (180)
: : : : :- Project (176)
: : : : : +- Project (175)
: : : : : +- Project (174)
: : : : : +- Project (173)
: : : : : +- Project (172)
: : : : : +- Project (171)
: : : : : +- Project (170)
: : : : : +- Project (169)
: : : : : +- Project (168)
: : : : : +- Project (167)
: : : : : +- Project (166)
: : : : : +- Join (165)
: : : : : :- Project (161)
: : : : : : +- Project (160)
: : : : : : +- Project (159)
: : : : : : +- Project (158)
: : : : : : +- Project (157)
: : : : : : +- Project (156)
: : : : : : +- Join (155)
: : : : : : :- Project (152)
: : : : : : : +- Join (151)
: : : : : : : :- Project (148)
: : : : : : : : +- Project (147)
: : : : : : : : +- Project (146)
: : : : : : : : +- Project (145)
: : : : : : : : +- Project (144)
: : : : : : : : +- Join (143)
: : : : : : : : :- Project (140)
: : : : : : : : : +- Project (139)
: : : : : : : : : +- Join (138)
: : : : : : : : : :- Join (134)
: : : : : : : : : : :- SubqueryAlias (131)
: : : : : : : : : : : +- Project (130)
: : : : : : : : : : : +- Project (129)
: : : : : : : : : : : +- Project (128)
: : : : : : : : : : : +- Project (127)
: : : : : : : : : : : +- Project (126)
: : : : : : : : : : : +- Project (125)
: : : : : : : : : : : +- Project (124)
: : : : : : : : : : : +- Project (123)
: : : : : : : : : : : +- Join (122)
: : : : : : : : : : : :- Project (118)
: : : : : : : : : : : : +- Project (117)
: : : : : : : : : : : : +- Project (116)
: : : : : : : : : : : : +- Project (115)
: : : : : : : : : : : : +- Join (114)
: : : : : : : : : : : : :- Project (109)
: : : : : : : : : : : : : +- Project (108)
: : : : : : : : : : : : : +- Join (107)
: : : : : : : : : : : : : :- RepartitionByExpression (103)
: : : : : : : : : : : : : : +- LogicalRelation (102)
: : : : : : : : : : : : : +- SubqueryAlias (106)
: : : : : : : : : : : : : +- Repartition (105)
: : : : : : : : : : : : : +- LogicalRelation (104)
: : : : : : : : : : : : +- SubqueryAlias (113)
: : : : : : : : : : : : +- Filter (112)
: : : : : : : : : : : : +- Repartition (111)
: : : : : : : : : : : : +- LogicalRelation (110)
: : : : : : : : : : : +- SubqueryAlias (121)
: : : : : : : : : : : +- Repartition (120)
: : : : : : : : : : : +- LogicalRelation (119)
: : : : : : : : : : +- SubqueryAlias (133)
: : : : : : : : : : +- LocalRelation (132)
: : : : : : : : : +- SubqueryAlias (137)
: : : : : : : : : +- Filter (136)
: : : : : : : : : +- LocalRelation (135)
: : : : : : : : +- Aggregate (142)
: : : : : : : : +- LocalRelation (141)
: : : : : : : +- Repartition (150)
: : : : : : : +- LogicalRelation (149)
: : : : : : +- Repartition (154)
: : : : : : +- LogicalRelation (153)
: : : : : +- Project (164)
: : : : : +- Project (163)
: : : : : +- LocalRelation (162)
: : : : +- SubqueryAlias (179)
: : : : +- Repartition (178)
: : : : +- LogicalRelation (177)
: : : +- SubqueryAlias (184)
: : : +- Repartition (183)
: : : +- LogicalRelation (182)
: : +- Project (192)
: : +- Project (191)
: : +- Repartition (190)
: : +- LogicalRelation (189)
: +- Filter (204)
: +- Repartition (203)
: +- LogicalRelation (202)
+- Project (426)
+- Project (425)
+- Project (424)
+- Project (423)
+- Join (422)
:- Join (419)
: :- Project (416)
: : +- Join (415)
: : :- Deduplicate (309)
: : : +- Project (308)
: : : +- Project (307)
: : : +- Project (306)
: : : +- Project (305)
: : : +- Project (304)
: : : +- Project (303)
: : : +- Join (302)
: : : :- Project (297)
: : : : +- Project (296)
: : : : +- Project (295)
: : : : +- Join (294)
: : : : :- Project (290)
: : : : : +- Join (289)
: : : : : :- Project (285)
: : : : : : +- Project (284)
: : : : : : +- Project (283)
: : : : : : +- Project (282)
: : : : : : +- Project (281)
: : : : : : +- Project (280)
: : : : : : +- Project (279)
: : : : : : +- Project (278)
: : : : : : +- Project (277)
: : : : : : +- Project (276)
: : : : : : +- Project (275)
: : : : : : +- Join (274)
: : : : : : :- Project (270)
: : : : : : : +- Project (269)
: : : : : : : +- Project (268)
: : : : : : : +- Project (267)
: : : : : : : +- Project (266)
: : : : : : : +- Project (265)
: : : : : : : +- Join (264)
: : : : : : : :- Project (261)
: : : : : : : : +- Join (260)
: : : : : : : : :- Project (257)
: : : : : : : : : +- Project (256)
: : : : : : : : : +- Project (255)
: : : : : : : : : +- Project (254)
: : : : : : : : : +- Project (253)
: : : : : : : : : +- Join (252)
: : : : : : : : : :- Project (249)
: : : : : : : : : : +- Project (248)
: : : : : : : : : : +- Join (247)
: : : : : : : : : : :- Join (243)
: : : : : : : : : : : :- SubqueryAlias (240)
: : : : : : : : : : : : +- Project (239)
: : : : : : : : : : : : +- Project (238)
: : : : : : : : : : : : +- Project (237)
: : : : : : : : : : : : +- Project (236)
: : : : : : : : : : : : +- Project (235)
: : : : : : : : : : : : +- Project (234)
: : : : : : : : : : : : +- Project (233)
: : : : : : : : : : : : +- Project (232)
: : : : : : : : : : : : +- Join (231)
: : : : : : : : : : : : :- Project (227)
: : : : : : : : : : : : : +- Project (226)
: : : : : : : : : : : : : +- Project (225)
: : : : : : : : : : : : : +- Project (224)
: : : : : : : : : : : : : +- Join (223)
: : : : : : : : : : : : : :- Project (218)
: : : : : : : : : : : : : : +- Project (217)
: : : : : : : : : : : : : : +- Join (216)
: : : : : : : : : : : : : : :- RepartitionByExpression (212)
: : : : : : : : : : : : : : : +- LogicalRelation (211)
: : : : : : : : : : : : : : +- SubqueryAlias (215)
: : : : : : : : : : : : : : +- Repartition (214)
: : : : : : : : : : : : : : +- LogicalRelation (213)
: : : : : : : : : : : : : +- SubqueryAlias (222)
: : : : : : : : : : : : : +- Filter (221)
: : : : : : : : : : : : : +- Repartition (220)
: : : : : : : : : : : : : +- LogicalRelation (219)
: : : : : : : : : : : : +- SubqueryAlias (230)
: : : : : : : : : : : : +- Repartition (229)
: : : : : : : : : : : : +- LogicalRelation (228)
: : : : : : : : : : : +- SubqueryAlias (242)
: : : : : : : : : : : +- LocalRelation (241)
: : : : : : : : : : +- SubqueryAlias (246)
: : : : : : : : : : +- Filter (245)
: : : : : : : : : : +- LocalRelation (244)
: : : : : : : : : +- Aggregate (251)
: : : : : : : : : +- LocalRelation (250)
: : : : : : : : +- Repartition (259)
: : : : : : : : +- LogicalRelation (258)
: : : : : : : +- Repartition (263)
: : : : : : : +- LogicalRelation (262)
: : : : : : +- Project (273)
: : : : : : +- Project (272)
: : : : : : +- LocalRelation (271)
: : : : : +- SubqueryAlias (288)
: : : : : +- Repartition (287)
: : : : : +- LogicalRelation (286)
: : : : +- SubqueryAlias (293)
: : : : +- Repartition (292)
: : : : +- LogicalRelation (291)
: : : +- Project (301)
: : : +- Project (300)
: : : +- Repartition (299)
: : : +- LogicalRelation (298)
: : +- Project (414)
: : +- Join (413)
: : :- Deduplicate (409)
: : : +- Project (408)
: : : +- Generate (407)
: : : +- Project (406)
: : : +- Project (405)
: : : +- Project (404)
: : : +- Project (403)
: : : +- Project (402)
: : : +- Join (401)
: : : :- Project (396)
: : : : +- Project (395)
: : : : +- Project (394)
: : : : +- Join (393)
: : : : :- Project (389)
: : : : : +- Join (388)
: : : : : :- Project (384)
: : : : : : +- Project (383)
: : : : : : +- Project (382)
: : : : : : +- Project (381)
: : : : : : +- Project (380)
: : : : : : +- Project (379)
: : : : : : +- Project (378)
: : : : : : +- Project (377)
: : : : : : +- Project (376)
: : : : : : +- Project (375)
: : : : : : +- Project (374)
: : : : : : +- Join (373)
: : : : : : :- Project (369)
: : : : : : : +- Project (368)
: : : : : : : +- Project (367)
: : : : : : : +- Project (366)
: : : : : : : +- Project (365)
: : : : : : : +- Project (364)
: : : : : : : +- Join (363)
: : : : : : : :- Project (360)
: : : : : : : : +- Join (359)
: : : : : : : : :- Project (356)
: : : : : : : : : +- Project (355)
: : : : : : : : : +- Project (354)
: : : : : : : : : +- Project (353)
: : : : : : : : : +- Project (352)
: : : : : : : : : +- Join (351)
: : : : : : : : : :- Project (348)
: : : : : : : : : : +- Project (347)
: : : : : : : : : : +- Join (346)
: : : : : : : : : : :- Join (342)
: : : : : : : : : : : :- SubqueryAlias (339)
: : : : : : : : : : : : +- Project (338)
: : : : : : : : : : : : +- Project (337)
: : : : : : : : : : : : +- Project (336)
: : : : : : : : : : : : +- Project (335)
: : : : : : : : : : : : +- Project (334)
: : : : : : : : : : : : +- Project (333)
: : : : : : : : : : : : +- Project (332)
: : : : : : : : : : : : +- Project (331)
: : : : : : : : : : : : +- Join (330)
: : : : : : : : : : : : :- Project (326)
: : : : : : : : : : : : : +- Project (325)
: : : : : : : : : : : : : +- Project (324)
: : : : : : : : : : : : : +- Project (323)
: : : : : : : : : : : : : +- Join (322)
: : : : : : : : : : : : : :- Project (317)
: : : : : : : : : : : : : : +- Project (316)
: : : : : : : : : : : : : : +- Join (315)
: : : : : : : : : : : : : : :- RepartitionByExpression (311)
: : : : : : : : : : : : : : : +- LogicalRelation (310)
: : : : : : : : : : : : : : +- SubqueryAlias (314)
: : : : : : : : : : : : : : +- Repartition (313)
: : : : : : : : : : : : : : +- LogicalRelation (312)
: : : : : : : : : : : : : +- SubqueryAlias (321)
: : : : : : : : : : : : : +- Filter (320)
: : : : : : : : : : : : : +- Repartition (319)
: : : : : : : : : : : : : +- LogicalRelation (318)
: : : : : : : : : : : : +- SubqueryAlias (329)
: : : : : : : : : : : : +- Repartition (328)
: : : : : : : : : : : : +- LogicalRelation (327)
: : : : : : : : : : : +- SubqueryAlias (341)
: : : : : : : : : : : +- LocalRelation (340)
: : : : : : : : : : +- SubqueryAlias (345)
: : : : : : : : : : +- Filter (344)
: : : : : : : : : : +- LocalRelation (343)
: : : : : : : : : +- Aggregate (350)
: : : : : : : : : +- LocalRelation (349)
: : : : : : : : +- Repartition (358)
: : : : : : : : +- LogicalRelation (357)
: : : : : : : +- Repartition (362)
: : : : : : : +- LogicalRelation (361)
: : : : : : +- Project (372)
: : : : : : +- Project (371)
: : : : : : +- LocalRelation (370)
: : : : : +- SubqueryAlias (387)
: : : : : +- Repartition (386)
: : : : : +- LogicalRelation (385)
: : : : +- SubqueryAlias (392)
: : : : +- Repartition (391)
: : : : +- LogicalRelation (390)
: : : +- Project (400)
: : : +- Project (399)
: : : +- Repartition (398)
: : : +- LogicalRelation (397)
: : +- Filter (412)
: : +- Repartition (411)
: : +- LogicalRelation (410)
: +- Repartition (418)
: +- LogicalRelation (417)
+- Repartition (421)
+- LogicalRelation (420)
(1) Execute SaveIntoDataSourceCommand
Output: []
(2) SaveIntoDataSourceCommand
Arguments: org.apache.spark.sql.delta.sources.DeltaDataSource@4fcc501e, [__partition_columns=["shardId","sequenceId"], path=hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-qty-opt-service/internal/order-proposal-snapshot/10000002108], Overwrite
(3) 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
(4) RepartitionByExpression
Arguments: [product#732282, plant#732277], 25
(5) 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
(6) Repartition
Arguments: 25, true
(7) SubqueryAlias
Arguments: sos
(8) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#732287 <=> internalUUID#732302)
(9) 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]
(10) 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]
(11) LogicalRelation
Arguments: parquet, [systemId#732329, internalUUID#732330, plant#732331, product#732332, blockedForReplenishmentStartingFrom#732333, productionAspect#732334, salesPlant#732335, listing#732336], false
(12) Repartition
Arguments: 25, true
(13) Filter
Arguments: plant#732331.internalRefUUID IN (1c037502c75549dc72c6fc87c802bcec,717937a4d5db853d3359b6a0623cfdf0,4d233bd0bf112aded9d852448354b078,fca7a07ad5f143db2beafbd1d0401ea1,45f9c5206af43e1e6acbe19d9a246289,6d24a939f4bbd79f6acb8684d6e45c97,3d84243e56ebf98292ed5dba2fd51543,24a9ebb440508219166784d4d1c19eef,f80b06f7b2102a5f5c63b031eb5d8e03,25c0d9731dd07bb53999d9a8f04398e0)
(14) SubqueryAlias
Arguments: pp
(15) Join
Arguments: LeftOuter, ((product#732282 <=> product#732332.internalRefUUID) AND (plant#732277 <=> plant#732331.internalRefUUID))
(16) 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]
(17) 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]
(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, ... 12 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, ... 4 more fields]
(20) 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
(21) Repartition
Arguments: 25, true
(22) SubqueryAlias
Arguments: tmp
(23) Join
Arguments: LeftOuter, (product#732282 = internalUUID#732347)
(24) 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]
(25) 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]
(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, ... 6 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, ... 7 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, ... 8 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, ... 8 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, ... 9 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, ... 10 more fields]
(32) SubqueryAlias
Arguments: worklist
(33) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#732389, plant#732390, logisticalRoundingRule#732391]
(34) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(35) Join
Arguments: LeftOuter, ((preferredRoundingProfile#732382 <=> logisticalRoundingProfile#732389) AND (plant#732277 <=> plant#732390.internalRefUUID))
(36) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#732416, plant#732417, logisticalRoundingRule#732418]
(37) Filter
Arguments: isnull(plant#732417.internalRefUUID)
(38) SubqueryAlias
Arguments: allPlantRoundingProfiles
(39) Join
Arguments: LeftOuter, (preferredRoundingProfile#732382 <=> logisticalRoundingProfile#732416)
(40) 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]
(41) 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]
(42) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#732407, unitOfMeasure#732408]
(43) Aggregate
Arguments: [logisticalRoundingRule#732407], [logisticalRoundingRule#732407, collect_list(unitOfMeasure#732408.internalRefUUID, 0, 0) AS preferredUOMs#732409]
(44) Join
Arguments: LeftOuter, (logisticalRoundingRule#732420.logisticalRoundingRule = logisticalRoundingRule#732407)
(45) 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]
(46) 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]
(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, ... 8 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, ... 9 more fields]
(50) LogicalRelation
Arguments: parquet, [product#732433, plant#732434, orderDateTime#732435, constraintprofile#732436], false
(51) Repartition
Arguments: 25, true
(52) Join
Arguments: LeftOuter, (((product#732282 <=> product#732433) AND (plant#732277 <=> plant#732434)) AND (orderDateTime#732283 <=> orderDateTime#732435))
(53) 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]
(54) LogicalRelation
Arguments: parquet, [constraintProfile#732437, descriptions#732438, minServiceLevel#732439, minServiceLevelMinStock#732440, maxServiceLevelEndListing#732441, maxRangeCoverage#732442, minOrderQuantity#732443, profileType#732444, eventtype#732445], false
(55) Repartition
Arguments: 25, true
(56) Join
Arguments: LeftOuter, (constraintProfile#732436 <=> constraintProfile#732437)
(57) 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]
(58) 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]
(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, ... 10 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, ... 15 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, ... 15 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, ... 14 more fields]
(63) LocalRelation
Arguments: <empty>, [orderProposalId#732474, orderProposalItemId#732475, constraintOverwrites#732476]
(64) 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]
(65) 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]
(66) Join
Arguments: LeftOuter, ((orderProposalId#732291L = cast(orderProposalId#732474 as bigint)) AND (orderProposalItemId#732299 = orderProposalItemId#732475))
(67) 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]
(68) 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]
(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, ... 14 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, ... 16 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, ... 17 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, ... 18 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, ... 19 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, ... 20 more fields]
(78) LogicalRelation
Arguments: parquet, [systemId#732513, internalUUID#732514, code#732515, name#732516, commercialCode#732517, isoCode#732518], false
(79) Repartition
Arguments: 25, true
(80) SubqueryAlias
Arguments: unitOfMeasure
(81) 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)
(82) 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]
(83) LogicalRelation
Arguments: parquet, [systemId#732549, internalUUID#732550, code#732551, name#732552, commercialCode#732553, isoCode#732554], false
(84) Repartition
Arguments: 25, true
(85) SubqueryAlias
Arguments: unitOfMeasure
(86) 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)
(87) 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]
(88) 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]
(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, ... 21 more fields]
(90) LogicalRelation
Arguments: parquet, [supplier#732580, subrange#732581, plant#732582, deliverydatetime#732583, ordergroupingprofile#732584, supplierGroup#732585, locationGroup#732586, optimizationGroups#732587], false
(91) Repartition
Arguments: 25, true
(92) 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]
(93) 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]
(94) 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))
(95) 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]
(96) 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]
(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, ... 21 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, ... 20 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, ... 19 more fields]
(100) Project
Arguments: [orderProposalId#732291L, sequenceId#732296]
(101) Deduplicate
Arguments: [orderProposalId#732291L, sequenceId#732296]
(102) 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
(103) RepartitionByExpression
Arguments: [product#733306, plant#733301], 25
(104) 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
(105) Repartition
Arguments: 25, true
(106) SubqueryAlias
Arguments: sos
(107) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#733311 <=> internalUUID#733325)
(108) 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]
(109) 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]
(110) LogicalRelation
Arguments: parquet, [systemId#733349, internalUUID#733350, plant#733351, product#733352, blockedForReplenishmentStartingFrom#733353, productionAspect#733354, salesPlant#733355, listing#733356], false
(111) Repartition
Arguments: 25, true
(112) Filter
Arguments: plant#733351.internalRefUUID IN (1c037502c75549dc72c6fc87c802bcec,717937a4d5db853d3359b6a0623cfdf0,4d233bd0bf112aded9d852448354b078,fca7a07ad5f143db2beafbd1d0401ea1,45f9c5206af43e1e6acbe19d9a246289,6d24a939f4bbd79f6acb8684d6e45c97,3d84243e56ebf98292ed5dba2fd51543,24a9ebb440508219166784d4d1c19eef,f80b06f7b2102a5f5c63b031eb5d8e03,25c0d9731dd07bb53999d9a8f04398e0)
(113) SubqueryAlias
Arguments: pp
(114) Join
Arguments: LeftOuter, ((product#733306 <=> product#733352.internalRefUUID) AND (plant#733301 <=> plant#733351.internalRefUUID))
(115) 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]
(116) 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]
(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, ... 12 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, ... 4 more fields]
(119) 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
(120) Repartition
Arguments: 25, true
(121) SubqueryAlias
Arguments: tmp
(122) Join
Arguments: LeftOuter, (product#733306 = internalUUID#733361)
(123) 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]
(124) 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]
(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, ... 6 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, ... 7 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, ... 8 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, ... 8 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, ... 9 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, ... 10 more fields]
(131) SubqueryAlias
Arguments: worklist
(132) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#733379, plant#733380, logisticalRoundingRule#733381]
(133) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(134) Join
Arguments: LeftOuter, ((preferredRoundingProfile#733378 <=> logisticalRoundingProfile#733379) AND (plant#733301 <=> plant#733380.internalRefUUID))
(135) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#733382, plant#733383, logisticalRoundingRule#733384]
(136) Filter
Arguments: isnull(plant#733383.internalRefUUID)
(137) SubqueryAlias
Arguments: allPlantRoundingProfiles
(138) Join
Arguments: LeftOuter, (preferredRoundingProfile#733378 <=> logisticalRoundingProfile#733382)
(139) 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]
(140) 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]
(141) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#733387, unitOfMeasure#733388]
(142) Aggregate
Arguments: [logisticalRoundingRule#733387], [logisticalRoundingRule#733387, collect_list(unitOfMeasure#733388.internalRefUUID, 0, 0) AS preferredUOMs#733389]
(143) Join
Arguments: LeftOuter, (logisticalRoundingRule#733386.logisticalRoundingRule = logisticalRoundingRule#733387)
(144) 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]
(145) 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]
(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, ... 8 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, ... 9 more fields]
(149) LogicalRelation
Arguments: parquet, [product#733393, plant#733394, orderDateTime#733395, constraintprofile#733396], false
(150) Repartition
Arguments: 25, true
(151) Join
Arguments: LeftOuter, (((product#733306 <=> product#733393) AND (plant#733301 <=> plant#733394)) AND (orderDateTime#733307 <=> orderDateTime#733395))
(152) 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]
(153) LogicalRelation
Arguments: parquet, [constraintProfile#733397, descriptions#733398, minServiceLevel#733399, minServiceLevelMinStock#733400, maxServiceLevelEndListing#733401, maxRangeCoverage#733402, minOrderQuantity#733403, profileType#733404, eventtype#733405], false
(154) Repartition
Arguments: 25, true
(155) Join
Arguments: LeftOuter, (constraintProfile#733396 <=> constraintProfile#733397)
(156) 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]
(157) 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]
(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, ... 10 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, ... 15 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, ... 15 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, ... 14 more fields]
(162) LocalRelation
Arguments: <empty>, [orderProposalId#733414, orderProposalItemId#733415, constraintOverwrites#733416]
(163) 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]
(164) 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]
(165) Join
Arguments: LeftOuter, ((orderProposalId#733315L = cast(orderProposalId#733414 as bigint)) AND (orderProposalItemId#733323 = orderProposalItemId#733415))
(166) 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]
(167) 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]
(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, ... 14 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, ... 16 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, ... 17 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, ... 18 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, ... 19 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, ... 20 more fields]
(177) LogicalRelation
Arguments: parquet, [systemId#733428, internalUUID#733429, code#733430, name#733431, commercialCode#733432, isoCode#733433], false
(178) Repartition
Arguments: 25, true
(179) SubqueryAlias
Arguments: unitOfMeasure
(180) 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)
(181) 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]
(182) LogicalRelation
Arguments: parquet, [systemId#733435, internalUUID#733436, code#733437, name#733438, commercialCode#733439, isoCode#733440], false
(183) Repartition
Arguments: 25, true
(184) SubqueryAlias
Arguments: unitOfMeasure
(185) 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)
(186) 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]
(187) 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]
(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, ... 21 more fields]
(189) LogicalRelation
Arguments: parquet, [supplier#733444, subrange#733445, plant#733446, deliverydatetime#733447, ordergroupingprofile#733448, supplierGroup#733449, locationGroup#733450, optimizationGroups#733451], false
(190) Repartition
Arguments: 25, true
(191) 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]
(192) 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]
(193) 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))
(194) 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]
(195) 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]
(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, ... 21 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, ... 20 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, ... 19 more fields]
(199) Generate
Arguments: explode(optimizationGroups#733454), true, [optGroupId#733298]
(200) Project
Arguments: [orderProposalId#733315L, optGroupId#733298]
(201) Deduplicate
Arguments: [orderProposalId#733315L, optGroupId#733298]
(202) LogicalRelation
Arguments: parquet, [optGroupId#733292, assignmentDetails#733293, minOrderProfile#733294, multiplerestrictionprofile#733295], false
(203) Repartition
Arguments: 25, true
(204) Filter
Arguments: (isnotnull(optGroupId#733292) AND isnotnull(minOrderProfile#733294))
(205) Join
Arguments: Inner, (optGroupId#733298 = optGroupId#733292)
(206) Project
Arguments: [optGroupId#733298, orderProposalId#733315L, assignmentDetails#733293, minOrderProfile#733294, multiplerestrictionprofile#733295]
(207) Join
Arguments: LeftOuter, (orderProposalId#732291L = orderProposalId#733315L)
(208) Project
Arguments: [orderProposalId#732291L, sequenceId#732296, optGroupId#733298, assignmentDetails#733293, minOrderProfile#733294, multiplerestrictionprofile#733295]
(209) Project
Arguments: [orderProposalId#732291L, sequenceId#732296]
(210) Deduplicate
Arguments: [orderProposalId#732291L, sequenceId#732296]
(211) 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
(212) RepartitionByExpression
Arguments: [product#733494, plant#733489], 25
(213) 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
(214) Repartition
Arguments: 25, true
(215) SubqueryAlias
Arguments: sos
(216) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#733499 <=> internalUUID#733513)
(217) 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]
(218) 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]
(219) LogicalRelation
Arguments: parquet, [systemId#733537, internalUUID#733538, plant#733539, product#733540, blockedForReplenishmentStartingFrom#733541, productionAspect#733542, salesPlant#733543, listing#733544], false
(220) Repartition
Arguments: 25, true
(221) Filter
Arguments: plant#733539.internalRefUUID IN (1c037502c75549dc72c6fc87c802bcec,717937a4d5db853d3359b6a0623cfdf0,4d233bd0bf112aded9d852448354b078,fca7a07ad5f143db2beafbd1d0401ea1,45f9c5206af43e1e6acbe19d9a246289,6d24a939f4bbd79f6acb8684d6e45c97,3d84243e56ebf98292ed5dba2fd51543,24a9ebb440508219166784d4d1c19eef,f80b06f7b2102a5f5c63b031eb5d8e03,25c0d9731dd07bb53999d9a8f04398e0)
(222) SubqueryAlias
Arguments: pp
(223) Join
Arguments: LeftOuter, ((product#733494 <=> product#733540.internalRefUUID) AND (plant#733489 <=> plant#733539.internalRefUUID))
(224) 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]
(225) 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]
(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, ... 12 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, ... 4 more fields]
(228) 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
(229) Repartition
Arguments: 25, true
(230) SubqueryAlias
Arguments: tmp
(231) Join
Arguments: LeftOuter, (product#733494 = internalUUID#733549)
(232) 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]
(233) 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]
(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, ... 6 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, ... 7 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, ... 8 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, ... 8 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, ... 9 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, ... 10 more fields]
(240) SubqueryAlias
Arguments: worklist
(241) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#733567, plant#733568, logisticalRoundingRule#733569]
(242) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(243) Join
Arguments: LeftOuter, ((preferredRoundingProfile#733566 <=> logisticalRoundingProfile#733567) AND (plant#733489 <=> plant#733568.internalRefUUID))
(244) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#733570, plant#733571, logisticalRoundingRule#733572]
(245) Filter
Arguments: isnull(plant#733571.internalRefUUID)
(246) SubqueryAlias
Arguments: allPlantRoundingProfiles
(247) Join
Arguments: LeftOuter, (preferredRoundingProfile#733566 <=> logisticalRoundingProfile#733570)
(248) 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]
(249) 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]
(250) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#733575, unitOfMeasure#733576]
(251) Aggregate
Arguments: [logisticalRoundingRule#733575], [logisticalRoundingRule#733575, collect_list(unitOfMeasure#733576.internalRefUUID, 0, 0) AS preferredUOMs#733577]
(252) Join
Arguments: LeftOuter, (logisticalRoundingRule#733574.logisticalRoundingRule = logisticalRoundingRule#733575)
(253) 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]
(254) 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]
(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, ... 8 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, ... 9 more fields]
(258) LogicalRelation
Arguments: parquet, [product#733581, plant#733582, orderDateTime#733583, constraintprofile#733584], false
(259) Repartition
Arguments: 25, true
(260) Join
Arguments: LeftOuter, (((product#733494 <=> product#733581) AND (plant#733489 <=> plant#733582)) AND (orderDateTime#733495 <=> orderDateTime#733583))
(261) 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]
(262) LogicalRelation
Arguments: parquet, [constraintProfile#733585, descriptions#733586, minServiceLevel#733587, minServiceLevelMinStock#733588, maxServiceLevelEndListing#733589, maxRangeCoverage#733590, minOrderQuantity#733591, profileType#733592, eventtype#733593], false
(263) Repartition
Arguments: 25, true
(264) Join
Arguments: LeftOuter, (constraintProfile#733584 <=> constraintProfile#733585)
(265) 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]
(266) 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]
(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, ... 10 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, ... 15 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, ... 15 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, ... 14 more fields]
(271) LocalRelation
Arguments: <empty>, [orderProposalId#733602, orderProposalItemId#733603, constraintOverwrites#733604]
(272) 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]
(273) 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]
(274) Join
Arguments: LeftOuter, ((orderProposalId#733503L = cast(orderProposalId#733602 as bigint)) AND (orderProposalItemId#733511 = orderProposalItemId#733603))
(275) 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]
(276) 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]
(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, ... 14 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, ... 16 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, ... 17 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, ... 18 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, ... 19 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, ... 20 more fields]
(286) LogicalRelation
Arguments: parquet, [systemId#733616, internalUUID#733617, code#733618, name#733619, commercialCode#733620, isoCode#733621], false
(287) Repartition
Arguments: 25, true
(288) SubqueryAlias
Arguments: unitOfMeasure
(289) 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)
(290) 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]
(291) LogicalRelation
Arguments: parquet, [systemId#733623, internalUUID#733624, code#733625, name#733626, commercialCode#733627, isoCode#733628], false
(292) Repartition
Arguments: 25, true
(293) SubqueryAlias
Arguments: unitOfMeasure
(294) 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)
(295) 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]
(296) 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]
(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, ... 21 more fields]
(298) LogicalRelation
Arguments: parquet, [supplier#733632, subrange#733633, plant#733634, deliverydatetime#733635, ordergroupingprofile#733636, supplierGroup#733637, locationGroup#733638, optimizationGroups#733639], false
(299) Repartition
Arguments: 25, true
(300) 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]
(301) 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]
(302) 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))
(303) 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]
(304) 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]
(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, ... 21 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, ... 20 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, ... 19 more fields]
(308) Project
Arguments: [orderProposalId#733503L, sequenceId#733508]
(309) Deduplicate
Arguments: [orderProposalId#733503L, sequenceId#733508]
(310) 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
(311) RepartitionByExpression
Arguments: [product#733650, plant#733645], 25
(312) 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
(313) Repartition
Arguments: 25, true
(314) SubqueryAlias
Arguments: sos
(315) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#733655 <=> internalUUID#733669)
(316) 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]
(317) 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]
(318) LogicalRelation
Arguments: parquet, [systemId#733693, internalUUID#733694, plant#733695, product#733696, blockedForReplenishmentStartingFrom#733697, productionAspect#733698, salesPlant#733699, listing#733700], false
(319) Repartition
Arguments: 25, true
(320) Filter
Arguments: plant#733695.internalRefUUID IN (1c037502c75549dc72c6fc87c802bcec,717937a4d5db853d3359b6a0623cfdf0,4d233bd0bf112aded9d852448354b078,fca7a07ad5f143db2beafbd1d0401ea1,45f9c5206af43e1e6acbe19d9a246289,6d24a939f4bbd79f6acb8684d6e45c97,3d84243e56ebf98292ed5dba2fd51543,24a9ebb440508219166784d4d1c19eef,f80b06f7b2102a5f5c63b031eb5d8e03,25c0d9731dd07bb53999d9a8f04398e0)
(321) SubqueryAlias
Arguments: pp
(322) Join
Arguments: LeftOuter, ((product#733650 <=> product#733696.internalRefUUID) AND (plant#733645 <=> plant#733695.internalRefUUID))
(323) 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]
(324) 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]
(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, ... 12 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, ... 4 more fields]
(327) 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
(328) Repartition
Arguments: 25, true
(329) SubqueryAlias
Arguments: tmp
(330) Join
Arguments: LeftOuter, (product#733650 = internalUUID#733705)
(331) 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]
(332) 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]
(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, ... 6 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, ... 7 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, ... 8 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, ... 8 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, ... 9 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, ... 10 more fields]
(339) SubqueryAlias
Arguments: worklist
(340) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#733723, plant#733724, logisticalRoundingRule#733725]
(341) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(342) Join
Arguments: LeftOuter, ((preferredRoundingProfile#733722 <=> logisticalRoundingProfile#733723) AND (plant#733645 <=> plant#733724.internalRefUUID))
(343) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#733726, plant#733727, logisticalRoundingRule#733728]
(344) Filter
Arguments: isnull(plant#733727.internalRefUUID)
(345) SubqueryAlias
Arguments: allPlantRoundingProfiles
(346) Join
Arguments: LeftOuter, (preferredRoundingProfile#733722 <=> logisticalRoundingProfile#733726)
(347) 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]
(348) 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]
(349) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#733731, unitOfMeasure#733732]
(350) Aggregate
Arguments: [logisticalRoundingRule#733731], [logisticalRoundingRule#733731, collect_list(unitOfMeasure#733732.internalRefUUID, 0, 0) AS preferredUOMs#733733]
(351) Join
Arguments: LeftOuter, (logisticalRoundingRule#733730.logisticalRoundingRule = logisticalRoundingRule#733731)
(352) 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]
(353) 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]
(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, ... 8 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, ... 9 more fields]
(357) LogicalRelation
Arguments: parquet, [product#733737, plant#733738, orderDateTime#733739, constraintprofile#733740], false
(358) Repartition
Arguments: 25, true
(359) Join
Arguments: LeftOuter, (((product#733650 <=> product#733737) AND (plant#733645 <=> plant#733738)) AND (orderDateTime#733651 <=> orderDateTime#733739))
(360) 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]
(361) LogicalRelation
Arguments: parquet, [constraintProfile#733741, descriptions#733742, minServiceLevel#733743, minServiceLevelMinStock#733744, maxServiceLevelEndListing#733745, maxRangeCoverage#733746, minOrderQuantity#733747, profileType#733748, eventtype#733749], false
(362) Repartition
Arguments: 25, true
(363) Join
Arguments: LeftOuter, (constraintProfile#733740 <=> constraintProfile#733741)
(364) 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]
(365) 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]
(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, ... 10 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, ... 15 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, ... 15 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, ... 14 more fields]
(370) LocalRelation
Arguments: <empty>, [orderProposalId#733758, orderProposalItemId#733759, constraintOverwrites#733760]
(371) 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]
(372) 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]
(373) Join
Arguments: LeftOuter, ((orderProposalId#733659L = cast(orderProposalId#733758 as bigint)) AND (orderProposalItemId#733667 = orderProposalItemId#733759))
(374) 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]
(375) 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]
(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, ... 14 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, ... 16 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, ... 17 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, ... 18 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, ... 19 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, ... 20 more fields]
(385) LogicalRelation
Arguments: parquet, [systemId#733772, internalUUID#733773, code#733774, name#733775, commercialCode#733776, isoCode#733777], false
(386) Repartition
Arguments: 25, true
(387) SubqueryAlias
Arguments: unitOfMeasure
(388) 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)
(389) 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]
(390) LogicalRelation
Arguments: parquet, [systemId#733779, internalUUID#733780, code#733781, name#733782, commercialCode#733783, isoCode#733784], false
(391) Repartition
Arguments: 25, true
(392) SubqueryAlias
Arguments: unitOfMeasure
(393) 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)
(394) 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]
(395) 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]
(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, ... 21 more fields]
(397) LogicalRelation
Arguments: parquet, [supplier#733788, subrange#733789, plant#733790, deliverydatetime#733791, ordergroupingprofile#733792, supplierGroup#733793, locationGroup#733794, optimizationGroups#733795], false
(398) Repartition
Arguments: 25, true
(399) 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]
(400) 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]
(401) 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))
(402) 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]
(403) 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]
(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, ... 21 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, ... 20 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, ... 19 more fields]
(407) Generate
Arguments: explode(optimizationGroups#733798), true, [optGroupId#733799]
(408) Project
Arguments: [orderProposalId#733659L, optGroupId#733799]
(409) Deduplicate
Arguments: [orderProposalId#733659L, optGroupId#733799]
(410) LogicalRelation
Arguments: parquet, [optGroupId#733800, assignmentDetails#733801, minOrderProfile#733802, multiplerestrictionprofile#733803], false
(411) Repartition
Arguments: 25, true
(412) Filter
Arguments: (isnotnull(optGroupId#733800) AND isnotnull(minOrderProfile#733802))
(413) Join
Arguments: Inner, (optGroupId#733799 = optGroupId#733800)
(414) Project
Arguments: [optGroupId#733799, orderProposalId#733659L, assignmentDetails#733801, minOrderProfile#733802, multiplerestrictionprofile#733803]
(415) Join
Arguments: LeftOuter, (orderProposalId#733503L = orderProposalId#733659L)
(416) Project
Arguments: [orderProposalId#733503L, sequenceId#733508, optGroupId#733799, assignmentDetails#733801, minOrderProfile#733802, multiplerestrictionprofile#733803]
(417) LogicalRelation
Arguments: parquet, [supplierminimumprofilename#733460, descriptions#733461, dimensionType#733462, dimensionValue#733463, dimensionUnit#733464, acceptanceThreshold#733465, profileType#733466, eventtype#733467], false
(418) Repartition
Arguments: 25, true
(419) Join
Arguments: Inner, (minOrderProfile#733802 <=> supplierminimumprofilename#733460)
(420) LogicalRelation
Arguments: parquet, [systemId#733468, internalUUID#733469, code#733470, name#733471, commercialCode#733472, isoCode#733473], false
(421) Repartition
Arguments: 25, true
(422) Join
Arguments: LeftOuter, (dimensionUnit#733464.dimensionCodeUuid <=> internalUUID#733469)
(423) 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]
(424) 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]
(425) Project
Arguments: [orderProposalId#733503L, sequenceId#733508, optGroupId#733799, assignmentDetails#733801, minOrderProfile#733802, multiplerestrictionprofile#733803, minOrderGoal#733483]
(426) Project
Arguments: [orderProposalId#733503L, optGroupId#733799, assignmentDetails#733801, minOrderProfile#733802, multiplerestrictionprofile#733803, minOrderGoal#733483]
(427) Join
Arguments: LeftOuter, (orderProposalId#732291L = orderProposalId#733503L)
(428) Project
Arguments: [orderProposalId#732291L, sequenceId#732296, optGroupId#733799, assignmentDetails#733801, minOrderProfile#733802, multiplerestrictionprofile#733803, minOrderGoal#733483]
(429) 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]
(430) Project
Arguments: [orderProposalId#732291L, sequenceId#732296, filter(optimizationGroups#733815, lambdafunction(isnotnull(lambda x_1942#733825.optGroupId), lambda x_1942#733825, false)) AS optimizationGroups#733824]
(431) Project
Arguments: [orderProposalId#732291L, sequenceId#732296, optimizationGroups#733824, 0_1_10000002108 AS shardId#737922]