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