== Physical Plan ==
Execute SaveIntoDataSourceCommand (1)
+- SaveIntoDataSourceCommand (2)
+- Project (459)
+- Project (458)
+- Join (457)
:- Project (449)
: +- Project (448)
: +- Project (447)
: +- Join (446)
: :- Project (4)
: : +- LocalRelation (3)
: +- Aggregate (445)
: +- Project (444)
: +- Project (443)
: +- Project (442)
: +- Project (441)
: +- Project (440)
: +- Join (439)
: :- Project (436)
: : +- Filter (435)
: : +- Project (434)
: : +- Generate (433)
: : +- Project (432)
: : +- Aggregate (431)
: : +- Project (430)
: : +- Join (429)
: : :- Deduplicate (212)
: : : +- Project (211)
: : : +- Project (210)
: : : +- Join (209)
: : : :- Deduplicate (103)
: : : : +- Project (102)
: : : : +- Project (101)
: : : : +- Project (100)
: : : : +- Project (99)
: : : : +- Project (98)
: : : : +- Project (97)
: : : : +- Join (96)
: : : : :- Project (91)
: : : : : +- Project (90)
: : : : : +- Project (89)
: : : : : +- Join (88)
: : : : : :- Project (84)
: : : : : : +- Join (83)
: : : : : : :- Project (79)
: : : : : : : +- Project (78)
: : : : : : : +- Project (77)
: : : : : : : +- Project (76)
: : : : : : : +- Project (75)
: : : : : : : +- Project (74)
: : : : : : : +- Project (73)
: : : : : : : +- Project (72)
: : : : : : : +- Project (71)
: : : : : : : +- Project (70)
: : : : : : : +- Project (69)
: : : : : : : +- Join (68)
: : : : : : : :- Project (64)
: : : : : : : : +- Project (63)
: : : : : : : : +- Project (62)
: : : : : : : : +- Project (61)
: : : : : : : : +- Project (60)
: : : : : : : : +- Project (59)
: : : : : : : : +- Join (58)
: : : : : : : : :- Project (55)
: : : : : : : : : +- Join (54)
: : : : : : : : : :- Project (51)
: : : : : : : : : : +- Project (50)
: : : : : : : : : : +- Project (49)
: : : : : : : : : : +- Project (48)
: : : : : : : : : : +- Project (47)
: : : : : : : : : : +- Join (46)
: : : : : : : : : : :- Project (43)
: : : : : : : : : : : +- Project (42)
: : : : : : : : : : : +- Join (41)
: : : : : : : : : : : :- Join (37)
: : : : : : : : : : : : :- SubqueryAlias (34)
: : : : : : : : : : : : : +- Project (33)
: : : : : : : : : : : : : +- Project (32)
: : : : : : : : : : : : : +- Project (31)
: : : : : : : : : : : : : +- Project (30)
: : : : : : : : : : : : : +- Project (29)
: : : : : : : : : : : : : +- Project (28)
: : : : : : : : : : : : : +- Project (27)
: : : : : : : : : : : : : +- Project (26)
: : : : : : : : : : : : : +- Join (25)
: : : : : : : : : : : : : :- Project (21)
: : : : : : : : : : : : : : +- Project (20)
: : : : : : : : : : : : : : +- Project (19)
: : : : : : : : : : : : : : +- Project (18)
: : : : : : : : : : : : : : +- Join (17)
: : : : : : : : : : : : : : :- Project (12)
: : : : : : : : : : : : : : : +- Project (11)
: : : : : : : : : : : : : : : +- Join (10)
: : : : : : : : : : : : : : : :- RepartitionByExpression (6)
: : : : : : : : : : : : : : : : +- LogicalRelation (5)
: : : : : : : : : : : : : : : +- SubqueryAlias (9)
: : : : : : : : : : : : : : : +- Repartition (8)
: : : : : : : : : : : : : : : +- LogicalRelation (7)
: : : : : : : : : : : : : : +- SubqueryAlias (16)
: : : : : : : : : : : : : : +- Filter (15)
: : : : : : : : : : : : : : +- Repartition (14)
: : : : : : : : : : : : : : +- LogicalRelation (13)
: : : : : : : : : : : : : +- SubqueryAlias (24)
: : : : : : : : : : : : : +- Repartition (23)
: : : : : : : : : : : : : +- LogicalRelation (22)
: : : : : : : : : : : : +- SubqueryAlias (36)
: : : : : : : : : : : : +- LocalRelation (35)
: : : : : : : : : : : +- SubqueryAlias (40)
: : : : : : : : : : : +- Filter (39)
: : : : : : : : : : : +- LocalRelation (38)
: : : : : : : : : : +- Aggregate (45)
: : : : : : : : : : +- LocalRelation (44)
: : : : : : : : : +- Repartition (53)
: : : : : : : : : +- LogicalRelation (52)
: : : : : : : : +- Repartition (57)
: : : : : : : : +- LogicalRelation (56)
: : : : : : : +- Project (67)
: : : : : : : +- Project (66)
: : : : : : : +- LocalRelation (65)
: : : : : : +- SubqueryAlias (82)
: : : : : : +- Repartition (81)
: : : : : : +- LogicalRelation (80)
: : : : : +- SubqueryAlias (87)
: : : : : +- Repartition (86)
: : : : : +- LogicalRelation (85)
: : : : +- Project (95)
: : : : +- Project (94)
: : : : +- Repartition (93)
: : : : +- LogicalRelation (92)
: : : +- Project (208)
: : : +- Join (207)
: : : :- Deduplicate (203)
: : : : +- Project (202)
: : : : +- Generate (201)
: : : : +- Project (200)
: : : : +- Project (199)
: : : : +- Project (198)
: : : : +- Project (197)
: : : : +- Project (196)
: : : : +- Join (195)
: : : : :- Project (190)
: : : : : +- Project (189)
: : : : : +- Project (188)
: : : : : +- Join (187)
: : : : : :- Project (183)
: : : : : : +- Join (182)
: : : : : : :- Project (178)
: : : : : : : +- Project (177)
: : : : : : : +- Project (176)
: : : : : : : +- Project (175)
: : : : : : : +- Project (174)
: : : : : : : +- Project (173)
: : : : : : : +- Project (172)
: : : : : : : +- Project (171)
: : : : : : : +- Project (170)
: : : : : : : +- Project (169)
: : : : : : : +- Project (168)
: : : : : : : +- Join (167)
: : : : : : : :- Project (163)
: : : : : : : : +- Project (162)
: : : : : : : : +- Project (161)
: : : : : : : : +- Project (160)
: : : : : : : : +- Project (159)
: : : : : : : : +- Project (158)
: : : : : : : : +- Join (157)
: : : : : : : : :- Project (154)
: : : : : : : : : +- Join (153)
: : : : : : : : : :- Project (150)
: : : : : : : : : : +- Project (149)
: : : : : : : : : : +- Project (148)
: : : : : : : : : : +- Project (147)
: : : : : : : : : : +- Project (146)
: : : : : : : : : : +- Join (145)
: : : : : : : : : : :- Project (142)
: : : : : : : : : : : +- Project (141)
: : : : : : : : : : : +- Join (140)
: : : : : : : : : : : :- Join (136)
: : : : : : : : : : : : :- SubqueryAlias (133)
: : : : : : : : : : : : : +- Project (132)
: : : : : : : : : : : : : +- Project (131)
: : : : : : : : : : : : : +- Project (130)
: : : : : : : : : : : : : +- Project (129)
: : : : : : : : : : : : : +- Project (128)
: : : : : : : : : : : : : +- Project (127)
: : : : : : : : : : : : : +- Project (126)
: : : : : : : : : : : : : +- Project (125)
: : : : : : : : : : : : : +- Join (124)
: : : : : : : : : : : : : :- Project (120)
: : : : : : : : : : : : : : +- Project (119)
: : : : : : : : : : : : : : +- Project (118)
: : : : : : : : : : : : : : +- Project (117)
: : : : : : : : : : : : : : +- Join (116)
: : : : : : : : : : : : : : :- Project (111)
: : : : : : : : : : : : : : : +- Project (110)
: : : : : : : : : : : : : : : +- Join (109)
: : : : : : : : : : : : : : : :- RepartitionByExpression (105)
: : : : : : : : : : : : : : : : +- LogicalRelation (104)
: : : : : : : : : : : : : : : +- SubqueryAlias (108)
: : : : : : : : : : : : : : : +- Repartition (107)
: : : : : : : : : : : : : : : +- LogicalRelation (106)
: : : : : : : : : : : : : : +- SubqueryAlias (115)
: : : : : : : : : : : : : : +- Filter (114)
: : : : : : : : : : : : : : +- Repartition (113)
: : : : : : : : : : : : : : +- LogicalRelation (112)
: : : : : : : : : : : : : +- SubqueryAlias (123)
: : : : : : : : : : : : : +- Repartition (122)
: : : : : : : : : : : : : +- LogicalRelation (121)
: : : : : : : : : : : : +- SubqueryAlias (135)
: : : : : : : : : : : : +- LocalRelation (134)
: : : : : : : : : : : +- SubqueryAlias (139)
: : : : : : : : : : : +- Filter (138)
: : : : : : : : : : : +- LocalRelation (137)
: : : : : : : : : : +- Aggregate (144)
: : : : : : : : : : +- LocalRelation (143)
: : : : : : : : : +- Repartition (152)
: : : : : : : : : +- LogicalRelation (151)
: : : : : : : : +- Repartition (156)
: : : : : : : : +- LogicalRelation (155)
: : : : : : : +- Project (166)
: : : : : : : +- Project (165)
: : : : : : : +- LocalRelation (164)
: : : : : : +- SubqueryAlias (181)
: : : : : : +- Repartition (180)
: : : : : : +- LogicalRelation (179)
: : : : : +- SubqueryAlias (186)
: : : : : +- Repartition (185)
: : : : : +- LogicalRelation (184)
: : : : +- Project (194)
: : : : +- Project (193)
: : : : +- Repartition (192)
: : : : +- LogicalRelation (191)
: : : +- Filter (206)
: : : +- Repartition (205)
: : : +- LogicalRelation (204)
: : +- Project (428)
: : +- Project (427)
: : +- Project (426)
: : +- Project (425)
: : +- Join (424)
: : :- Join (421)
: : : :- Project (418)
: : : : +- Join (417)
: : : : :- Deduplicate (311)
: : : : : +- Project (310)
: : : : : +- Project (309)
: : : : : +- Project (308)
: : : : : +- Project (307)
: : : : : +- Project (306)
: : : : : +- Project (305)
: : : : : +- Join (304)
: : : : : :- Project (299)
: : : : : : +- Project (298)
: : : : : : +- Project (297)
: : : : : : +- Join (296)
: : : : : : :- Project (292)
: : : : : : : +- Join (291)
: : : : : : : :- Project (287)
: : : : : : : : +- Project (286)
: : : : : : : : +- Project (285)
: : : : : : : : +- Project (284)
: : : : : : : : +- Project (283)
: : : : : : : : +- Project (282)
: : : : : : : : +- Project (281)
: : : : : : : : +- Project (280)
: : : : : : : : +- Project (279)
: : : : : : : : +- Project (278)
: : : : : : : : +- Project (277)
: : : : : : : : +- Join (276)
: : : : : : : : :- Project (272)
: : : : : : : : : +- Project (271)
: : : : : : : : : +- Project (270)
: : : : : : : : : +- Project (269)
: : : : : : : : : +- Project (268)
: : : : : : : : : +- Project (267)
: : : : : : : : : +- Join (266)
: : : : : : : : : :- Project (263)
: : : : : : : : : : +- Join (262)
: : : : : : : : : : :- Project (259)
: : : : : : : : : : : +- Project (258)
: : : : : : : : : : : +- Project (257)
: : : : : : : : : : : +- Project (256)
: : : : : : : : : : : +- Project (255)
: : : : : : : : : : : +- Join (254)
: : : : : : : : : : : :- Project (251)
: : : : : : : : : : : : +- Project (250)
: : : : : : : : : : : : +- Join (249)
: : : : : : : : : : : : :- Join (245)
: : : : : : : : : : : : : :- SubqueryAlias (242)
: : : : : : : : : : : : : : +- Project (241)
: : : : : : : : : : : : : : +- Project (240)
: : : : : : : : : : : : : : +- Project (239)
: : : : : : : : : : : : : : +- Project (238)
: : : : : : : : : : : : : : +- Project (237)
: : : : : : : : : : : : : : +- Project (236)
: : : : : : : : : : : : : : +- Project (235)
: : : : : : : : : : : : : : +- Project (234)
: : : : : : : : : : : : : : +- Join (233)
: : : : : : : : : : : : : : :- Project (229)
: : : : : : : : : : : : : : : +- Project (228)
: : : : : : : : : : : : : : : +- Project (227)
: : : : : : : : : : : : : : : +- Project (226)
: : : : : : : : : : : : : : : +- Join (225)
: : : : : : : : : : : : : : : :- Project (220)
: : : : : : : : : : : : : : : : +- Project (219)
: : : : : : : : : : : : : : : : +- Join (218)
: : : : : : : : : : : : : : : : :- RepartitionByExpression (214)
: : : : : : : : : : : : : : : : : +- LogicalRelation (213)
: : : : : : : : : : : : : : : : +- SubqueryAlias (217)
: : : : : : : : : : : : : : : : +- Repartition (216)
: : : : : : : : : : : : : : : : +- LogicalRelation (215)
: : : : : : : : : : : : : : : +- SubqueryAlias (224)
: : : : : : : : : : : : : : : +- Filter (223)
: : : : : : : : : : : : : : : +- Repartition (222)
: : : : : : : : : : : : : : : +- LogicalRelation (221)
: : : : : : : : : : : : : : +- SubqueryAlias (232)
: : : : : : : : : : : : : : +- Repartition (231)
: : : : : : : : : : : : : : +- LogicalRelation (230)
: : : : : : : : : : : : : +- SubqueryAlias (244)
: : : : : : : : : : : : : +- LocalRelation (243)
: : : : : : : : : : : : +- SubqueryAlias (248)
: : : : : : : : : : : : +- Filter (247)
: : : : : : : : : : : : +- LocalRelation (246)
: : : : : : : : : : : +- Aggregate (253)
: : : : : : : : : : : +- LocalRelation (252)
: : : : : : : : : : +- Repartition (261)
: : : : : : : : : : +- LogicalRelation (260)
: : : : : : : : : +- Repartition (265)
: : : : : : : : : +- LogicalRelation (264)
: : : : : : : : +- Project (275)
: : : : : : : : +- Project (274)
: : : : : : : : +- LocalRelation (273)
: : : : : : : +- SubqueryAlias (290)
: : : : : : : +- Repartition (289)
: : : : : : : +- LogicalRelation (288)
: : : : : : +- SubqueryAlias (295)
: : : : : : +- Repartition (294)
: : : : : : +- LogicalRelation (293)
: : : : : +- Project (303)
: : : : : +- Project (302)
: : : : : +- Repartition (301)
: : : : : +- LogicalRelation (300)
: : : : +- Project (416)
: : : : +- Join (415)
: : : : :- Deduplicate (411)
: : : : : +- Project (410)
: : : : : +- Generate (409)
: : : : : +- Project (408)
: : : : : +- Project (407)
: : : : : +- Project (406)
: : : : : +- Project (405)
: : : : : +- Project (404)
: : : : : +- Join (403)
: : : : : :- Project (398)
: : : : : : +- Project (397)
: : : : : : +- Project (396)
: : : : : : +- Join (395)
: : : : : : :- Project (391)
: : : : : : : +- Join (390)
: : : : : : : :- Project (386)
: : : : : : : : +- Project (385)
: : : : : : : : +- Project (384)
: : : : : : : : +- Project (383)
: : : : : : : : +- Project (382)
: : : : : : : : +- Project (381)
: : : : : : : : +- Project (380)
: : : : : : : : +- Project (379)
: : : : : : : : +- Project (378)
: : : : : : : : +- Project (377)
: : : : : : : : +- Project (376)
: : : : : : : : +- Join (375)
: : : : : : : : :- Project (371)
: : : : : : : : : +- Project (370)
: : : : : : : : : +- Project (369)
: : : : : : : : : +- Project (368)
: : : : : : : : : +- Project (367)
: : : : : : : : : +- Project (366)
: : : : : : : : : +- Join (365)
: : : : : : : : : :- Project (362)
: : : : : : : : : : +- Join (361)
: : : : : : : : : : :- Project (358)
: : : : : : : : : : : +- Project (357)
: : : : : : : : : : : +- Project (356)
: : : : : : : : : : : +- Project (355)
: : : : : : : : : : : +- Project (354)
: : : : : : : : : : : +- Join (353)
: : : : : : : : : : : :- Project (350)
: : : : : : : : : : : : +- Project (349)
: : : : : : : : : : : : +- Join (348)
: : : : : : : : : : : : :- Join (344)
: : : : : : : : : : : : : :- SubqueryAlias (341)
: : : : : : : : : : : : : : +- Project (340)
: : : : : : : : : : : : : : +- Project (339)
: : : : : : : : : : : : : : +- Project (338)
: : : : : : : : : : : : : : +- Project (337)
: : : : : : : : : : : : : : +- Project (336)
: : : : : : : : : : : : : : +- Project (335)
: : : : : : : : : : : : : : +- Project (334)
: : : : : : : : : : : : : : +- Project (333)
: : : : : : : : : : : : : : +- Join (332)
: : : : : : : : : : : : : : :- Project (328)
: : : : : : : : : : : : : : : +- Project (327)
: : : : : : : : : : : : : : : +- Project (326)
: : : : : : : : : : : : : : : +- Project (325)
: : : : : : : : : : : : : : : +- Join (324)
: : : : : : : : : : : : : : : :- Project (319)
: : : : : : : : : : : : : : : : +- Project (318)
: : : : : : : : : : : : : : : : +- Join (317)
: : : : : : : : : : : : : : : : :- RepartitionByExpression (313)
: : : : : : : : : : : : : : : : : +- LogicalRelation (312)
: : : : : : : : : : : : : : : : +- SubqueryAlias (316)
: : : : : : : : : : : : : : : : +- Repartition (315)
: : : : : : : : : : : : : : : : +- LogicalRelation (314)
: : : : : : : : : : : : : : : +- SubqueryAlias (323)
: : : : : : : : : : : : : : : +- Filter (322)
: : : : : : : : : : : : : : : +- Repartition (321)
: : : : : : : : : : : : : : : +- LogicalRelation (320)
: : : : : : : : : : : : : : +- SubqueryAlias (331)
: : : : : : : : : : : : : : +- Repartition (330)
: : : : : : : : : : : : : : +- LogicalRelation (329)
: : : : : : : : : : : : : +- SubqueryAlias (343)
: : : : : : : : : : : : : +- LocalRelation (342)
: : : : : : : : : : : : +- SubqueryAlias (347)
: : : : : : : : : : : : +- Filter (346)
: : : : : : : : : : : : +- LocalRelation (345)
: : : : : : : : : : : +- Aggregate (352)
: : : : : : : : : : : +- LocalRelation (351)
: : : : : : : : : : +- Repartition (360)
: : : : : : : : : : +- LogicalRelation (359)
: : : : : : : : : +- Repartition (364)
: : : : : : : : : +- LogicalRelation (363)
: : : : : : : : +- Project (374)
: : : : : : : : +- Project (373)
: : : : : : : : +- LocalRelation (372)
: : : : : : : +- SubqueryAlias (389)
: : : : : : : +- Repartition (388)
: : : : : : : +- LogicalRelation (387)
: : : : : : +- SubqueryAlias (394)
: : : : : : +- Repartition (393)
: : : : : : +- LogicalRelation (392)
: : : : : +- Project (402)
: : : : : +- Project (401)
: : : : : +- Repartition (400)
: : : : : +- LogicalRelation (399)
: : : : +- Filter (414)
: : : : +- Repartition (413)
: : : : +- LogicalRelation (412)
: : : +- Repartition (420)
: : : +- LogicalRelation (419)
: : +- Repartition (423)
: : +- LogicalRelation (422)
: +- Repartition (438)
: +- LogicalRelation (437)
+- Aggregate (456)
+- Project (455)
+- Filter (454)
+- Aggregate (453)
+- Filter (452)
+- Repartition (451)
+- LogicalRelation (450)
(1) Execute SaveIntoDataSourceCommand
Output: []
(2) SaveIntoDataSourceCommand
Arguments: org.apache.spark.sql.delta.sources.DeltaDataSource@4ed254b0, [__partition_columns=["shardId"], path=hdlfs://2e93940d-4be8-4f12-830d-f0b8d392c03a.files.hdl.prod-eu20.hanacloud.ondemand.com:443/crp-order-qty-opt-service/internal/common-data-snapshot/10000002109], Overwrite
(3) LocalRelation
(4) Project
Arguments: [dummy AS dummy#831093]
(5) 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
(6) RepartitionByExpression
Arguments: [product#826152, plant#826147], 25
(7) 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
(8) Repartition
Arguments: 25, true
(9) SubqueryAlias
Arguments: sos
(10) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#826157 <=> internalUUID#826172)
(11) 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]
(12) 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]
(13) LogicalRelation
Arguments: parquet, [systemId#826199, internalUUID#826200, plant#826201, product#826202, blockedForReplenishmentStartingFrom#826203, productionAspect#826204, salesPlant#826205, listing#826206], false
(14) Repartition
Arguments: 25, true
(15) Filter
Arguments: plant#826201.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(16) SubqueryAlias
Arguments: pp
(17) Join
Arguments: LeftOuter, ((product#826152 <=> product#826202.internalRefUUID) AND (plant#826147 <=> plant#826201.internalRefUUID))
(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, ... 10 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, ... 11 more fields]
(20) 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]
(21) 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]
(22) 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
(23) Repartition
Arguments: 25, true
(24) SubqueryAlias
Arguments: tmp
(25) Join
Arguments: LeftOuter, (product#826152 = internalUUID#826217)
(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, ... 17 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, ... 5 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, ... 6 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, ... 7 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, ... 8 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, ... 8 more fields]
(32) 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]
(33) 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]
(34) SubqueryAlias
Arguments: worklist
(35) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#826259, plant#826260, logisticalRoundingRule#826261]
(36) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(37) Join
Arguments: LeftOuter, ((preferredRoundingProfile#826252 <=> logisticalRoundingProfile#826259) AND (plant#826147 <=> plant#826260.internalRefUUID))
(38) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#826286, plant#826287, logisticalRoundingRule#826288]
(39) Filter
Arguments: isnull(plant#826287.internalRefUUID)
(40) SubqueryAlias
Arguments: allPlantRoundingProfiles
(41) Join
Arguments: LeftOuter, (preferredRoundingProfile#826252 <=> logisticalRoundingProfile#826286)
(42) 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]
(43) 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]
(44) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#826277, unitOfMeasure#826278]
(45) Aggregate
Arguments: [logisticalRoundingRule#826277], [logisticalRoundingRule#826277, collect_list(unitOfMeasure#826278.internalRefUUID, 0, 0) AS preferredUOMs#826279]
(46) Join
Arguments: LeftOuter, (logisticalRoundingRule#826290.logisticalRoundingRule = logisticalRoundingRule#826277)
(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, ... 11 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, ... 11 more fields]
(50) 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]
(51) 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]
(52) LogicalRelation
Arguments: parquet, [product#826303, plant#826304, orderDateTime#826305, constraintprofile#826306], false
(53) Repartition
Arguments: 25, true
(54) Join
Arguments: LeftOuter, (((product#826152 <=> product#826303) AND (plant#826147 <=> plant#826304)) AND (orderDateTime#826153 <=> orderDateTime#826305))
(55) 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]
(56) LogicalRelation
Arguments: parquet, [constraintProfile#826307, descriptions#826308, minServiceLevel#826309, minServiceLevelMinStock#826310, maxServiceLevelEndListing#826311, maxRangeCoverage#826312, minOrderQuantity#826313, profileType#826314, eventtype#826315], false
(57) Repartition
Arguments: 25, true
(58) Join
Arguments: LeftOuter, (constraintProfile#826306 <=> constraintProfile#826307)
(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, ... 20 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, ... 10 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, ... 10 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, ... 15 more fields]
(63) 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]
(64) 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]
(65) LocalRelation
Arguments: <empty>, [orderProposalId#826344, orderProposalItemId#826345, constraintOverwrites#826346]
(66) 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]
(67) 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]
(68) Join
Arguments: LeftOuter, ((orderProposalId#826161L = cast(orderProposalId#826344 as bigint)) AND (orderProposalItemId#826169 = orderProposalItemId#826345))
(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, ... 15 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, ... 14 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, ... 15 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, ... 16 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, ... 17 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, ... 18 more fields]
(78) 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]
(79) 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]
(80) LogicalRelation
Arguments: parquet, [systemId#826405, internalUUID#826406, code#826407, name#826408, commercialCode#826409, isoCode#826410], false
(81) Repartition
Arguments: 25, true
(82) SubqueryAlias
Arguments: unitOfMeasure
(83) 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)
(84) 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]
(85) LogicalRelation
Arguments: parquet, [systemId#826441, internalUUID#826442, code#826443, name#826444, commercialCode#826445, isoCode#826446], false
(86) Repartition
Arguments: 25, true
(87) SubqueryAlias
Arguments: unitOfMeasure
(88) 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)
(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, ... 22 more fields]
(90) 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]
(91) 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]
(92) LogicalRelation
Arguments: parquet, [supplier#826472, subrange#826473, plant#826474, deliverydatetime#826475, ordergroupingprofile#826476, supplierGroup#826477, locationGroup#826478, optimizationGroups#826479], false
(93) Repartition
Arguments: 25, true
(94) 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]
(95) 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]
(96) 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))
(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, ... 22 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, ... 22 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, ... 21 more fields]
(100) 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]
(101) 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]
(102) Project
Arguments: [orderProposalId#826161L, sequenceId#826166]
(103) Deduplicate
Arguments: [orderProposalId#826161L, sequenceId#826166]
(104) 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
(105) RepartitionByExpression
Arguments: [product#827701, plant#827696], 25
(106) 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
(107) Repartition
Arguments: 25, true
(108) SubqueryAlias
Arguments: sos
(109) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#827706 <=> internalUUID#827720)
(110) 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]
(111) 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]
(112) LogicalRelation
Arguments: parquet, [systemId#827744, internalUUID#827745, plant#827746, product#827747, blockedForReplenishmentStartingFrom#827748, productionAspect#827749, salesPlant#827750, listing#827751], false
(113) Repartition
Arguments: 25, true
(114) Filter
Arguments: plant#827746.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(115) SubqueryAlias
Arguments: pp
(116) Join
Arguments: LeftOuter, ((product#827701 <=> product#827747.internalRefUUID) AND (plant#827696 <=> plant#827746.internalRefUUID))
(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, ... 10 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, ... 11 more fields]
(119) 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]
(120) 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]
(121) 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
(122) Repartition
Arguments: 25, true
(123) SubqueryAlias
Arguments: tmp
(124) Join
Arguments: LeftOuter, (product#827701 = internalUUID#827756)
(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, ... 17 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, ... 5 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, ... 6 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, ... 7 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, ... 8 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, ... 8 more fields]
(131) 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]
(132) 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]
(133) SubqueryAlias
Arguments: worklist
(134) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#827774, plant#827775, logisticalRoundingRule#827776]
(135) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(136) Join
Arguments: LeftOuter, ((preferredRoundingProfile#827773 <=> logisticalRoundingProfile#827774) AND (plant#827696 <=> plant#827775.internalRefUUID))
(137) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#827777, plant#827778, logisticalRoundingRule#827779]
(138) Filter
Arguments: isnull(plant#827778.internalRefUUID)
(139) SubqueryAlias
Arguments: allPlantRoundingProfiles
(140) Join
Arguments: LeftOuter, (preferredRoundingProfile#827773 <=> logisticalRoundingProfile#827777)
(141) 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]
(142) 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]
(143) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#827782, unitOfMeasure#827783]
(144) Aggregate
Arguments: [logisticalRoundingRule#827782], [logisticalRoundingRule#827782, collect_list(unitOfMeasure#827783.internalRefUUID, 0, 0) AS preferredUOMs#827784]
(145) Join
Arguments: LeftOuter, (logisticalRoundingRule#827781.logisticalRoundingRule = logisticalRoundingRule#827782)
(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, ... 11 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, ... 11 more fields]
(149) 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]
(150) 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]
(151) LogicalRelation
Arguments: parquet, [product#827788, plant#827789, orderDateTime#827790, constraintprofile#827791], false
(152) Repartition
Arguments: 25, true
(153) Join
Arguments: LeftOuter, (((product#827701 <=> product#827788) AND (plant#827696 <=> plant#827789)) AND (orderDateTime#827702 <=> orderDateTime#827790))
(154) 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]
(155) LogicalRelation
Arguments: parquet, [constraintProfile#827792, descriptions#827793, minServiceLevel#827794, minServiceLevelMinStock#827795, maxServiceLevelEndListing#827796, maxRangeCoverage#827797, minOrderQuantity#827798, profileType#827799, eventtype#827800], false
(156) Repartition
Arguments: 25, true
(157) Join
Arguments: LeftOuter, (constraintProfile#827791 <=> constraintProfile#827792)
(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, ... 20 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, ... 10 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, ... 10 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, ... 15 more fields]
(162) 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]
(163) 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]
(164) LocalRelation
Arguments: <empty>, [orderProposalId#827809, orderProposalItemId#827810, constraintOverwrites#827811]
(165) 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]
(166) 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]
(167) Join
Arguments: LeftOuter, ((orderProposalId#827710L = cast(orderProposalId#827809 as bigint)) AND (orderProposalItemId#827718 = orderProposalItemId#827810))
(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, ... 15 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, ... 14 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, ... 15 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, ... 16 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, ... 17 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, ... 18 more fields]
(177) 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]
(178) 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]
(179) LogicalRelation
Arguments: parquet, [systemId#827823, internalUUID#827824, code#827825, name#827826, commercialCode#827827, isoCode#827828], false
(180) Repartition
Arguments: 25, true
(181) SubqueryAlias
Arguments: unitOfMeasure
(182) 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)
(183) 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]
(184) LogicalRelation
Arguments: parquet, [systemId#827830, internalUUID#827831, code#827832, name#827833, commercialCode#827834, isoCode#827835], false
(185) Repartition
Arguments: 25, true
(186) SubqueryAlias
Arguments: unitOfMeasure
(187) 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)
(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, ... 22 more fields]
(189) 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]
(190) 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]
(191) LogicalRelation
Arguments: parquet, [supplier#827839, subrange#827840, plant#827841, deliverydatetime#827842, ordergroupingprofile#827843, supplierGroup#827844, locationGroup#827845, optimizationGroups#827846], false
(192) Repartition
Arguments: 25, true
(193) 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]
(194) 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]
(195) 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))
(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, ... 22 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, ... 22 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, ... 21 more fields]
(199) 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]
(200) 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]
(201) Generate
Arguments: explode(optimizationGroups#827849), true, [optGroupId#827693]
(202) Project
Arguments: [orderProposalId#827710L, optGroupId#827693]
(203) Deduplicate
Arguments: [orderProposalId#827710L, optGroupId#827693]
(204) LogicalRelation
Arguments: parquet, [optGroupId#827687, assignmentDetails#827688, minOrderProfile#827689, multiplerestrictionprofile#827690], false
(205) Repartition
Arguments: 25, true
(206) Filter
Arguments: (isnotnull(optGroupId#827687) AND isnotnull(minOrderProfile#827689))
(207) Join
Arguments: Inner, (optGroupId#827693 = optGroupId#827687)
(208) Project
Arguments: [optGroupId#827693, orderProposalId#827710L, assignmentDetails#827688, minOrderProfile#827689, multiplerestrictionprofile#827690]
(209) Join
Arguments: LeftOuter, (orderProposalId#826161L = orderProposalId#827710L)
(210) Project
Arguments: [orderProposalId#826161L, sequenceId#826166, optGroupId#827693, assignmentDetails#827688, minOrderProfile#827689, multiplerestrictionprofile#827690]
(211) Project
Arguments: [orderProposalId#826161L, sequenceId#826166]
(212) Deduplicate
Arguments: [orderProposalId#826161L, sequenceId#826166]
(213) 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
(214) RepartitionByExpression
Arguments: [product#827889, plant#827884], 25
(215) 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
(216) Repartition
Arguments: 25, true
(217) SubqueryAlias
Arguments: sos
(218) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#827894 <=> internalUUID#827908)
(219) 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]
(220) 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]
(221) LogicalRelation
Arguments: parquet, [systemId#827932, internalUUID#827933, plant#827934, product#827935, blockedForReplenishmentStartingFrom#827936, productionAspect#827937, salesPlant#827938, listing#827939], false
(222) Repartition
Arguments: 25, true
(223) Filter
Arguments: plant#827934.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(224) SubqueryAlias
Arguments: pp
(225) Join
Arguments: LeftOuter, ((product#827889 <=> product#827935.internalRefUUID) AND (plant#827884 <=> plant#827934.internalRefUUID))
(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, ... 10 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, ... 11 more fields]
(228) 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]
(229) 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]
(230) 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
(231) Repartition
Arguments: 25, true
(232) SubqueryAlias
Arguments: tmp
(233) Join
Arguments: LeftOuter, (product#827889 = internalUUID#827944)
(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, ... 17 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, ... 5 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, ... 6 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, ... 7 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, ... 8 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, ... 8 more fields]
(240) 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]
(241) 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]
(242) SubqueryAlias
Arguments: worklist
(243) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#827962, plant#827963, logisticalRoundingRule#827964]
(244) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(245) Join
Arguments: LeftOuter, ((preferredRoundingProfile#827961 <=> logisticalRoundingProfile#827962) AND (plant#827884 <=> plant#827963.internalRefUUID))
(246) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#827965, plant#827966, logisticalRoundingRule#827967]
(247) Filter
Arguments: isnull(plant#827966.internalRefUUID)
(248) SubqueryAlias
Arguments: allPlantRoundingProfiles
(249) Join
Arguments: LeftOuter, (preferredRoundingProfile#827961 <=> logisticalRoundingProfile#827965)
(250) 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]
(251) 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]
(252) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#827970, unitOfMeasure#827971]
(253) Aggregate
Arguments: [logisticalRoundingRule#827970], [logisticalRoundingRule#827970, collect_list(unitOfMeasure#827971.internalRefUUID, 0, 0) AS preferredUOMs#827972]
(254) Join
Arguments: LeftOuter, (logisticalRoundingRule#827969.logisticalRoundingRule = logisticalRoundingRule#827970)
(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, ... 11 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, ... 11 more fields]
(258) 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]
(259) 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]
(260) LogicalRelation
Arguments: parquet, [product#827976, plant#827977, orderDateTime#827978, constraintprofile#827979], false
(261) Repartition
Arguments: 25, true
(262) Join
Arguments: LeftOuter, (((product#827889 <=> product#827976) AND (plant#827884 <=> plant#827977)) AND (orderDateTime#827890 <=> orderDateTime#827978))
(263) 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]
(264) LogicalRelation
Arguments: parquet, [constraintProfile#827980, descriptions#827981, minServiceLevel#827982, minServiceLevelMinStock#827983, maxServiceLevelEndListing#827984, maxRangeCoverage#827985, minOrderQuantity#827986, profileType#827987, eventtype#827988], false
(265) Repartition
Arguments: 25, true
(266) Join
Arguments: LeftOuter, (constraintProfile#827979 <=> constraintProfile#827980)
(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, ... 20 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, ... 10 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, ... 10 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, ... 15 more fields]
(271) 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]
(272) 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]
(273) LocalRelation
Arguments: <empty>, [orderProposalId#827997, orderProposalItemId#827998, constraintOverwrites#827999]
(274) 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]
(275) 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]
(276) Join
Arguments: LeftOuter, ((orderProposalId#827898L = cast(orderProposalId#827997 as bigint)) AND (orderProposalItemId#827906 = orderProposalItemId#827998))
(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, ... 15 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, ... 14 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, ... 15 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, ... 16 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, ... 17 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, ... 18 more fields]
(286) 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]
(287) 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]
(288) LogicalRelation
Arguments: parquet, [systemId#828011, internalUUID#828012, code#828013, name#828014, commercialCode#828015, isoCode#828016], false
(289) Repartition
Arguments: 25, true
(290) SubqueryAlias
Arguments: unitOfMeasure
(291) 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)
(292) 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]
(293) LogicalRelation
Arguments: parquet, [systemId#828018, internalUUID#828019, code#828020, name#828021, commercialCode#828022, isoCode#828023], false
(294) Repartition
Arguments: 25, true
(295) SubqueryAlias
Arguments: unitOfMeasure
(296) 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)
(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, ... 22 more fields]
(298) 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]
(299) 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]
(300) LogicalRelation
Arguments: parquet, [supplier#828027, subrange#828028, plant#828029, deliverydatetime#828030, ordergroupingprofile#828031, supplierGroup#828032, locationGroup#828033, optimizationGroups#828034], false
(301) Repartition
Arguments: 25, true
(302) 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]
(303) 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]
(304) 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))
(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, ... 22 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, ... 22 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, ... 21 more fields]
(308) 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]
(309) 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]
(310) Project
Arguments: [orderProposalId#827898L, sequenceId#827903]
(311) Deduplicate
Arguments: [orderProposalId#827898L, sequenceId#827903]
(312) 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
(313) RepartitionByExpression
Arguments: [product#828045, plant#828040], 25
(314) 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
(315) Repartition
Arguments: 25, true
(316) SubqueryAlias
Arguments: sos
(317) Join
Arguments: LeftOuter, (sourceOfSupplyUuid#828050 <=> internalUUID#828064)
(318) 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]
(319) 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]
(320) LogicalRelation
Arguments: parquet, [systemId#828088, internalUUID#828089, plant#828090, product#828091, blockedForReplenishmentStartingFrom#828092, productionAspect#828093, salesPlant#828094, listing#828095], false
(321) Repartition
Arguments: 25, true
(322) Filter
Arguments: plant#828090.internalRefUUID IN (25c0d9731dd07bb53999d9a8f04398e0,6d24a939f4bbd79f6acb8684d6e45c97)
(323) SubqueryAlias
Arguments: pp
(324) Join
Arguments: LeftOuter, ((product#828045 <=> product#828091.internalRefUUID) AND (plant#828040 <=> plant#828090.internalRefUUID))
(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, ... 10 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, ... 11 more fields]
(327) 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]
(328) 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]
(329) 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
(330) Repartition
Arguments: 25, true
(331) SubqueryAlias
Arguments: tmp
(332) Join
Arguments: LeftOuter, (product#828045 = internalUUID#828100)
(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, ... 17 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, ... 5 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, ... 6 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, ... 7 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, ... 8 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, ... 8 more fields]
(339) 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]
(340) 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]
(341) SubqueryAlias
Arguments: worklist
(342) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#828118, plant#828119, logisticalRoundingRule#828120]
(343) SubqueryAlias
Arguments: plantSpecificRoundingProfiles
(344) Join
Arguments: LeftOuter, ((preferredRoundingProfile#828117 <=> logisticalRoundingProfile#828118) AND (plant#828040 <=> plant#828119.internalRefUUID))
(345) LocalRelation
Arguments: <empty>, [logisticalRoundingProfile#828121, plant#828122, logisticalRoundingRule#828123]
(346) Filter
Arguments: isnull(plant#828122.internalRefUUID)
(347) SubqueryAlias
Arguments: allPlantRoundingProfiles
(348) Join
Arguments: LeftOuter, (preferredRoundingProfile#828117 <=> logisticalRoundingProfile#828121)
(349) 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]
(350) 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]
(351) LocalRelation
Arguments: <empty>, [logisticalRoundingRule#828126, unitOfMeasure#828127]
(352) Aggregate
Arguments: [logisticalRoundingRule#828126], [logisticalRoundingRule#828126, collect_list(unitOfMeasure#828127.internalRefUUID, 0, 0) AS preferredUOMs#828128]
(353) Join
Arguments: LeftOuter, (logisticalRoundingRule#828125.logisticalRoundingRule = logisticalRoundingRule#828126)
(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, ... 11 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, ... 11 more fields]
(357) 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]
(358) 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]
(359) LogicalRelation
Arguments: parquet, [product#828132, plant#828133, orderDateTime#828134, constraintprofile#828135], false
(360) Repartition
Arguments: 25, true
(361) Join
Arguments: LeftOuter, (((product#828045 <=> product#828132) AND (plant#828040 <=> plant#828133)) AND (orderDateTime#828046 <=> orderDateTime#828134))
(362) 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]
(363) LogicalRelation
Arguments: parquet, [constraintProfile#828136, descriptions#828137, minServiceLevel#828138, minServiceLevelMinStock#828139, maxServiceLevelEndListing#828140, maxRangeCoverage#828141, minOrderQuantity#828142, profileType#828143, eventtype#828144], false
(364) Repartition
Arguments: 25, true
(365) Join
Arguments: LeftOuter, (constraintProfile#828135 <=> constraintProfile#828136)
(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, ... 20 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, ... 10 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, ... 10 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, ... 15 more fields]
(370) 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]
(371) 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]
(372) LocalRelation
Arguments: <empty>, [orderProposalId#828153, orderProposalItemId#828154, constraintOverwrites#828155]
(373) 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]
(374) 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]
(375) Join
Arguments: LeftOuter, ((orderProposalId#828054L = cast(orderProposalId#828153 as bigint)) AND (orderProposalItemId#828062 = orderProposalItemId#828154))
(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, ... 15 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, ... 14 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, ... 15 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, ... 16 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, ... 17 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, ... 18 more fields]
(385) 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]
(386) 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]
(387) LogicalRelation
Arguments: parquet, [systemId#828167, internalUUID#828168, code#828169, name#828170, commercialCode#828171, isoCode#828172], false
(388) Repartition
Arguments: 25, true
(389) SubqueryAlias
Arguments: unitOfMeasure
(390) 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)
(391) 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]
(392) LogicalRelation
Arguments: parquet, [systemId#828174, internalUUID#828175, code#828176, name#828177, commercialCode#828178, isoCode#828179], false
(393) Repartition
Arguments: 25, true
(394) SubqueryAlias
Arguments: unitOfMeasure
(395) 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)
(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, ... 22 more fields]
(397) 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]
(398) 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]
(399) LogicalRelation
Arguments: parquet, [supplier#828183, subrange#828184, plant#828185, deliverydatetime#828186, ordergroupingprofile#828187, supplierGroup#828188, locationGroup#828189, optimizationGroups#828190], false
(400) Repartition
Arguments: 25, true
(401) 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]
(402) 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]
(403) 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))
(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, ... 22 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, ... 22 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, ... 21 more fields]
(407) 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]
(408) 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]
(409) Generate
Arguments: explode(optimizationGroups#828193), true, [optGroupId#828194]
(410) Project
Arguments: [orderProposalId#828054L, optGroupId#828194]
(411) Deduplicate
Arguments: [orderProposalId#828054L, optGroupId#828194]
(412) LogicalRelation
Arguments: parquet, [optGroupId#828195, assignmentDetails#828196, minOrderProfile#828197, multiplerestrictionprofile#828198], false
(413) Repartition
Arguments: 25, true
(414) Filter
Arguments: (isnotnull(optGroupId#828195) AND isnotnull(minOrderProfile#828197))
(415) Join
Arguments: Inner, (optGroupId#828194 = optGroupId#828195)
(416) Project
Arguments: [optGroupId#828194, orderProposalId#828054L, assignmentDetails#828196, minOrderProfile#828197, multiplerestrictionprofile#828198]
(417) Join
Arguments: LeftOuter, (orderProposalId#827898L = orderProposalId#828054L)
(418) Project
Arguments: [orderProposalId#827898L, sequenceId#827903, optGroupId#828194, assignmentDetails#828196, minOrderProfile#828197, multiplerestrictionprofile#828198]
(419) LogicalRelation
Arguments: parquet, [supplierminimumprofilename#827855, descriptions#827856, dimensionType#827857, dimensionValue#827858, dimensionUnit#827859, acceptanceThreshold#827860, profileType#827861, eventtype#827862], false
(420) Repartition
Arguments: 25, true
(421) Join
Arguments: Inner, (minOrderProfile#828197 <=> supplierminimumprofilename#827855)
(422) LogicalRelation
Arguments: parquet, [systemId#827863, internalUUID#827864, code#827865, name#827866, commercialCode#827867, isoCode#827868], false
(423) Repartition
Arguments: 25, true
(424) Join
Arguments: LeftOuter, (dimensionUnit#827859.dimensionCodeUuid <=> internalUUID#827864)
(425) 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]
(426) 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]
(427) Project
Arguments: [orderProposalId#827898L, sequenceId#827903, optGroupId#828194, assignmentDetails#828196, minOrderProfile#828197, multiplerestrictionprofile#828198, minOrderGoal#827878]
(428) Project
Arguments: [orderProposalId#827898L, optGroupId#828194, assignmentDetails#828196, minOrderProfile#828197, multiplerestrictionprofile#828198, minOrderGoal#827878]
(429) Join
Arguments: LeftOuter, (orderProposalId#826161L = orderProposalId#827898L)
(430) Project
Arguments: [orderProposalId#826161L, sequenceId#826166, optGroupId#828194, assignmentDetails#828196, minOrderProfile#828197, multiplerestrictionprofile#828198, minOrderGoal#827878]
(431) 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]
(432) Project
Arguments: [orderProposalId#826161L, sequenceId#826166, filter(optimizationGroups#828210, lambdafunction(isnotnull(lambda x_2169#828220.optGroupId), lambda x_2169#828220, false)) AS optimizationGroups#828219]
(433) Generate
Arguments: explode(optimizationGroups#828219.minOrderGoal), false, [minOrderGoal#831072]
(434) Project
Arguments: [minOrderGoal#831072]
(435) Filter
Arguments: (minOrderGoal#831072.dimensionType <=> 2)
(436) Project
Arguments: [minOrderGoal#831072.unit AS uomCategoryName#831074]
(437) LogicalRelation
Arguments: parquet, [uomCategoryName#831065, descriptions#831066, uoms#831067, validTo#831068, eventtype#831069], false
(438) Repartition
Arguments: 25, true
(439) Join
Arguments: LeftOuter, (uomCategoryName#831074 = uomCategoryName#831065)
(440) Project
Arguments: [uomCategoryName#831074, descriptions#831066, uoms#831067, validTo#831068, eventtype#831069]
(441) Project
Arguments: [uomCategoryName#831074, descriptions#831066, coalesce(uoms#831067, cast(array() as array<struct<internalRefUUID:string,id:string>>)) AS uoms#831077, validTo#831068, eventtype#831069]
(442) Project
Arguments: [uomCategoryName#831074, descriptions#831066, transform(uoms#831077, lambdafunction(struct(uom, lambda x_2170#831081.id, uomUuid, lambda x_2170#831081.internalRefUUID), lambda x_2170#831081, false)) AS uoms#831080, validTo#831068, eventtype#831069]
(443) Project
Arguments: [uomCategoryName#831074, descriptions#831066, uoms#831080, validTo#831068, eventtype#831069, struct(uomCategoryName, uomCategoryName#831074, uoms, uoms#831080) AS uomCategory#831082]
(444) Project
Arguments: [uomCategoryName#831074, descriptions#831066, uoms#831080, validTo#831068, eventtype#831069, uomCategory#831082, dummy AS dummy#831083]
(445) Aggregate
Arguments: [dummy#831083], [dummy#831083, collect_set(uomCategory#831082, 0, 0) AS uomCategories#831084]
(446) Join
Arguments: LeftOuter, (dummy#831093 = dummy#831083)
(447) Project
Arguments: [dummy#831093, uomCategories#831084]
(448) Project
Arguments: [dummy#831093, coalesce(uomCategories#831084, cast(array() as array<struct<uomCategoryName:string,uoms:array<struct<uom:string,uomUuid:string>>>>)) AS uomCategories#831094]
(449) Project
Arguments: [uomCategories#831094]
(450) LogicalRelation
Arguments: parquet, [name#831095, category#831096, status#831097, configurationVersion#831098, businessContext#831099, message#831100, settings#831101, eventtype#831102], false
(451) Repartition
Arguments: 25, true
(452) Filter
Arguments: (isnotnull(configurationVersion#831098) AND isnotnull(name#831095))
(453) Aggregate
Arguments: [name#831095], [name#831095, max(struct(configurationVersion, configurationVersion#831098, status, status#831097, settings, settings#831101)) AS best#831104]
(454) Filter
Arguments: (best#831104.status = ACTIVE)
(455) Project
Arguments: [name#831095, best#831104.settings AS settings#831115, best#831104.configurationVersion AS configurationVersion#831116]
(456) Aggregate
Arguments: [map_from_entries(collect_list(struct(name, name#831095, configValue, struct(configurationVersion, configurationVersion#831116, name, name#831095, settings, settings#831115, status, ACTIVE)), 0, 0)) AS insightConfigurations#831119]
(457) Join
Arguments: Cross
(458) Project
Arguments: [uomCategories#831094, coalesce(insightConfigurations#831119, cast(map() as map<string,struct<configurationVersion:string,name:string,settings:array<struct<name:string,type:string,value:string>>,status:string>>)) AS insightConfigurations#831124]
(459) Project
Arguments: [uomCategories#831094, insightConfigurations#831124, 0_1_10000002109 AS shardId#834286]