== 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@1295b277, [__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/10000002110], Overwrite
(3) LogicalRelation
Arguments: parquet, [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903], false
(4) RepartitionByExpression
Arguments: [product#913886, plant#913881], 25
(5) LogicalRelation
Arguments: parquet, [systemId#913905, internalUUID#913906, supplier#913907, receiver#913908, product#913909, receivingPlant#913910, sourceOfSupplyType#913911, purchasingGroup#913912, purchasingOrganization#913913, productGroup#913914, validFrom#913915, validTo#913916, priority#913917, isPurchasingBlocked#913918, isConsignment#913919, isDeleted#913920, supplierSubrange#913921, plannedDeliveryTimeDays#913922, orderQuantityUnit#913923, purchasingPriceAspect#913924, orderCurrency#913925, minimumOrderQuantity#913926, logisticalRoundingProfile#913927, supplyingPlant#913928], false
(6) Repartition
Arguments: 25, true
(7) SubqueryAlias
Arguments: sos
(8) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#913891 <=> internalUUID#913906)
(9) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 25 more fields]
(10) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 1 more fields]
(11) LogicalRelation
Arguments: parquet, [systemId#913933, internalUUID#913934, plant#913935, product#913936, blockedForReplenishmentStartingFrom#913937, productionAspect#913938, salesPlant#913939, listing#913940], false
(12) Repartition
Arguments: 25, true
(13) Filter
Arguments: plant#913935.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(14) SubqueryAlias
Arguments: pp
(15) Join
Arguments: LeftOuter, ((product#913886 <=> product#913936.internalRefUUID) AND (plant#913881 <=> plant#913935.internalRefUUID))
(16) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 10 more fields]
(17) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 11 more fields]
(18) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 12 more fields]
(19) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 4 more fields]
(20) LogicalRelation
Arguments: parquet, [systemId#913950, internalUUID#913951, id#913952, displayId#913953, name#913954, baseUnitOfMeasure#913955, unitOfMeasures#913956, unitOfMeasureConversions#913957, productionAspect#913958, salesAspect#913959, procurementAspect#913960, productGroup#913961], false
(21) Repartition
Arguments: 25, true
(22) SubqueryAlias
Arguments: tmp
(23) Join
Arguments: LeftOuter, (product#913886 = internalUUID#913951)
(24) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 17 more fields]
(25) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 5 more fields]
(26) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 6 more fields]
(27) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 7 more fields]
(28) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 8 more fields]
(29) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 8 more fields]
(30) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 9 more fields]
(31) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 10 more fields]
(32) SubqueryAlias
Arguments: worklist
(33) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#913993, plant#913994, logisticalRoundingRule#913995]
(34) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(35) Join
Arguments: LeftOuter, ((preferredRoundingProfile#913986 <=> logisticalRoundingProfile#913993) AND (plant#913881 <=> plant#913994.internalRefUUID))
(36) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#914020, plant#914021, logisticalRoundingRule#914022]
(37) Filter
Arguments: isnull(plant#914021.internalRefUUID)
(38) SubqueryAlias
Arguments: allPlantRoundingProfiles
(39) Join
Arguments: LeftOuter, (preferredRoundingProfile#913986 <=> logisticalRoundingProfile#914020)
(40) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 17 more fields]
(41) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 11 more fields]
(42) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#914011, unitOfMeasure#914012]
(43) Aggregate
Arguments: [logisticalRoundingRule#914011], [logisticalRoundingRule#914011, collect_list(unitOfMeasure#914012.internalRefUUID, 0, 0) AS preferredUOMs#914013]
(44) Join
Arguments: LeftOuter, (logisticalRoundingRule#914024.logisticalRoundingRule = logisticalRoundingRule#914011)
(45) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 11 more fields]
(46) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 11 more fields]
(47) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 11 more fields]
(48) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 8 more fields]
(49) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 9 more fields]
(50) LogicalRelation
Arguments: parquet, [product#914037, plant#914038, orderDateTime#914039, constraintprofile#914040], false
(51) Repartition
Arguments: 25, true
(52) Join
Arguments: LeftOuter, (((product#913886 <=> product#914037) AND (plant#913881 <=> plant#914038)) AND (orderDateTime#913887 <=> orderDateTime#914039))
(53) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 10 more fields]
(54) LogicalRelation
Arguments: parquet, [constraintProfile#914041, descriptions#914042, minServiceLevel#914043, minServiceLevelMinStock#914044, maxServiceLevelEndListing#914045, maxRangeCoverage#914046, minOrderQuantity#914047, profileType#914048, eventtype#914049], false
(55) Repartition
Arguments: 25, true
(56) Join
Arguments: LeftOuter, (constraintProfile#914040 <=> constraintProfile#914041)
(57) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 20 more fields]
(58) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 10 more fields]
(59) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 10 more fields]
(60) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 15 more fields]
(61) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 15 more fields]
(62) Project
Arguments: [supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalId#913895L, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, orderProposalItemId#913903, ... 14 more fields]
(63) LocalRelation
Arguments: <empty>, [orderProposalId#914078, orderProposalItemId#914079, constraintOverwrites#914080]
(64) Project
Arguments: [orderProposalId#914078, orderProposalItemId#914079, filter(constraintOverwrites#914080, lambdafunction(((isnotnull(lambda x_2379#914082.label) AND isnotnull(lambda x_2379#914082.isActive)) AND (((lambda x_2379#914082.isActive = false) OR isnotnull(lambda x_2379#914082.value)) OR (lambda x_2379#914082.label <=> minOrderQuantity))), lambda x_2379#914082, false)) AS constraintOverwrites#914081]
(65) Project
Arguments: [orderProposalId#914078, orderProposalItemId#914079, transform(constraintOverwrites#914081, lambdafunction(struct(label, lambda x_2380#914087.label, value, CASE WHEN ((lambda x_2380#914087.label = minOrderQuantity) OR (lambda x_2380#914087.label = lockedOrderQuantity)) THEN round(lambda x_2380#914087.value, 0) ELSE lambda x_2380#914087.value END, isActive, lambda x_2380#914087.isActive), lambda x_2380#914087, false)) AS constraintOverwrites#914086]
(66) Join
Arguments: LeftOuter, ((orderProposalId#913895L = cast(orderProposalId#914078 as bigint)) AND (orderProposalItemId#913903 = orderProposalItemId#914079))
(67) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 15 more fields]
(68) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 15 more fields]
(69) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 15 more fields]
(70) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 15 more fields]
(71) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 14 more fields]
(72) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 15 more fields]
(73) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 16 more fields]
(74) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 17 more fields]
(75) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 18 more fields]
(76) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 19 more fields]
(77) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 20 more fields]
(78) LogicalRelation
Arguments: parquet, [systemId#914117, internalUUID#914118, code#914119, name#914120, commercialCode#914121, isoCode#914122], false
(79) Repartition
Arguments: 25, true
(80) SubqueryAlias
Arguments: unitOfMeasure
(81) Join
Arguments: LeftOuter, (filter(filter(productInformation#913962.unitOfMeasures, lambdafunction((lambda x_2391#914132.measurementUnit.internalRefUUID = productInformation#913962.baseUnitOfMeasure.internalRefUUID), lambda x_2391#914132, false))[0].productDimensions, lambdafunction((lambda x_2392#914134.dimensionName.code = VOLUME), lambda x_2392#914134, false))[0].measurementUnit.internalRefUUID <=> internalUUID#914118)
(82) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 21 more fields]
(83) LogicalRelation
Arguments: parquet, [systemId#914153, internalUUID#914154, code#914155, name#914156, commercialCode#914157, isoCode#914158], false
(84) Repartition
Arguments: 25, true
(85) SubqueryAlias
Arguments: unitOfMeasure
(86) Join
Arguments: LeftOuter, (filter(filter(productInformation#913962.unitOfMeasures, lambdafunction((lambda x_2393#914160.measurementUnit.internalRefUUID = productInformation#913962.baseUnitOfMeasure.internalRefUUID), lambda x_2393#914160, false))[0].productDimensions, lambdafunction((lambda x_2394#914162.dimensionName.code = GROSS_WT), lambda x_2394#914162, false))[0].measurementUnit.internalRefUUID <=> internalUUID#914154)
(87) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 22 more fields]
(88) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 20 more fields]
(89) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 21 more fields]
(90) LogicalRelation
Arguments: parquet, [supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, ordergroupingprofile#914188, supplierGroup#914189, locationGroup#914190, optimizationGroups#914191], false
(91) Repartition
Arguments: 25, true
(92) Project
Arguments: [supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, ordergroupingprofile#914188, supplierGroup#914189, locationGroup#914190, optimizationGroups#914191, cast(null as string) AS supplyingPlant#914193]
(93) Project
Arguments: [supplier#914184, subrange#914185, plant#914186, deliverydatetime#914187, ordergroupingprofile#914188, supplierGroup#914189, locationGroup#914190, optimizationGroups#914191, supplyingPlant#914193, cast(null as string) AS productGroup#914194]
(94) Join
Arguments: LeftOuter, (((((((supplierGroup#913879 <=> supplierGroup#914189) AND (supplier#913880 <=> supplier#914184)) AND (subrange#913883 <=> subrange#914185)) AND (plant#913881 <=> plant#914186)) AND (deliveryDateTime#913882 <=> deliveryDateTime#914187)) AND (supplyingPlant#913884 <=> supplyingPlant#914193)) AND (productGroup#913885 <=> productGroup#914194))
(95) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 22 more fields]
(96) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 22 more fields]
(97) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 21 more fields]
(98) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 20 more fields]
(99) Project
Arguments: [orderProposalId#913895L, orderProposalItemId#913903, supplierGroup#913879, supplier#913880, plant#913881, deliveryDateTime#913882, subrange#913883, supplyingPlant#913884, productGroup#913885, product#913886, orderDateTime#913887, availabilityDateTime#913888, nextAvailabilityDateTime#913889, mrpController#913890, sourceOfSupplyUuid#913891, purchasingOrg#913892, purchasingGroup#913893, isFallbackOrderOnly#913894, orderProposalHorizonGroupingId#913896L, splitIndicator#913897L, previousOrderProposal#913898L, clusterId#913899L, sequenceId#913900, worklistShardItemId#913901L, orderProposalItemGroupId#913902, ... 19 more fields]
(100) Project
Arguments: [orderProposalId#913895L, sequenceId#913900]
(101) Deduplicate
Arguments: [orderProposalId#913895L, sequenceId#913900]
(102) LogicalRelation
Arguments: parquet, [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190], false
(103) RepartitionByExpression
Arguments: [product#915173, plant#915168], 25
(104) LogicalRelation
Arguments: parquet, [systemId#915191, internalUUID#915192, supplier#915193, receiver#915194, product#915195, receivingPlant#915196, sourceOfSupplyType#915197, purchasingGroup#915198, purchasingOrganization#915199, productGroup#915200, validFrom#915201, validTo#915202, priority#915203, isPurchasingBlocked#915204, isConsignment#915205, isDeleted#915206, supplierSubrange#915207, plannedDeliveryTimeDays#915208, orderQuantityUnit#915209, purchasingPriceAspect#915210, orderCurrency#915211, minimumOrderQuantity#915212, logisticalRoundingProfile#915213, supplyingPlant#915214], false
(105) Repartition
Arguments: 25, true
(106) SubqueryAlias
Arguments: sos
(107) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#915178 <=> internalUUID#915192)
(108) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 25 more fields]
(109) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 1 more fields]
(110) LogicalRelation
Arguments: parquet, [systemId#915216, internalUUID#915217, plant#915218, product#915219, blockedForReplenishmentStartingFrom#915220, productionAspect#915221, salesPlant#915222, listing#915223], false
(111) Repartition
Arguments: 25, true
(112) Filter
Arguments: plant#915218.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(113) SubqueryAlias
Arguments: pp
(114) Join
Arguments: LeftOuter, ((product#915173 <=> product#915219.internalRefUUID) AND (plant#915168 <=> plant#915218.internalRefUUID))
(115) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 10 more fields]
(116) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 11 more fields]
(117) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 12 more fields]
(118) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 4 more fields]
(119) LogicalRelation
Arguments: parquet, [systemId#915227, internalUUID#915228, id#915229, displayId#915230, name#915231, baseUnitOfMeasure#915232, unitOfMeasures#915233, unitOfMeasureConversions#915234, productionAspect#915235, salesAspect#915236, procurementAspect#915237, productGroup#915238], false
(120) Repartition
Arguments: 25, true
(121) SubqueryAlias
Arguments: tmp
(122) Join
Arguments: LeftOuter, (product#915173 = internalUUID#915228)
(123) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 17 more fields]
(124) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 5 more fields]
(125) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 6 more fields]
(126) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 7 more fields]
(127) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 8 more fields]
(128) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 8 more fields]
(129) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 9 more fields]
(130) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 10 more fields]
(131) SubqueryAlias
Arguments: worklist
(132) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#915246, plant#915247, logisticalRoundingRule#915248]
(133) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(134) Join
Arguments: LeftOuter, ((preferredRoundingProfile#915245 <=> logisticalRoundingProfile#915246) AND (plant#915168 <=> plant#915247.internalRefUUID))
(135) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#915249, plant#915250, logisticalRoundingRule#915251]
(136) Filter
Arguments: isnull(plant#915250.internalRefUUID)
(137) SubqueryAlias
Arguments: allPlantRoundingProfiles
(138) Join
Arguments: LeftOuter, (preferredRoundingProfile#915245 <=> logisticalRoundingProfile#915249)
(139) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 17 more fields]
(140) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 11 more fields]
(141) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#915254, unitOfMeasure#915255]
(142) Aggregate
Arguments: [logisticalRoundingRule#915254], [logisticalRoundingRule#915254, collect_list(unitOfMeasure#915255.internalRefUUID, 0, 0) AS preferredUOMs#915256]
(143) Join
Arguments: LeftOuter, (logisticalRoundingRule#915253.logisticalRoundingRule = logisticalRoundingRule#915254)
(144) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 11 more fields]
(145) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 11 more fields]
(146) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 11 more fields]
(147) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 8 more fields]
(148) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 9 more fields]
(149) LogicalRelation
Arguments: parquet, [product#915260, plant#915261, orderDateTime#915262, constraintprofile#915263], false
(150) Repartition
Arguments: 25, true
(151) Join
Arguments: LeftOuter, (((product#915173 <=> product#915260) AND (plant#915168 <=> plant#915261)) AND (orderDateTime#915174 <=> orderDateTime#915262))
(152) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 10 more fields]
(153) LogicalRelation
Arguments: parquet, [constraintProfile#915264, descriptions#915265, minServiceLevel#915266, minServiceLevelMinStock#915267, maxServiceLevelEndListing#915268, maxRangeCoverage#915269, minOrderQuantity#915270, profileType#915271, eventtype#915272], false
(154) Repartition
Arguments: 25, true
(155) Join
Arguments: LeftOuter, (constraintProfile#915263 <=> constraintProfile#915264)
(156) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 20 more fields]
(157) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 10 more fields]
(158) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 10 more fields]
(159) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 15 more fields]
(160) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 15 more fields]
(161) Project
Arguments: [supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalId#915182L, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, orderProposalItemId#915190, ... 14 more fields]
(162) LocalRelation
Arguments: <empty>, [orderProposalId#915281, orderProposalItemId#915282, constraintOverwrites#915283]
(163) Project
Arguments: [orderProposalId#915281, orderProposalItemId#915282, filter(constraintOverwrites#915283, lambdafunction(((isnotnull(lambda x_2379#914082.label) AND isnotnull(lambda x_2379#914082.isActive)) AND (((lambda x_2379#914082.isActive = false) OR isnotnull(lambda x_2379#914082.value)) OR (lambda x_2379#914082.label <=> minOrderQuantity))), lambda x_2379#914082, false)) AS constraintOverwrites#915284]
(164) Project
Arguments: [orderProposalId#915281, orderProposalItemId#915282, transform(constraintOverwrites#915284, lambdafunction(struct(label, lambda x_2380#914087.label, value, CASE WHEN ((lambda x_2380#914087.label = minOrderQuantity) OR (lambda x_2380#914087.label = lockedOrderQuantity)) THEN round(lambda x_2380#914087.value, 0) ELSE lambda x_2380#914087.value END, isActive, lambda x_2380#914087.isActive), lambda x_2380#914087, false)) AS constraintOverwrites#915285]
(165) Join
Arguments: LeftOuter, ((orderProposalId#915182L = cast(orderProposalId#915281 as bigint)) AND (orderProposalItemId#915190 = orderProposalItemId#915282))
(166) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 15 more fields]
(167) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 15 more fields]
(168) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 15 more fields]
(169) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 15 more fields]
(170) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 14 more fields]
(171) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 15 more fields]
(172) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 16 more fields]
(173) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 17 more fields]
(174) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 18 more fields]
(175) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 19 more fields]
(176) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 20 more fields]
(177) LogicalRelation
Arguments: parquet, [systemId#915295, internalUUID#915296, code#915297, name#915298, commercialCode#915299, isoCode#915300], false
(178) Repartition
Arguments: 25, true
(179) SubqueryAlias
Arguments: unitOfMeasure
(180) Join
Arguments: LeftOuter, (filter(filter(productInformation#915239.unitOfMeasures, lambdafunction((lambda x_2391#914132.measurementUnit.internalRefUUID = productInformation#915239.baseUnitOfMeasure.internalRefUUID), lambda x_2391#914132, false))[0].productDimensions, lambdafunction((lambda x_2392#914134.dimensionName.code = VOLUME), lambda x_2392#914134, false))[0].measurementUnit.internalRefUUID <=> internalUUID#915296)
(181) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 21 more fields]
(182) LogicalRelation
Arguments: parquet, [systemId#915302, internalUUID#915303, code#915304, name#915305, commercialCode#915306, isoCode#915307], false
(183) Repartition
Arguments: 25, true
(184) SubqueryAlias
Arguments: unitOfMeasure
(185) Join
Arguments: LeftOuter, (filter(filter(productInformation#915239.unitOfMeasures, lambdafunction((lambda x_2393#914160.measurementUnit.internalRefUUID = productInformation#915239.baseUnitOfMeasure.internalRefUUID), lambda x_2393#914160, false))[0].productDimensions, lambdafunction((lambda x_2394#914162.dimensionName.code = GROSS_WT), lambda x_2394#914162, false))[0].measurementUnit.internalRefUUID <=> internalUUID#915303)
(186) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 22 more fields]
(187) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 20 more fields]
(188) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 21 more fields]
(189) LogicalRelation
Arguments: parquet, [supplier#915311, subrange#915312, plant#915313, deliverydatetime#915314, ordergroupingprofile#915315, supplierGroup#915316, locationGroup#915317, optimizationGroups#915318], false
(190) Repartition
Arguments: 25, true
(191) Project
Arguments: [supplier#915311, subrange#915312, plant#915313, deliverydatetime#915314, ordergroupingprofile#915315, supplierGroup#915316, locationGroup#915317, optimizationGroups#915318, cast(null as string) AS supplyingPlant#915319]
(192) Project
Arguments: [supplier#915311, subrange#915312, plant#915313, deliverydatetime#915314, ordergroupingprofile#915315, supplierGroup#915316, locationGroup#915317, optimizationGroups#915318, supplyingPlant#915319, cast(null as string) AS productGroup#915320]
(193) Join
Arguments: LeftOuter, (((((((supplierGroup#915166 <=> supplierGroup#915316) AND (supplier#915167 <=> supplier#915311)) AND (subrange#915170 <=> subrange#915312)) AND (plant#915168 <=> plant#915313)) AND (deliveryDateTime#915169 <=> deliveryDateTime#915314)) AND (supplyingPlant#915171 <=> supplyingPlant#915319)) AND (productGroup#915172 <=> productGroup#915320))
(194) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 22 more fields]
(195) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 22 more fields]
(196) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 21 more fields]
(197) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 20 more fields]
(198) Project
Arguments: [orderProposalId#915182L, orderProposalItemId#915190, supplierGroup#915166, supplier#915167, plant#915168, deliveryDateTime#915169, subrange#915170, supplyingPlant#915171, productGroup#915172, product#915173, orderDateTime#915174, availabilityDateTime#915175, nextAvailabilityDateTime#915176, mrpController#915177, sourceOfSupplyUuid#915178, purchasingOrg#915179, purchasingGroup#915180, isFallbackOrderOnly#915181, orderProposalHorizonGroupingId#915183L, splitIndicator#915184L, previousOrderProposal#915185L, clusterId#915186L, sequenceId#915187, worklistShardItemId#915188L, orderProposalItemGroupId#915189, ... 19 more fields]
(199) Generate
Arguments: explode(optimizationGroups#915321), true, [optGroupId#915165]
(200) Project
Arguments: [orderProposalId#915182L, optGroupId#915165]
(201) Deduplicate
Arguments: [orderProposalId#915182L, optGroupId#915165]
(202) LogicalRelation
Arguments: parquet, [optGroupId#915159, assignmentDetails#915160, minOrderProfile#915161, multiplerestrictionprofile#915162], false
(203) Repartition
Arguments: 25, true
(204) Filter
Arguments: (isnotnull(optGroupId#915159) AND isnotnull(minOrderProfile#915161))
(205) Join
Arguments: Inner, (optGroupId#915165 = optGroupId#915159)
(206) Project
Arguments: [optGroupId#915165, orderProposalId#915182L, assignmentDetails#915160, minOrderProfile#915161, multiplerestrictionprofile#915162]
(207) Join
Arguments: LeftOuter, (orderProposalId#913895L = orderProposalId#915182L)
(208) Project
Arguments: [orderProposalId#913895L, sequenceId#913900, optGroupId#915165, assignmentDetails#915160, minOrderProfile#915161, multiplerestrictionprofile#915162]
(209) Project
Arguments: [orderProposalId#913895L, sequenceId#913900]
(210) Deduplicate
Arguments: [orderProposalId#913895L, sequenceId#913900]
(211) LogicalRelation
Arguments: parquet, [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378], false
(212) RepartitionByExpression
Arguments: [product#915361, plant#915356], 25
(213) LogicalRelation
Arguments: parquet, [systemId#915379, internalUUID#915380, supplier#915381, receiver#915382, product#915383, receivingPlant#915384, sourceOfSupplyType#915385, purchasingGroup#915386, purchasingOrganization#915387, productGroup#915388, validFrom#915389, validTo#915390, priority#915391, isPurchasingBlocked#915392, isConsignment#915393, isDeleted#915394, supplierSubrange#915395, plannedDeliveryTimeDays#915396, orderQuantityUnit#915397, purchasingPriceAspect#915398, orderCurrency#915399, minimumOrderQuantity#915400, logisticalRoundingProfile#915401, supplyingPlant#915402], false
(214) Repartition
Arguments: 25, true
(215) SubqueryAlias
Arguments: sos
(216) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#915366 <=> internalUUID#915380)
(217) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 25 more fields]
(218) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 1 more fields]
(219) LogicalRelation
Arguments: parquet, [systemId#915404, internalUUID#915405, plant#915406, product#915407, blockedForReplenishmentStartingFrom#915408, productionAspect#915409, salesPlant#915410, listing#915411], false
(220) Repartition
Arguments: 25, true
(221) Filter
Arguments: plant#915406.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(222) SubqueryAlias
Arguments: pp
(223) Join
Arguments: LeftOuter, ((product#915361 <=> product#915407.internalRefUUID) AND (plant#915356 <=> plant#915406.internalRefUUID))
(224) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 10 more fields]
(225) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 11 more fields]
(226) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 12 more fields]
(227) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 4 more fields]
(228) LogicalRelation
Arguments: parquet, [systemId#915415, internalUUID#915416, id#915417, displayId#915418, name#915419, baseUnitOfMeasure#915420, unitOfMeasures#915421, unitOfMeasureConversions#915422, productionAspect#915423, salesAspect#915424, procurementAspect#915425, productGroup#915426], false
(229) Repartition
Arguments: 25, true
(230) SubqueryAlias
Arguments: tmp
(231) Join
Arguments: LeftOuter, (product#915361 = internalUUID#915416)
(232) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 17 more fields]
(233) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 5 more fields]
(234) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 6 more fields]
(235) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 7 more fields]
(236) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 8 more fields]
(237) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 8 more fields]
(238) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 9 more fields]
(239) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 10 more fields]
(240) SubqueryAlias
Arguments: worklist
(241) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#915434, plant#915435, logisticalRoundingRule#915436]
(242) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(243) Join
Arguments: LeftOuter, ((preferredRoundingProfile#915433 <=> logisticalRoundingProfile#915434) AND (plant#915356 <=> plant#915435.internalRefUUID))
(244) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#915437, plant#915438, logisticalRoundingRule#915439]
(245) Filter
Arguments: isnull(plant#915438.internalRefUUID)
(246) SubqueryAlias
Arguments: allPlantRoundingProfiles
(247) Join
Arguments: LeftOuter, (preferredRoundingProfile#915433 <=> logisticalRoundingProfile#915437)
(248) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 17 more fields]
(249) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 11 more fields]
(250) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#915442, unitOfMeasure#915443]
(251) Aggregate
Arguments: [logisticalRoundingRule#915442], [logisticalRoundingRule#915442, collect_list(unitOfMeasure#915443.internalRefUUID, 0, 0) AS preferredUOMs#915444]
(252) Join
Arguments: LeftOuter, (logisticalRoundingRule#915441.logisticalRoundingRule = logisticalRoundingRule#915442)
(253) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 11 more fields]
(254) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 11 more fields]
(255) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 11 more fields]
(256) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 8 more fields]
(257) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 9 more fields]
(258) LogicalRelation
Arguments: parquet, [product#915448, plant#915449, orderDateTime#915450, constraintprofile#915451], false
(259) Repartition
Arguments: 25, true
(260) Join
Arguments: LeftOuter, (((product#915361 <=> product#915448) AND (plant#915356 <=> plant#915449)) AND (orderDateTime#915362 <=> orderDateTime#915450))
(261) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 10 more fields]
(262) LogicalRelation
Arguments: parquet, [constraintProfile#915452, descriptions#915453, minServiceLevel#915454, minServiceLevelMinStock#915455, maxServiceLevelEndListing#915456, maxRangeCoverage#915457, minOrderQuantity#915458, profileType#915459, eventtype#915460], false
(263) Repartition
Arguments: 25, true
(264) Join
Arguments: LeftOuter, (constraintProfile#915451 <=> constraintProfile#915452)
(265) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 20 more fields]
(266) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 10 more fields]
(267) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 10 more fields]
(268) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 15 more fields]
(269) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 15 more fields]
(270) Project
Arguments: [supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalId#915370L, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, orderProposalItemId#915378, ... 14 more fields]
(271) LocalRelation
Arguments: <empty>, [orderProposalId#915469, orderProposalItemId#915470, constraintOverwrites#915471]
(272) Project
Arguments: [orderProposalId#915469, orderProposalItemId#915470, filter(constraintOverwrites#915471, lambdafunction(((isnotnull(lambda x_2379#914082.label) AND isnotnull(lambda x_2379#914082.isActive)) AND (((lambda x_2379#914082.isActive = false) OR isnotnull(lambda x_2379#914082.value)) OR (lambda x_2379#914082.label <=> minOrderQuantity))), lambda x_2379#914082, false)) AS constraintOverwrites#915472]
(273) Project
Arguments: [orderProposalId#915469, orderProposalItemId#915470, transform(constraintOverwrites#915472, lambdafunction(struct(label, lambda x_2380#914087.label, value, CASE WHEN ((lambda x_2380#914087.label = minOrderQuantity) OR (lambda x_2380#914087.label = lockedOrderQuantity)) THEN round(lambda x_2380#914087.value, 0) ELSE lambda x_2380#914087.value END, isActive, lambda x_2380#914087.isActive), lambda x_2380#914087, false)) AS constraintOverwrites#915473]
(274) Join
Arguments: LeftOuter, ((orderProposalId#915370L = cast(orderProposalId#915469 as bigint)) AND (orderProposalItemId#915378 = orderProposalItemId#915470))
(275) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 15 more fields]
(276) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 15 more fields]
(277) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 15 more fields]
(278) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 15 more fields]
(279) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 14 more fields]
(280) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 15 more fields]
(281) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 16 more fields]
(282) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 17 more fields]
(283) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 18 more fields]
(284) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 19 more fields]
(285) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 20 more fields]
(286) LogicalRelation
Arguments: parquet, [systemId#915483, internalUUID#915484, code#915485, name#915486, commercialCode#915487, isoCode#915488], false
(287) Repartition
Arguments: 25, true
(288) SubqueryAlias
Arguments: unitOfMeasure
(289) Join
Arguments: LeftOuter, (filter(filter(productInformation#915427.unitOfMeasures, lambdafunction((lambda x_2391#914132.measurementUnit.internalRefUUID = productInformation#915427.baseUnitOfMeasure.internalRefUUID), lambda x_2391#914132, false))[0].productDimensions, lambdafunction((lambda x_2392#914134.dimensionName.code = VOLUME), lambda x_2392#914134, false))[0].measurementUnit.internalRefUUID <=> internalUUID#915484)
(290) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 21 more fields]
(291) LogicalRelation
Arguments: parquet, [systemId#915490, internalUUID#915491, code#915492, name#915493, commercialCode#915494, isoCode#915495], false
(292) Repartition
Arguments: 25, true
(293) SubqueryAlias
Arguments: unitOfMeasure
(294) Join
Arguments: LeftOuter, (filter(filter(productInformation#915427.unitOfMeasures, lambdafunction((lambda x_2393#914160.measurementUnit.internalRefUUID = productInformation#915427.baseUnitOfMeasure.internalRefUUID), lambda x_2393#914160, false))[0].productDimensions, lambdafunction((lambda x_2394#914162.dimensionName.code = GROSS_WT), lambda x_2394#914162, false))[0].measurementUnit.internalRefUUID <=> internalUUID#915491)
(295) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 22 more fields]
(296) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 20 more fields]
(297) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 21 more fields]
(298) LogicalRelation
Arguments: parquet, [supplier#915499, subrange#915500, plant#915501, deliverydatetime#915502, ordergroupingprofile#915503, supplierGroup#915504, locationGroup#915505, optimizationGroups#915506], false
(299) Repartition
Arguments: 25, true
(300) Project
Arguments: [supplier#915499, subrange#915500, plant#915501, deliverydatetime#915502, ordergroupingprofile#915503, supplierGroup#915504, locationGroup#915505, optimizationGroups#915506, cast(null as string) AS supplyingPlant#915507]
(301) Project
Arguments: [supplier#915499, subrange#915500, plant#915501, deliverydatetime#915502, ordergroupingprofile#915503, supplierGroup#915504, locationGroup#915505, optimizationGroups#915506, supplyingPlant#915507, cast(null as string) AS productGroup#915508]
(302) Join
Arguments: LeftOuter, (((((((supplierGroup#915354 <=> supplierGroup#915504) AND (supplier#915355 <=> supplier#915499)) AND (subrange#915358 <=> subrange#915500)) AND (plant#915356 <=> plant#915501)) AND (deliveryDateTime#915357 <=> deliveryDateTime#915502)) AND (supplyingPlant#915359 <=> supplyingPlant#915507)) AND (productGroup#915360 <=> productGroup#915508))
(303) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 22 more fields]
(304) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 22 more fields]
(305) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 21 more fields]
(306) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 20 more fields]
(307) Project
Arguments: [orderProposalId#915370L, orderProposalItemId#915378, supplierGroup#915354, supplier#915355, plant#915356, deliveryDateTime#915357, subrange#915358, supplyingPlant#915359, productGroup#915360, product#915361, orderDateTime#915362, availabilityDateTime#915363, nextAvailabilityDateTime#915364, mrpController#915365, sourceOfSupplyUuid#915366, purchasingOrg#915367, purchasingGroup#915368, isFallbackOrderOnly#915369, orderProposalHorizonGroupingId#915371L, splitIndicator#915372L, previousOrderProposal#915373L, clusterId#915374L, sequenceId#915375, worklistShardItemId#915376L, orderProposalItemGroupId#915377, ... 19 more fields]
(308) Project
Arguments: [orderProposalId#915370L, sequenceId#915375]
(309) Deduplicate
Arguments: [orderProposalId#915370L, sequenceId#915375]
(310) LogicalRelation
Arguments: parquet, [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534], false
(311) RepartitionByExpression
Arguments: [product#915517, plant#915512], 25
(312) LogicalRelation
Arguments: parquet, [systemId#915535, internalUUID#915536, supplier#915537, receiver#915538, product#915539, receivingPlant#915540, sourceOfSupplyType#915541, purchasingGroup#915542, purchasingOrganization#915543, productGroup#915544, validFrom#915545, validTo#915546, priority#915547, isPurchasingBlocked#915548, isConsignment#915549, isDeleted#915550, supplierSubrange#915551, plannedDeliveryTimeDays#915552, orderQuantityUnit#915553, purchasingPriceAspect#915554, orderCurrency#915555, minimumOrderQuantity#915556, logisticalRoundingProfile#915557, supplyingPlant#915558], false
(313) Repartition
Arguments: 25, true
(314) SubqueryAlias
Arguments: sos
(315) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#915522 <=> internalUUID#915536)
(316) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 25 more fields]
(317) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 1 more fields]
(318) LogicalRelation
Arguments: parquet, [systemId#915560, internalUUID#915561, plant#915562, product#915563, blockedForReplenishmentStartingFrom#915564, productionAspect#915565, salesPlant#915566, listing#915567], false
(319) Repartition
Arguments: 25, true
(320) Filter
Arguments: plant#915562.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(321) SubqueryAlias
Arguments: pp
(322) Join
Arguments: LeftOuter, ((product#915517 <=> product#915563.internalRefUUID) AND (plant#915512 <=> plant#915562.internalRefUUID))
(323) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 10 more fields]
(324) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 11 more fields]
(325) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 12 more fields]
(326) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 4 more fields]
(327) LogicalRelation
Arguments: parquet, [systemId#915571, internalUUID#915572, id#915573, displayId#915574, name#915575, baseUnitOfMeasure#915576, unitOfMeasures#915577, unitOfMeasureConversions#915578, productionAspect#915579, salesAspect#915580, procurementAspect#915581, productGroup#915582], false
(328) Repartition
Arguments: 25, true
(329) SubqueryAlias
Arguments: tmp
(330) Join
Arguments: LeftOuter, (product#915517 = internalUUID#915572)
(331) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 17 more fields]
(332) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 5 more fields]
(333) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 6 more fields]
(334) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 7 more fields]
(335) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 8 more fields]
(336) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 8 more fields]
(337) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 9 more fields]
(338) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 10 more fields]
(339) SubqueryAlias
Arguments: worklist
(340) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#915590, plant#915591, logisticalRoundingRule#915592]
(341) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(342) Join
Arguments: LeftOuter, ((preferredRoundingProfile#915589 <=> logisticalRoundingProfile#915590) AND (plant#915512 <=> plant#915591.internalRefUUID))
(343) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#915593, plant#915594, logisticalRoundingRule#915595]
(344) Filter
Arguments: isnull(plant#915594.internalRefUUID)
(345) SubqueryAlias
Arguments: allPlantRoundingProfiles
(346) Join
Arguments: LeftOuter, (preferredRoundingProfile#915589 <=> logisticalRoundingProfile#915593)
(347) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 17 more fields]
(348) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 11 more fields]
(349) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#915598, unitOfMeasure#915599]
(350) Aggregate
Arguments: [logisticalRoundingRule#915598], [logisticalRoundingRule#915598, collect_list(unitOfMeasure#915599.internalRefUUID, 0, 0) AS preferredUOMs#915600]
(351) Join
Arguments: LeftOuter, (logisticalRoundingRule#915597.logisticalRoundingRule = logisticalRoundingRule#915598)
(352) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 11 more fields]
(353) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 11 more fields]
(354) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 11 more fields]
(355) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 8 more fields]
(356) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 9 more fields]
(357) LogicalRelation
Arguments: parquet, [product#915604, plant#915605, orderDateTime#915606, constraintprofile#915607], false
(358) Repartition
Arguments: 25, true
(359) Join
Arguments: LeftOuter, (((product#915517 <=> product#915604) AND (plant#915512 <=> plant#915605)) AND (orderDateTime#915518 <=> orderDateTime#915606))
(360) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 10 more fields]
(361) LogicalRelation
Arguments: parquet, [constraintProfile#915608, descriptions#915609, minServiceLevel#915610, minServiceLevelMinStock#915611, maxServiceLevelEndListing#915612, maxRangeCoverage#915613, minOrderQuantity#915614, profileType#915615, eventtype#915616], false
(362) Repartition
Arguments: 25, true
(363) Join
Arguments: LeftOuter, (constraintProfile#915607 <=> constraintProfile#915608)
(364) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 20 more fields]
(365) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 10 more fields]
(366) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 10 more fields]
(367) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 15 more fields]
(368) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 15 more fields]
(369) Project
Arguments: [supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalId#915526L, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, orderProposalItemId#915534, ... 14 more fields]
(370) LocalRelation
Arguments: <empty>, [orderProposalId#915625, orderProposalItemId#915626, constraintOverwrites#915627]
(371) Project
Arguments: [orderProposalId#915625, orderProposalItemId#915626, filter(constraintOverwrites#915627, lambdafunction(((isnotnull(lambda x_2379#914082.label) AND isnotnull(lambda x_2379#914082.isActive)) AND (((lambda x_2379#914082.isActive = false) OR isnotnull(lambda x_2379#914082.value)) OR (lambda x_2379#914082.label <=> minOrderQuantity))), lambda x_2379#914082, false)) AS constraintOverwrites#915628]
(372) Project
Arguments: [orderProposalId#915625, orderProposalItemId#915626, transform(constraintOverwrites#915628, lambdafunction(struct(label, lambda x_2380#914087.label, value, CASE WHEN ((lambda x_2380#914087.label = minOrderQuantity) OR (lambda x_2380#914087.label = lockedOrderQuantity)) THEN round(lambda x_2380#914087.value, 0) ELSE lambda x_2380#914087.value END, isActive, lambda x_2380#914087.isActive), lambda x_2380#914087, false)) AS constraintOverwrites#915629]
(373) Join
Arguments: LeftOuter, ((orderProposalId#915526L = cast(orderProposalId#915625 as bigint)) AND (orderProposalItemId#915534 = orderProposalItemId#915626))
(374) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 15 more fields]
(375) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 15 more fields]
(376) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 15 more fields]
(377) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 15 more fields]
(378) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 14 more fields]
(379) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 15 more fields]
(380) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 16 more fields]
(381) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 17 more fields]
(382) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 18 more fields]
(383) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 19 more fields]
(384) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 20 more fields]
(385) LogicalRelation
Arguments: parquet, [systemId#915639, internalUUID#915640, code#915641, name#915642, commercialCode#915643, isoCode#915644], false
(386) Repartition
Arguments: 25, true
(387) SubqueryAlias
Arguments: unitOfMeasure
(388) Join
Arguments: LeftOuter, (filter(filter(productInformation#915583.unitOfMeasures, lambdafunction((lambda x_2391#914132.measurementUnit.internalRefUUID = productInformation#915583.baseUnitOfMeasure.internalRefUUID), lambda x_2391#914132, false))[0].productDimensions, lambdafunction((lambda x_2392#914134.dimensionName.code = VOLUME), lambda x_2392#914134, false))[0].measurementUnit.internalRefUUID <=> internalUUID#915640)
(389) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 21 more fields]
(390) LogicalRelation
Arguments: parquet, [systemId#915646, internalUUID#915647, code#915648, name#915649, commercialCode#915650, isoCode#915651], false
(391) Repartition
Arguments: 25, true
(392) SubqueryAlias
Arguments: unitOfMeasure
(393) Join
Arguments: LeftOuter, (filter(filter(productInformation#915583.unitOfMeasures, lambdafunction((lambda x_2393#914160.measurementUnit.internalRefUUID = productInformation#915583.baseUnitOfMeasure.internalRefUUID), lambda x_2393#914160, false))[0].productDimensions, lambdafunction((lambda x_2394#914162.dimensionName.code = GROSS_WT), lambda x_2394#914162, false))[0].measurementUnit.internalRefUUID <=> internalUUID#915647)
(394) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 22 more fields]
(395) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 20 more fields]
(396) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 21 more fields]
(397) LogicalRelation
Arguments: parquet, [supplier#915655, subrange#915656, plant#915657, deliverydatetime#915658, ordergroupingprofile#915659, supplierGroup#915660, locationGroup#915661, optimizationGroups#915662], false
(398) Repartition
Arguments: 25, true
(399) Project
Arguments: [supplier#915655, subrange#915656, plant#915657, deliverydatetime#915658, ordergroupingprofile#915659, supplierGroup#915660, locationGroup#915661, optimizationGroups#915662, cast(null as string) AS supplyingPlant#915663]
(400) Project
Arguments: [supplier#915655, subrange#915656, plant#915657, deliverydatetime#915658, ordergroupingprofile#915659, supplierGroup#915660, locationGroup#915661, optimizationGroups#915662, supplyingPlant#915663, cast(null as string) AS productGroup#915664]
(401) Join
Arguments: LeftOuter, (((((((supplierGroup#915510 <=> supplierGroup#915660) AND (supplier#915511 <=> supplier#915655)) AND (subrange#915514 <=> subrange#915656)) AND (plant#915512 <=> plant#915657)) AND (deliveryDateTime#915513 <=> deliveryDateTime#915658)) AND (supplyingPlant#915515 <=> supplyingPlant#915663)) AND (productGroup#915516 <=> productGroup#915664))
(402) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 22 more fields]
(403) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 22 more fields]
(404) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 21 more fields]
(405) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 20 more fields]
(406) Project
Arguments: [orderProposalId#915526L, orderProposalItemId#915534, supplierGroup#915510, supplier#915511, plant#915512, deliveryDateTime#915513, subrange#915514, supplyingPlant#915515, productGroup#915516, product#915517, orderDateTime#915518, availabilityDateTime#915519, nextAvailabilityDateTime#915520, mrpController#915521, sourceOfSupplyUuid#915522, purchasingOrg#915523, purchasingGroup#915524, isFallbackOrderOnly#915525, orderProposalHorizonGroupingId#915527L, splitIndicator#915528L, previousOrderProposal#915529L, clusterId#915530L, sequenceId#915531, worklistShardItemId#915532L, orderProposalItemGroupId#915533, ... 19 more fields]
(407) Generate
Arguments: explode(optimizationGroups#915665), true, [optGroupId#915666]
(408) Project
Arguments: [orderProposalId#915526L, optGroupId#915666]
(409) Deduplicate
Arguments: [orderProposalId#915526L, optGroupId#915666]
(410) LogicalRelation
Arguments: parquet, [optGroupId#915667, assignmentDetails#915668, minOrderProfile#915669, multiplerestrictionprofile#915670], false
(411) Repartition
Arguments: 25, true
(412) Filter
Arguments: (isnotnull(optGroupId#915667) AND isnotnull(minOrderProfile#915669))
(413) Join
Arguments: Inner, (optGroupId#915666 = optGroupId#915667)
(414) Project
Arguments: [optGroupId#915666, orderProposalId#915526L, assignmentDetails#915668, minOrderProfile#915669, multiplerestrictionprofile#915670]
(415) Join
Arguments: LeftOuter, (orderProposalId#915370L = orderProposalId#915526L)
(416) Project
Arguments: [orderProposalId#915370L, sequenceId#915375, optGroupId#915666, assignmentDetails#915668, minOrderProfile#915669, multiplerestrictionprofile#915670]
(417) LogicalRelation
Arguments: parquet, [supplierminimumprofilename#915327, descriptions#915328, dimensionType#915329, dimensionValue#915330, dimensionUnit#915331, acceptanceThreshold#915332, profileType#915333, eventtype#915334], false
(418) Repartition
Arguments: 25, true
(419) Join
Arguments: Inner, (minOrderProfile#915669 <=> supplierminimumprofilename#915327)
(420) LogicalRelation
Arguments: parquet, [systemId#915335, internalUUID#915336, code#915337, name#915338, commercialCode#915339, isoCode#915340], false
(421) Repartition
Arguments: 25, true
(422) Join
Arguments: LeftOuter, (dimensionUnit#915331.dimensionCodeUuid <=> internalUUID#915336)
(423) Project
Arguments: [orderProposalId#915370L, sequenceId#915375, optGroupId#915666, assignmentDetails#915668, minOrderProfile#915669, multiplerestrictionprofile#915670, supplierminimumprofilename#915327, descriptions#915328, dimensionType#915329, dimensionValue#915330, dimensionUnit#915331, acceptanceThreshold#915332, profileType#915333, eventtype#915334, systemId#915335, internalUUID#915336, code#915337, name#915338, commercialCode#915339, isoCode#915340, struct(minOrderValue, dimensionValue#915330, dimensionType, dimensionType#915329, unit, dimensionUnit#915331.dimensionCode, unitUuid, dimensionUnit#915331.dimensionCodeUuid, negligibleQuantitiesThreshold, 0.0, acceptanceThreshold, (acceptanceThreshold#915332 / cast(100 as double)), isoCode, isoCode#915340.code) AS minOrderGoal#915350]
(424) Project
Arguments: [orderProposalId#915370L, sequenceId#915375, optGroupId#915666, assignmentDetails#915668, minOrderProfile#915669, multiplerestrictionprofile#915670, systemId#915335, internalUUID#915336, code#915337, name#915338, commercialCode#915339, isoCode#915340, minOrderGoal#915350]
(425) Project
Arguments: [orderProposalId#915370L, sequenceId#915375, optGroupId#915666, assignmentDetails#915668, minOrderProfile#915669, multiplerestrictionprofile#915670, minOrderGoal#915350]
(426) Project
Arguments: [orderProposalId#915370L, optGroupId#915666, assignmentDetails#915668, minOrderProfile#915669, multiplerestrictionprofile#915670, minOrderGoal#915350]
(427) Join
Arguments: LeftOuter, (orderProposalId#913895L = orderProposalId#915370L)
(428) Project
Arguments: [orderProposalId#913895L, sequenceId#913900, optGroupId#915666, assignmentDetails#915668, minOrderProfile#915669, multiplerestrictionprofile#915670, minOrderGoal#915350]
(429) Aggregate
Arguments: [orderProposalId#913895L, sequenceId#913900], [orderProposalId#913895L, sequenceId#913900, collect_list(struct(optGroupId, optGroupId#915666, assignmentDetails, assignmentDetails#915668, minOrderProfile, minOrderProfile#915669, multiplerestrictionprofile, multiplerestrictionprofile#915670, minOrderGoal, minOrderGoal#915350), 0, 0) AS optimizationGroups#915682]
(430) Project
Arguments: [orderProposalId#913895L, sequenceId#913900, filter(optimizationGroups#915682, lambdafunction(isnotnull(lambda x_2396#915692.optGroupId), lambda x_2396#915692, false)) AS optimizationGroups#915691]
(431) Project
Arguments: [orderProposalId#913895L, sequenceId#913900, optimizationGroups#915691, 0_1_10000002110 AS shardId#920149]