== 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@665c0a80, [__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/10000002109], Overwrite
(3) LogicalRelation
Arguments: parquet, [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169], false
(4) RepartitionByExpression
Arguments: [product#826152, plant#826147], 25
(5) LogicalRelation
Arguments: parquet, [systemId#826171, internalUUID#826172, supplier#826173, receiver#826174, product#826175, receivingPlant#826176, sourceOfSupplyType#826177, purchasingGroup#826178, purchasingOrganization#826179, productGroup#826180, validFrom#826181, validTo#826182, priority#826183, isPurchasingBlocked#826184, isConsignment#826185, isDeleted#826186, supplierSubrange#826187, plannedDeliveryTimeDays#826188, orderQuantityUnit#826189, purchasingPriceAspect#826190, orderCurrency#826191, minimumOrderQuantity#826192, logisticalRoundingProfile#826193, supplyingPlant#826194], false
(6) Repartition
Arguments: 25, true
(7) SubqueryAlias
Arguments: sos
(8) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#826157 <=> internalUUID#826172)
(9) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 25 more fields]
(10) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 1 more fields]
(11) LogicalRelation
Arguments: parquet, [systemId#826199, internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206], false
(12) Repartition
Arguments: 25, true
(13) Filter
Arguments: plant#826201.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(14) SubqueryAlias
Arguments: pp
(15) Join
Arguments: LeftOuter, ((product#826152 <=> product#826202.internalRefUUID) AND (plant#826147 <=> plant#826201.internalRefUUID))
(16) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 10 more fields]
(17) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 11 more fields]
(18) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 12 more fields]
(19) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 4 more fields]
(20) LogicalRelation
Arguments: parquet, [systemId#826216, internalUUID#826217, id#826218, displayId#826219, name#826220, baseUnitOfMeasure#826221, unitOfMeasures#826222, unitOfMeasureConversions#826223, productionAspect#826224, salesAspect#826225, procurementAspect#826226, productGroup#826227], false
(21) Repartition
Arguments: 25, true
(22) SubqueryAlias
Arguments: tmp
(23) Join
Arguments: LeftOuter, (product#826152 = internalUUID#826217)
(24) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 17 more fields]
(25) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 5 more fields]
(26) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 6 more fields]
(27) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 7 more fields]
(28) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 8 more fields]
(29) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 8 more fields]
(30) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 9 more fields]
(31) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 10 more fields]
(32) SubqueryAlias
Arguments: worklist
(33) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#826259, plant#826260, logisticalRoundingRule#826261]
(34) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(35) Join
Arguments: LeftOuter, ((preferredRoundingProfile#826252 <=> logisticalRoundingProfile#826259) AND (plant#826147 <=> plant#826260.internalRefUUID))
(36) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#826286, plant#826287, logisticalRoundingRule#826288]
(37) Filter
Arguments: isnull(plant#826287.internalRefUUID)
(38) SubqueryAlias
Arguments: allPlantRoundingProfiles
(39) Join
Arguments: LeftOuter, (preferredRoundingProfile#826252 <=> logisticalRoundingProfile#826286)
(40) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 17 more fields]
(41) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 11 more fields]
(42) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#826277, unitOfMeasure#826278]
(43) Aggregate
Arguments: [logisticalRoundingRule#826277], [logisticalRoundingRule#826277, collect_list(unitOfMeasure#826278.internalRefUUID, 0, 0) AS preferredUOMs#826279]
(44) Join
Arguments: LeftOuter, (logisticalRoundingRule#826290.logisticalRoundingRule = logisticalRoundingRule#826277)
(45) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 11 more fields]
(46) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 11 more fields]
(47) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 11 more fields]
(48) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 8 more fields]
(49) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 9 more fields]
(50) LogicalRelation
Arguments: parquet, [product#826303, plant#826304, orderDateTime#826305, constraintprofile#826306], false
(51) Repartition
Arguments: 25, true
(52) Join
Arguments: LeftOuter, (((product#826152 <=> product#826303) AND (plant#826147 <=> plant#826304)) AND (orderDateTime#826153 <=> orderDateTime#826305))
(53) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 10 more fields]
(54) LogicalRelation
Arguments: parquet, [constraintProfile#826307, descriptions#826308, minServiceLevel#826309, minServiceLevelMinStock#826310, maxServiceLevelEndListing#826311, maxRangeCoverage#826312, minOrderQuantity#826313, profileType#826314, eventtype#826315], false
(55) Repartition
Arguments: 25, true
(56) Join
Arguments: LeftOuter, (constraintProfile#826306 <=> constraintProfile#826307)
(57) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 20 more fields]
(58) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 10 more fields]
(59) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 10 more fields]
(60) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 15 more fields]
(61) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 15 more fields]
(62) Project
Arguments: [supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalId#826161L, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, orderProposalItemId#826169, ... 14 more fields]
(63) LocalRelation
Arguments: <empty>, [orderProposalId#826344, orderProposalItemId#826345, constraintOverwrites#826346]
(64) Project
Arguments: [orderProposalId#826344, orderProposalItemId#826345, filter(constraintOverwrites#826346, lambdafunction(((isnotnull(lambda x_2152#826348.label) AND isnotnull(lambda x_2152#826348.isActive)) AND (((lambda x_2152#826348.isActive = false) OR isnotnull(lambda x_2152#826348.value)) OR (lambda x_2152#826348.label <=> minOrderQuantity))), lambda x_2152#826348, false)) AS constraintOverwrites#826347]
(65) Project
Arguments: [orderProposalId#826344, orderProposalItemId#826345, transform(constraintOverwrites#826347, lambdafunction(struct(label, lambda x_2153#826353.label, value, CASE WHEN ((lambda x_2153#826353.label = minOrderQuantity) OR (lambda x_2153#826353.label = lockedOrderQuantity)) THEN round(lambda x_2153#826353.value, 0) ELSE lambda x_2153#826353.value END, isActive, lambda x_2153#826353.isActive), lambda x_2153#826353, false)) AS constraintOverwrites#826352]
(66) Join
Arguments: LeftOuter, ((orderProposalId#826161L = cast(orderProposalId#826344 as bigint)) AND (orderProposalItemId#826169 = orderProposalItemId#826345))
(67) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 15 more fields]
(68) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 15 more fields]
(69) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 15 more fields]
(70) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 15 more fields]
(71) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 14 more fields]
(72) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 15 more fields]
(73) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 16 more fields]
(74) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 17 more fields]
(75) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 18 more fields]
(76) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 19 more fields]
(77) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 20 more fields]
(78) LogicalRelation
Arguments: parquet, [systemId#826405, internalUUID#826406, code#826407, name#826408, commercialCode#826409, isoCode#826410], false
(79) Repartition
Arguments: 25, true
(80) SubqueryAlias
Arguments: unitOfMeasure
(81) Join
Arguments: LeftOuter, (filter(filter(productInformation#826228.unitOfMeasures, lambdafunction((lambda x_2164#826420.measurementUnit.internalRefUUID = productInformation#826228.baseUnitOfMeasure.internalRefUUID), lambda x_2164#826420, false))[0].productDimensions, lambdafunction((lambda x_2165#826422.dimensionName.code = VOLUME), lambda x_2165#826422, false))[0].measurementUnit.internalRefUUID <=> internalUUID#826406)
(82) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 21 more fields]
(83) LogicalRelation
Arguments: parquet, [systemId#826441, internalUUID#826442, code#826443, name#826444, commercialCode#826445, isoCode#826446], false
(84) Repartition
Arguments: 25, true
(85) SubqueryAlias
Arguments: unitOfMeasure
(86) Join
Arguments: LeftOuter, (filter(filter(productInformation#826228.unitOfMeasures, lambdafunction((lambda x_2166#826448.measurementUnit.internalRefUUID = productInformation#826228.baseUnitOfMeasure.internalRefUUID), lambda x_2166#826448, false))[0].productDimensions, lambdafunction((lambda x_2167#826450.dimensionName.code = GROSS_WT), lambda x_2167#826450, false))[0].measurementUnit.internalRefUUID <=> internalUUID#826442)
(87) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 22 more fields]
(88) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 20 more fields]
(89) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 21 more fields]
(90) LogicalRelation
Arguments: parquet, [supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, ordergroupingprofile#826476, supplierGroup#826477, locationGroup#826478, optimizationGroups#826479], false
(91) Repartition
Arguments: 25, true
(92) Project
Arguments: [supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, ordergroupingprofile#826476, supplierGroup#826477, locationGroup#826478, optimizationGroups#826479, cast(null as string) AS supplyingPlant#826481]
(93) Project
Arguments: [supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, ordergroupingprofile#826476, supplierGroup#826477, locationGroup#826478, optimizationGroups#826479, supplyingPlant#826481, cast(null as string) AS productGroup#826482]
(94) Join
Arguments: LeftOuter, (((((((supplierGroup#826145 <=> supplierGroup#826477) AND (supplier#826146 <=> supplier#826472)) AND (subrange#826149 <=> subrange#826473)) AND (plant#826147 <=> plant#826474)) AND (deliveryDateTime#826148 <=> deliveryDateTime#826475)) AND (supplyingPlant#826150 <=> supplyingPlant#826481)) AND (productGroup#826151 <=> productGroup#826482))
(95) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 22 more fields]
(96) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 22 more fields]
(97) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 21 more fields]
(98) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 20 more fields]
(99) Project
Arguments: [orderProposalId#826161L, orderProposalItemId#826169, supplierGroup#826145, supplier#826146, plant#826147, deliveryDateTime#826148, subrange#826149, supplyingPlant#826150, productGroup#826151, product#826152, orderDateTime#826153, availabilityDateTime#826154, nextAvailabilityDateTime#826155, mrpController#826156, sourceOfSupplyUuid#826157, purchasingOrg#826158, purchasingGroup#826159, isFallbackOrderOnly#826160, orderProposalHorizonGroupingId#826162L, splitIndicator#826163L, previousOrderProposal#826164L, clusterId#826165L, sequenceId#826166, worklistShardItemId#826167L, orderProposalItemGroupId#826168, ... 19 more fields]
(100) Project
Arguments: [orderProposalId#826161L, sequenceId#826166]
(101) Deduplicate
Arguments: [orderProposalId#826161L, sequenceId#826166]
(102) LogicalRelation
Arguments: parquet, [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718], false
(103) RepartitionByExpression
Arguments: [product#827701, plant#827696], 25
(104) LogicalRelation
Arguments: parquet, [systemId#827719, internalUUID#827720, supplier#827721, receiver#827722, product#827723, receivingPlant#827724, sourceOfSupplyType#827725, purchasingGroup#827726, purchasingOrganization#827727, productGroup#827728, validFrom#827729, validTo#827730, priority#827731, isPurchasingBlocked#827732, isConsignment#827733, isDeleted#827734, supplierSubrange#827735, plannedDeliveryTimeDays#827736, orderQuantityUnit#827737, purchasingPriceAspect#827738, orderCurrency#827739, minimumOrderQuantity#827740, logisticalRoundingProfile#827741, supplyingPlant#827742], false
(105) Repartition
Arguments: 25, true
(106) SubqueryAlias
Arguments: sos
(107) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#827706 <=> internalUUID#827720)
(108) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 25 more fields]
(109) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 1 more fields]
(110) LogicalRelation
Arguments: parquet, [systemId#827744, internalUUID#827745, plant#827746, product#827747, blockedForReplenishmentStartingFrom#827748, productionAspect#827749, salesPlant#827750, listing#827751], false
(111) Repartition
Arguments: 25, true
(112) Filter
Arguments: plant#827746.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(113) SubqueryAlias
Arguments: pp
(114) Join
Arguments: LeftOuter, ((product#827701 <=> product#827747.internalRefUUID) AND (plant#827696 <=> plant#827746.internalRefUUID))
(115) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 10 more fields]
(116) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 11 more fields]
(117) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 12 more fields]
(118) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 4 more fields]
(119) LogicalRelation
Arguments: parquet, [systemId#827755, internalUUID#827756, id#827757, displayId#827758, name#827759, baseUnitOfMeasure#827760, unitOfMeasures#827761, unitOfMeasureConversions#827762, productionAspect#827763, salesAspect#827764, procurementAspect#827765, productGroup#827766], false
(120) Repartition
Arguments: 25, true
(121) SubqueryAlias
Arguments: tmp
(122) Join
Arguments: LeftOuter, (product#827701 = internalUUID#827756)
(123) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 17 more fields]
(124) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 5 more fields]
(125) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 6 more fields]
(126) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 7 more fields]
(127) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 8 more fields]
(128) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 8 more fields]
(129) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 9 more fields]
(130) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 10 more fields]
(131) SubqueryAlias
Arguments: worklist
(132) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#827774, plant#827775, logisticalRoundingRule#827776]
(133) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(134) Join
Arguments: LeftOuter, ((preferredRoundingProfile#827773 <=> logisticalRoundingProfile#827774) AND (plant#827696 <=> plant#827775.internalRefUUID))
(135) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#827777, plant#827778, logisticalRoundingRule#827779]
(136) Filter
Arguments: isnull(plant#827778.internalRefUUID)
(137) SubqueryAlias
Arguments: allPlantRoundingProfiles
(138) Join
Arguments: LeftOuter, (preferredRoundingProfile#827773 <=> logisticalRoundingProfile#827777)
(139) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 17 more fields]
(140) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 11 more fields]
(141) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#827782, unitOfMeasure#827783]
(142) Aggregate
Arguments: [logisticalRoundingRule#827782], [logisticalRoundingRule#827782, collect_list(unitOfMeasure#827783.internalRefUUID, 0, 0) AS preferredUOMs#827784]
(143) Join
Arguments: LeftOuter, (logisticalRoundingRule#827781.logisticalRoundingRule = logisticalRoundingRule#827782)
(144) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 11 more fields]
(145) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 11 more fields]
(146) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 11 more fields]
(147) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 8 more fields]
(148) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 9 more fields]
(149) LogicalRelation
Arguments: parquet, [product#827788, plant#827789, orderDateTime#827790, constraintprofile#827791], false
(150) Repartition
Arguments: 25, true
(151) Join
Arguments: LeftOuter, (((product#827701 <=> product#827788) AND (plant#827696 <=> plant#827789)) AND (orderDateTime#827702 <=> orderDateTime#827790))
(152) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 10 more fields]
(153) LogicalRelation
Arguments: parquet, [constraintProfile#827792, descriptions#827793, minServiceLevel#827794, minServiceLevelMinStock#827795, maxServiceLevelEndListing#827796, maxRangeCoverage#827797, minOrderQuantity#827798, profileType#827799, eventtype#827800], false
(154) Repartition
Arguments: 25, true
(155) Join
Arguments: LeftOuter, (constraintProfile#827791 <=> constraintProfile#827792)
(156) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 20 more fields]
(157) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 10 more fields]
(158) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 10 more fields]
(159) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 15 more fields]
(160) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 15 more fields]
(161) Project
Arguments: [supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalId#827710L, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, orderProposalItemId#827718, ... 14 more fields]
(162) LocalRelation
Arguments: <empty>, [orderProposalId#827809, orderProposalItemId#827810, constraintOverwrites#827811]
(163) Project
Arguments: [orderProposalId#827809, orderProposalItemId#827810, filter(constraintOverwrites#827811, lambdafunction(((isnotnull(lambda x_2152#826348.label) AND isnotnull(lambda x_2152#826348.isActive)) AND (((lambda x_2152#826348.isActive = false) OR isnotnull(lambda x_2152#826348.value)) OR (lambda x_2152#826348.label <=> minOrderQuantity))), lambda x_2152#826348, false)) AS constraintOverwrites#827812]
(164) Project
Arguments: [orderProposalId#827809, orderProposalItemId#827810, transform(constraintOverwrites#827812, lambdafunction(struct(label, lambda x_2153#826353.label, value, CASE WHEN ((lambda x_2153#826353.label = minOrderQuantity) OR (lambda x_2153#826353.label = lockedOrderQuantity)) THEN round(lambda x_2153#826353.value, 0) ELSE lambda x_2153#826353.value END, isActive, lambda x_2153#826353.isActive), lambda x_2153#826353, false)) AS constraintOverwrites#827813]
(165) Join
Arguments: LeftOuter, ((orderProposalId#827710L = cast(orderProposalId#827809 as bigint)) AND (orderProposalItemId#827718 = orderProposalItemId#827810))
(166) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 15 more fields]
(167) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 15 more fields]
(168) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 15 more fields]
(169) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 15 more fields]
(170) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 14 more fields]
(171) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 15 more fields]
(172) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 16 more fields]
(173) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 17 more fields]
(174) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 18 more fields]
(175) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 19 more fields]
(176) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 20 more fields]
(177) LogicalRelation
Arguments: parquet, [systemId#827823, internalUUID#827824, code#827825, name#827826, commercialCode#827827, isoCode#827828], false
(178) Repartition
Arguments: 25, true
(179) SubqueryAlias
Arguments: unitOfMeasure
(180) Join
Arguments: LeftOuter, (filter(filter(productInformation#827767.unitOfMeasures, lambdafunction((lambda x_2164#826420.measurementUnit.internalRefUUID = productInformation#827767.baseUnitOfMeasure.internalRefUUID), lambda x_2164#826420, false))[0].productDimensions, lambdafunction((lambda x_2165#826422.dimensionName.code = VOLUME), lambda x_2165#826422, false))[0].measurementUnit.internalRefUUID <=> internalUUID#827824)
(181) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 21 more fields]
(182) LogicalRelation
Arguments: parquet, [systemId#827830, internalUUID#827831, code#827832, name#827833, commercialCode#827834, isoCode#827835], false
(183) Repartition
Arguments: 25, true
(184) SubqueryAlias
Arguments: unitOfMeasure
(185) Join
Arguments: LeftOuter, (filter(filter(productInformation#827767.unitOfMeasures, lambdafunction((lambda x_2166#826448.measurementUnit.internalRefUUID = productInformation#827767.baseUnitOfMeasure.internalRefUUID), lambda x_2166#826448, false))[0].productDimensions, lambdafunction((lambda x_2167#826450.dimensionName.code = GROSS_WT), lambda x_2167#826450, false))[0].measurementUnit.internalRefUUID <=> internalUUID#827831)
(186) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 22 more fields]
(187) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 20 more fields]
(188) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 21 more fields]
(189) LogicalRelation
Arguments: parquet, [supplier#827839, subrange#827840, plant#827841, deliverydatetime#827842, ordergroupingprofile#827843, supplierGroup#827844, locationGroup#827845, optimizationGroups#827846], false
(190) Repartition
Arguments: 25, true
(191) Project
Arguments: [supplier#827839, subrange#827840, plant#827841, deliverydatetime#827842, ordergroupingprofile#827843, supplierGroup#827844, locationGroup#827845, optimizationGroups#827846, cast(null as string) AS supplyingPlant#827847]
(192) Project
Arguments: [supplier#827839, subrange#827840, plant#827841, deliverydatetime#827842, ordergroupingprofile#827843, supplierGroup#827844, locationGroup#827845, optimizationGroups#827846, supplyingPlant#827847, cast(null as string) AS productGroup#827848]
(193) Join
Arguments: LeftOuter, (((((((supplierGroup#827694 <=> supplierGroup#827844) AND (supplier#827695 <=> supplier#827839)) AND (subrange#827698 <=> subrange#827840)) AND (plant#827696 <=> plant#827841)) AND (deliveryDateTime#827697 <=> deliveryDateTime#827842)) AND (supplyingPlant#827699 <=> supplyingPlant#827847)) AND (productGroup#827700 <=> productGroup#827848))
(194) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 22 more fields]
(195) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 22 more fields]
(196) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 21 more fields]
(197) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 20 more fields]
(198) Project
Arguments: [orderProposalId#827710L, orderProposalItemId#827718, supplierGroup#827694, supplier#827695, plant#827696, deliveryDateTime#827697, subrange#827698, supplyingPlant#827699, productGroup#827700, product#827701, orderDateTime#827702, availabilityDateTime#827703, nextAvailabilityDateTime#827704, mrpController#827705, sourceOfSupplyUuid#827706, purchasingOrg#827707, purchasingGroup#827708, isFallbackOrderOnly#827709, orderProposalHorizonGroupingId#827711L, splitIndicator#827712L, previousOrderProposal#827713L, clusterId#827714L, sequenceId#827715, worklistShardItemId#827716L, orderProposalItemGroupId#827717, ... 19 more fields]
(199) Generate
Arguments: explode(optimizationGroups#827849), true, [optGroupId#827693]
(200) Project
Arguments: [orderProposalId#827710L, optGroupId#827693]
(201) Deduplicate
Arguments: [orderProposalId#827710L, optGroupId#827693]
(202) LogicalRelation
Arguments: parquet, [optGroupId#827687, assignmentDetails#827688, minOrderProfile#827689, multiplerestrictionprofile#827690], false
(203) Repartition
Arguments: 25, true
(204) Filter
Arguments: (isnotnull(optGroupId#827687) AND isnotnull(minOrderProfile#827689))
(205) Join
Arguments: Inner, (optGroupId#827693 = optGroupId#827687)
(206) Project
Arguments: [optGroupId#827693, orderProposalId#827710L, assignmentDetails#827688, minOrderProfile#827689, multiplerestrictionprofile#827690]
(207) Join
Arguments: LeftOuter, (orderProposalId#826161L = orderProposalId#827710L)
(208) Project
Arguments: [orderProposalId#826161L, sequenceId#826166, optGroupId#827693, assignmentDetails#827688, minOrderProfile#827689, multiplerestrictionprofile#827690]
(209) Project
Arguments: [orderProposalId#826161L, sequenceId#826166]
(210) Deduplicate
Arguments: [orderProposalId#826161L, sequenceId#826166]
(211) LogicalRelation
Arguments: parquet, [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906], false
(212) RepartitionByExpression
Arguments: [product#827889, plant#827884], 25
(213) LogicalRelation
Arguments: parquet, [systemId#827907, internalUUID#827908, supplier#827909, receiver#827910, product#827911, receivingPlant#827912, sourceOfSupplyType#827913, purchasingGroup#827914, purchasingOrganization#827915, productGroup#827916, validFrom#827917, validTo#827918, priority#827919, isPurchasingBlocked#827920, isConsignment#827921, isDeleted#827922, supplierSubrange#827923, plannedDeliveryTimeDays#827924, orderQuantityUnit#827925, purchasingPriceAspect#827926, orderCurrency#827927, minimumOrderQuantity#827928, logisticalRoundingProfile#827929, supplyingPlant#827930], false
(214) Repartition
Arguments: 25, true
(215) SubqueryAlias
Arguments: sos
(216) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#827894 <=> internalUUID#827908)
(217) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 25 more fields]
(218) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 1 more fields]
(219) LogicalRelation
Arguments: parquet, [systemId#827932, internalUUID#827933, plant#827934, product#827935, blockedForReplenishmentStartingFrom#827936, productionAspect#827937, salesPlant#827938, listing#827939], false
(220) Repartition
Arguments: 25, true
(221) Filter
Arguments: plant#827934.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(222) SubqueryAlias
Arguments: pp
(223) Join
Arguments: LeftOuter, ((product#827889 <=> product#827935.internalRefUUID) AND (plant#827884 <=> plant#827934.internalRefUUID))
(224) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 10 more fields]
(225) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 11 more fields]
(226) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 12 more fields]
(227) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 4 more fields]
(228) LogicalRelation
Arguments: parquet, [systemId#827943, internalUUID#827944, id#827945, displayId#827946, name#827947, baseUnitOfMeasure#827948, unitOfMeasures#827949, unitOfMeasureConversions#827950, productionAspect#827951, salesAspect#827952, procurementAspect#827953, productGroup#827954], false
(229) Repartition
Arguments: 25, true
(230) SubqueryAlias
Arguments: tmp
(231) Join
Arguments: LeftOuter, (product#827889 = internalUUID#827944)
(232) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 17 more fields]
(233) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 5 more fields]
(234) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 6 more fields]
(235) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 7 more fields]
(236) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 8 more fields]
(237) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 8 more fields]
(238) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 9 more fields]
(239) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 10 more fields]
(240) SubqueryAlias
Arguments: worklist
(241) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#827962, plant#827963, logisticalRoundingRule#827964]
(242) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(243) Join
Arguments: LeftOuter, ((preferredRoundingProfile#827961 <=> logisticalRoundingProfile#827962) AND (plant#827884 <=> plant#827963.internalRefUUID))
(244) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#827965, plant#827966, logisticalRoundingRule#827967]
(245) Filter
Arguments: isnull(plant#827966.internalRefUUID)
(246) SubqueryAlias
Arguments: allPlantRoundingProfiles
(247) Join
Arguments: LeftOuter, (preferredRoundingProfile#827961 <=> logisticalRoundingProfile#827965)
(248) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 17 more fields]
(249) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 11 more fields]
(250) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#827970, unitOfMeasure#827971]
(251) Aggregate
Arguments: [logisticalRoundingRule#827970], [logisticalRoundingRule#827970, collect_list(unitOfMeasure#827971.internalRefUUID, 0, 0) AS preferredUOMs#827972]
(252) Join
Arguments: LeftOuter, (logisticalRoundingRule#827969.logisticalRoundingRule = logisticalRoundingRule#827970)
(253) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 11 more fields]
(254) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 11 more fields]
(255) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 11 more fields]
(256) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 8 more fields]
(257) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 9 more fields]
(258) LogicalRelation
Arguments: parquet, [product#827976, plant#827977, orderDateTime#827978, constraintprofile#827979], false
(259) Repartition
Arguments: 25, true
(260) Join
Arguments: LeftOuter, (((product#827889 <=> product#827976) AND (plant#827884 <=> plant#827977)) AND (orderDateTime#827890 <=> orderDateTime#827978))
(261) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 10 more fields]
(262) LogicalRelation
Arguments: parquet, [constraintProfile#827980, descriptions#827981, minServiceLevel#827982, minServiceLevelMinStock#827983, maxServiceLevelEndListing#827984, maxRangeCoverage#827985, minOrderQuantity#827986, profileType#827987, eventtype#827988], false
(263) Repartition
Arguments: 25, true
(264) Join
Arguments: LeftOuter, (constraintProfile#827979 <=> constraintProfile#827980)
(265) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 20 more fields]
(266) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 10 more fields]
(267) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 10 more fields]
(268) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 15 more fields]
(269) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 15 more fields]
(270) Project
Arguments: [supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalId#827898L, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, orderProposalItemId#827906, ... 14 more fields]
(271) LocalRelation
Arguments: <empty>, [orderProposalId#827997, orderProposalItemId#827998, constraintOverwrites#827999]
(272) Project
Arguments: [orderProposalId#827997, orderProposalItemId#827998, filter(constraintOverwrites#827999, lambdafunction(((isnotnull(lambda x_2152#826348.label) AND isnotnull(lambda x_2152#826348.isActive)) AND (((lambda x_2152#826348.isActive = false) OR isnotnull(lambda x_2152#826348.value)) OR (lambda x_2152#826348.label <=> minOrderQuantity))), lambda x_2152#826348, false)) AS constraintOverwrites#828000]
(273) Project
Arguments: [orderProposalId#827997, orderProposalItemId#827998, transform(constraintOverwrites#828000, lambdafunction(struct(label, lambda x_2153#826353.label, value, CASE WHEN ((lambda x_2153#826353.label = minOrderQuantity) OR (lambda x_2153#826353.label = lockedOrderQuantity)) THEN round(lambda x_2153#826353.value, 0) ELSE lambda x_2153#826353.value END, isActive, lambda x_2153#826353.isActive), lambda x_2153#826353, false)) AS constraintOverwrites#828001]
(274) Join
Arguments: LeftOuter, ((orderProposalId#827898L = cast(orderProposalId#827997 as bigint)) AND (orderProposalItemId#827906 = orderProposalItemId#827998))
(275) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 15 more fields]
(276) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 15 more fields]
(277) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 15 more fields]
(278) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 15 more fields]
(279) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 14 more fields]
(280) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 15 more fields]
(281) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 16 more fields]
(282) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 17 more fields]
(283) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 18 more fields]
(284) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 19 more fields]
(285) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 20 more fields]
(286) LogicalRelation
Arguments: parquet, [systemId#828011, internalUUID#828012, code#828013, name#828014, commercialCode#828015, isoCode#828016], false
(287) Repartition
Arguments: 25, true
(288) SubqueryAlias
Arguments: unitOfMeasure
(289) Join
Arguments: LeftOuter, (filter(filter(productInformation#827955.unitOfMeasures, lambdafunction((lambda x_2164#826420.measurementUnit.internalRefUUID = productInformation#827955.baseUnitOfMeasure.internalRefUUID), lambda x_2164#826420, false))[0].productDimensions, lambdafunction((lambda x_2165#826422.dimensionName.code = VOLUME), lambda x_2165#826422, false))[0].measurementUnit.internalRefUUID <=> internalUUID#828012)
(290) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 21 more fields]
(291) LogicalRelation
Arguments: parquet, [systemId#828018, internalUUID#828019, code#828020, name#828021, commercialCode#828022, isoCode#828023], false
(292) Repartition
Arguments: 25, true
(293) SubqueryAlias
Arguments: unitOfMeasure
(294) Join
Arguments: LeftOuter, (filter(filter(productInformation#827955.unitOfMeasures, lambdafunction((lambda x_2166#826448.measurementUnit.internalRefUUID = productInformation#827955.baseUnitOfMeasure.internalRefUUID), lambda x_2166#826448, false))[0].productDimensions, lambdafunction((lambda x_2167#826450.dimensionName.code = GROSS_WT), lambda x_2167#826450, false))[0].measurementUnit.internalRefUUID <=> internalUUID#828019)
(295) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 22 more fields]
(296) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 20 more fields]
(297) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 21 more fields]
(298) LogicalRelation
Arguments: parquet, [supplier#828027, subrange#828028, plant#828029, deliverydatetime#828030, ordergroupingprofile#828031, supplierGroup#828032, locationGroup#828033, optimizationGroups#828034], false
(299) Repartition
Arguments: 25, true
(300) Project
Arguments: [supplier#828027, subrange#828028, plant#828029, deliverydatetime#828030, ordergroupingprofile#828031, supplierGroup#828032, locationGroup#828033, optimizationGroups#828034, cast(null as string) AS supplyingPlant#828035]
(301) Project
Arguments: [supplier#828027, subrange#828028, plant#828029, deliverydatetime#828030, ordergroupingprofile#828031, supplierGroup#828032, locationGroup#828033, optimizationGroups#828034, supplyingPlant#828035, cast(null as string) AS productGroup#828036]
(302) Join
Arguments: LeftOuter, (((((((supplierGroup#827882 <=> supplierGroup#828032) AND (supplier#827883 <=> supplier#828027)) AND (subrange#827886 <=> subrange#828028)) AND (plant#827884 <=> plant#828029)) AND (deliveryDateTime#827885 <=> deliveryDateTime#828030)) AND (supplyingPlant#827887 <=> supplyingPlant#828035)) AND (productGroup#827888 <=> productGroup#828036))
(303) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 22 more fields]
(304) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 22 more fields]
(305) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 21 more fields]
(306) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 20 more fields]
(307) Project
Arguments: [orderProposalId#827898L, orderProposalItemId#827906, supplierGroup#827882, supplier#827883, plant#827884, deliveryDateTime#827885, subrange#827886, supplyingPlant#827887, productGroup#827888, product#827889, orderDateTime#827890, availabilityDateTime#827891, nextAvailabilityDateTime#827892, mrpController#827893, sourceOfSupplyUuid#827894, purchasingOrg#827895, purchasingGroup#827896, isFallbackOrderOnly#827897, orderProposalHorizonGroupingId#827899L, splitIndicator#827900L, previousOrderProposal#827901L, clusterId#827902L, sequenceId#827903, worklistShardItemId#827904L, orderProposalItemGroupId#827905, ... 19 more fields]
(308) Project
Arguments: [orderProposalId#827898L, sequenceId#827903]
(309) Deduplicate
Arguments: [orderProposalId#827898L, sequenceId#827903]
(310) LogicalRelation
Arguments: parquet, [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062], false
(311) RepartitionByExpression
Arguments: [product#828045, plant#828040], 25
(312) LogicalRelation
Arguments: parquet, [systemId#828063, internalUUID#828064, supplier#828065, receiver#828066, product#828067, receivingPlant#828068, sourceOfSupplyType#828069, purchasingGroup#828070, purchasingOrganization#828071, productGroup#828072, validFrom#828073, validTo#828074, priority#828075, isPurchasingBlocked#828076, isConsignment#828077, isDeleted#828078, supplierSubrange#828079, plannedDeliveryTimeDays#828080, orderQuantityUnit#828081, purchasingPriceAspect#828082, orderCurrency#828083, minimumOrderQuantity#828084, logisticalRoundingProfile#828085, supplyingPlant#828086], false
(313) Repartition
Arguments: 25, true
(314) SubqueryAlias
Arguments: sos
(315) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#828050 <=> internalUUID#828064)
(316) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 25 more fields]
(317) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 1 more fields]
(318) LogicalRelation
Arguments: parquet, [systemId#828088, internalUUID#828089, plant#828090, product#828091, blockedForReplenishmentStartingFrom#828092, productionAspect#828093, salesPlant#828094, listing#828095], false
(319) Repartition
Arguments: 25, true
(320) Filter
Arguments: plant#828090.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(321) SubqueryAlias
Arguments: pp
(322) Join
Arguments: LeftOuter, ((product#828045 <=> product#828091.internalRefUUID) AND (plant#828040 <=> plant#828090.internalRefUUID))
(323) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 10 more fields]
(324) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 11 more fields]
(325) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 12 more fields]
(326) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 4 more fields]
(327) LogicalRelation
Arguments: parquet, [systemId#828099, internalUUID#828100, id#828101, displayId#828102, name#828103, baseUnitOfMeasure#828104, unitOfMeasures#828105, unitOfMeasureConversions#828106, productionAspect#828107, salesAspect#828108, procurementAspect#828109, productGroup#828110], false
(328) Repartition
Arguments: 25, true
(329) SubqueryAlias
Arguments: tmp
(330) Join
Arguments: LeftOuter, (product#828045 = internalUUID#828100)
(331) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 17 more fields]
(332) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 5 more fields]
(333) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 6 more fields]
(334) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 7 more fields]
(335) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 8 more fields]
(336) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 8 more fields]
(337) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 9 more fields]
(338) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 10 more fields]
(339) SubqueryAlias
Arguments: worklist
(340) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#828118, plant#828119, logisticalRoundingRule#828120]
(341) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(342) Join
Arguments: LeftOuter, ((preferredRoundingProfile#828117 <=> logisticalRoundingProfile#828118) AND (plant#828040 <=> plant#828119.internalRefUUID))
(343) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#828121, plant#828122, logisticalRoundingRule#828123]
(344) Filter
Arguments: isnull(plant#828122.internalRefUUID)
(345) SubqueryAlias
Arguments: allPlantRoundingProfiles
(346) Join
Arguments: LeftOuter, (preferredRoundingProfile#828117 <=> logisticalRoundingProfile#828121)
(347) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 17 more fields]
(348) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 11 more fields]
(349) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#828126, unitOfMeasure#828127]
(350) Aggregate
Arguments: [logisticalRoundingRule#828126], [logisticalRoundingRule#828126, collect_list(unitOfMeasure#828127.internalRefUUID, 0, 0) AS preferredUOMs#828128]
(351) Join
Arguments: LeftOuter, (logisticalRoundingRule#828125.logisticalRoundingRule = logisticalRoundingRule#828126)
(352) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 11 more fields]
(353) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 11 more fields]
(354) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 11 more fields]
(355) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 8 more fields]
(356) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 9 more fields]
(357) LogicalRelation
Arguments: parquet, [product#828132, plant#828133, orderDateTime#828134, constraintprofile#828135], false
(358) Repartition
Arguments: 25, true
(359) Join
Arguments: LeftOuter, (((product#828045 <=> product#828132) AND (plant#828040 <=> plant#828133)) AND (orderDateTime#828046 <=> orderDateTime#828134))
(360) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 10 more fields]
(361) LogicalRelation
Arguments: parquet, [constraintProfile#828136, descriptions#828137, minServiceLevel#828138, minServiceLevelMinStock#828139, maxServiceLevelEndListing#828140, maxRangeCoverage#828141, minOrderQuantity#828142, profileType#828143, eventtype#828144], false
(362) Repartition
Arguments: 25, true
(363) Join
Arguments: LeftOuter, (constraintProfile#828135 <=> constraintProfile#828136)
(364) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 20 more fields]
(365) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 10 more fields]
(366) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 10 more fields]
(367) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 15 more fields]
(368) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 15 more fields]
(369) Project
Arguments: [supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalId#828054L, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, orderProposalItemId#828062, ... 14 more fields]
(370) LocalRelation
Arguments: <empty>, [orderProposalId#828153, orderProposalItemId#828154, constraintOverwrites#828155]
(371) Project
Arguments: [orderProposalId#828153, orderProposalItemId#828154, filter(constraintOverwrites#828155, lambdafunction(((isnotnull(lambda x_2152#826348.label) AND isnotnull(lambda x_2152#826348.isActive)) AND (((lambda x_2152#826348.isActive = false) OR isnotnull(lambda x_2152#826348.value)) OR (lambda x_2152#826348.label <=> minOrderQuantity))), lambda x_2152#826348, false)) AS constraintOverwrites#828156]
(372) Project
Arguments: [orderProposalId#828153, orderProposalItemId#828154, transform(constraintOverwrites#828156, lambdafunction(struct(label, lambda x_2153#826353.label, value, CASE WHEN ((lambda x_2153#826353.label = minOrderQuantity) OR (lambda x_2153#826353.label = lockedOrderQuantity)) THEN round(lambda x_2153#826353.value, 0) ELSE lambda x_2153#826353.value END, isActive, lambda x_2153#826353.isActive), lambda x_2153#826353, false)) AS constraintOverwrites#828157]
(373) Join
Arguments: LeftOuter, ((orderProposalId#828054L = cast(orderProposalId#828153 as bigint)) AND (orderProposalItemId#828062 = orderProposalItemId#828154))
(374) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 15 more fields]
(375) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 15 more fields]
(376) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 15 more fields]
(377) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 15 more fields]
(378) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 14 more fields]
(379) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 15 more fields]
(380) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 16 more fields]
(381) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 17 more fields]
(382) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 18 more fields]
(383) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 19 more fields]
(384) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 20 more fields]
(385) LogicalRelation
Arguments: parquet, [systemId#828167, internalUUID#828168, code#828169, name#828170, commercialCode#828171, isoCode#828172], false
(386) Repartition
Arguments: 25, true
(387) SubqueryAlias
Arguments: unitOfMeasure
(388) Join
Arguments: LeftOuter, (filter(filter(productInformation#828111.unitOfMeasures, lambdafunction((lambda x_2164#826420.measurementUnit.internalRefUUID = productInformation#828111.baseUnitOfMeasure.internalRefUUID), lambda x_2164#826420, false))[0].productDimensions, lambdafunction((lambda x_2165#826422.dimensionName.code = VOLUME), lambda x_2165#826422, false))[0].measurementUnit.internalRefUUID <=> internalUUID#828168)
(389) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 21 more fields]
(390) LogicalRelation
Arguments: parquet, [systemId#828174, internalUUID#828175, code#828176, name#828177, commercialCode#828178, isoCode#828179], false
(391) Repartition
Arguments: 25, true
(392) SubqueryAlias
Arguments: unitOfMeasure
(393) Join
Arguments: LeftOuter, (filter(filter(productInformation#828111.unitOfMeasures, lambdafunction((lambda x_2166#826448.measurementUnit.internalRefUUID = productInformation#828111.baseUnitOfMeasure.internalRefUUID), lambda x_2166#826448, false))[0].productDimensions, lambdafunction((lambda x_2167#826450.dimensionName.code = GROSS_WT), lambda x_2167#826450, false))[0].measurementUnit.internalRefUUID <=> internalUUID#828175)
(394) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 22 more fields]
(395) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 20 more fields]
(396) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 21 more fields]
(397) LogicalRelation
Arguments: parquet, [supplier#828183, subrange#828184, plant#828185, deliverydatetime#828186, ordergroupingprofile#828187, supplierGroup#828188, locationGroup#828189, optimizationGroups#828190], false
(398) Repartition
Arguments: 25, true
(399) Project
Arguments: [supplier#828183, subrange#828184, plant#828185, deliverydatetime#828186, ordergroupingprofile#828187, supplierGroup#828188, locationGroup#828189, optimizationGroups#828190, cast(null as string) AS supplyingPlant#828191]
(400) Project
Arguments: [supplier#828183, subrange#828184, plant#828185, deliverydatetime#828186, ordergroupingprofile#828187, supplierGroup#828188, locationGroup#828189, optimizationGroups#828190, supplyingPlant#828191, cast(null as string) AS productGroup#828192]
(401) Join
Arguments: LeftOuter, (((((((supplierGroup#828038 <=> supplierGroup#828188) AND (supplier#828039 <=> supplier#828183)) AND (subrange#828042 <=> subrange#828184)) AND (plant#828040 <=> plant#828185)) AND (deliveryDateTime#828041 <=> deliveryDateTime#828186)) AND (supplyingPlant#828043 <=> supplyingPlant#828191)) AND (productGroup#828044 <=> productGroup#828192))
(402) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 22 more fields]
(403) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 22 more fields]
(404) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 21 more fields]
(405) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 20 more fields]
(406) Project
Arguments: [orderProposalId#828054L, orderProposalItemId#828062, supplierGroup#828038, supplier#828039, plant#828040, deliveryDateTime#828041, subrange#828042, supplyingPlant#828043, productGroup#828044, product#828045, orderDateTime#828046, availabilityDateTime#828047, nextAvailabilityDateTime#828048, mrpController#828049, sourceOfSupplyUuid#828050, purchasingOrg#828051, purchasingGroup#828052, isFallbackOrderOnly#828053, orderProposalHorizonGroupingId#828055L, splitIndicator#828056L, previousOrderProposal#828057L, clusterId#828058L, sequenceId#828059, worklistShardItemId#828060L, orderProposalItemGroupId#828061, ... 19 more fields]
(407) Generate
Arguments: explode(optimizationGroups#828193), true, [optGroupId#828194]
(408) Project
Arguments: [orderProposalId#828054L, optGroupId#828194]
(409) Deduplicate
Arguments: [orderProposalId#828054L, optGroupId#828194]
(410) LogicalRelation
Arguments: parquet, [optGroupId#828195, assignmentDetails#828196, minOrderProfile#828197, multiplerestrictionprofile#828198], false
(411) Repartition
Arguments: 25, true
(412) Filter
Arguments: (isnotnull(optGroupId#828195) AND isnotnull(minOrderProfile#828197))
(413) Join
Arguments: Inner, (optGroupId#828194 = optGroupId#828195)
(414) Project
Arguments: [optGroupId#828194, orderProposalId#828054L, assignmentDetails#828196, minOrderProfile#828197, multiplerestrictionprofile#828198]
(415) Join
Arguments: LeftOuter, (orderProposalId#827898L = orderProposalId#828054L)
(416) Project
Arguments: [orderProposalId#827898L, sequenceId#827903, optGroupId#828194, assignmentDetails#828196, minOrderProfile#828197, multiplerestrictionprofile#828198]
(417) LogicalRelation
Arguments: parquet, [supplierminimumprofilename#827855, descriptions#827856, dimensionType#827857, dimensionValue#827858, dimensionUnit#827859, acceptanceThreshold#827860, profileType#827861, eventtype#827862], false
(418) Repartition
Arguments: 25, true
(419) Join
Arguments: Inner, (minOrderProfile#828197 <=> supplierminimumprofilename#827855)
(420) LogicalRelation
Arguments: parquet, [systemId#827863, internalUUID#827864, code#827865, name#827866, commercialCode#827867, isoCode#827868], false
(421) Repartition
Arguments: 25, true
(422) Join
Arguments: LeftOuter, (dimensionUnit#827859.dimensionCodeUuid <=> internalUUID#827864)
(423) Project
Arguments: [orderProposalId#827898L, sequenceId#827903, optGroupId#828194, assignmentDetails#828196, minOrderProfile#828197, multiplerestrictionprofile#828198, supplierminimumprofilename#827855, descriptions#827856, dimensionType#827857, dimensionValue#827858, dimensionUnit#827859, acceptanceThreshold#827860, profileType#827861, eventtype#827862, systemId#827863, internalUUID#827864, code#827865, name#827866, commercialCode#827867, isoCode#827868, struct(minOrderValue, dimensionValue#827858, dimensionType, dimensionType#827857, unit, dimensionUnit#827859.dimensionCode, unitUuid, dimensionUnit#827859.dimensionCodeUuid, negligibleQuantitiesThreshold, 0.0, acceptanceThreshold, (acceptanceThreshold#827860 / cast(100 as double)), isoCode, isoCode#827868.code) AS minOrderGoal#827878]
(424) Project
Arguments: [orderProposalId#827898L, sequenceId#827903, optGroupId#828194, assignmentDetails#828196, minOrderProfile#828197, multiplerestrictionprofile#828198, systemId#827863, internalUUID#827864, code#827865, name#827866, commercialCode#827867, isoCode#827868, minOrderGoal#827878]
(425) Project
Arguments: [orderProposalId#827898L, sequenceId#827903, optGroupId#828194, assignmentDetails#828196, minOrderProfile#828197, multiplerestrictionprofile#828198, minOrderGoal#827878]
(426) Project
Arguments: [orderProposalId#827898L, optGroupId#828194, assignmentDetails#828196, minOrderProfile#828197, multiplerestrictionprofile#828198, minOrderGoal#827878]
(427) Join
Arguments: LeftOuter, (orderProposalId#826161L = orderProposalId#827898L)
(428) Project
Arguments: [orderProposalId#826161L, sequenceId#826166, optGroupId#828194, assignmentDetails#828196, minOrderProfile#828197, multiplerestrictionprofile#828198, minOrderGoal#827878]
(429) Aggregate
Arguments: [orderProposalId#826161L, sequenceId#826166], [orderProposalId#826161L, sequenceId#826166, collect_list(struct(optGroupId, optGroupId#828194, assignmentDetails, assignmentDetails#828196, minOrderProfile, minOrderProfile#828197, multiplerestrictionprofile, multiplerestrictionprofile#828198, minOrderGoal, minOrderGoal#827878), 0, 0) AS optimizationGroups#828210]
(430) Project
Arguments: [orderProposalId#826161L, sequenceId#826166, filter(optimizationGroups#828210, lambdafunction(isnotnull(lambda x_2169#828220.optGroupId), lambda x_2169#828220, false)) AS optimizationGroups#828219]
(431) Project
Arguments: [orderProposalId#826161L, sequenceId#826166, optimizationGroups#828219, 0_1_10000002109 AS shardId#832677]