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