0 Replies Latest reply on Dec 5, 2016 5:42 PM by 2993494

    Grouping of Purchase Orders outside of standard oracle defaults when created from requisition

    2993494

      I have a pre-group the purchased orders after the drop ship order has been created. They are then passed into the po interface table for import. I would like to group them accordingly - Based on the GROUP_CODE but all lines are on one PO as opposed to each PO number in the GROUP CODE.  So  PO # PC4420797

                                                PO Line #   R13562015:iPad Mini 4 Silicone Case (Stone)

                                                PO Line #   R13562015:iPod Touch (16GB  Gold)

                                         PO # PC4420796

                                               PO Line # R13562017:iPad Mini 2 (7.9in, 32GB, WiFi, Silver)

                                              PO Line # R13562017:5W USB Power Adapter

                                              PO Line # R13562017:Lightning to USB Cable

                                     PO # PC4420791

                                             PO Line # R13562017:iPad Mini 2 (7.9in, 32GB, WiFi, Silver)

                                             PO Line # R13562017:5W USB Power Adapter

                                             PO Line # R13562017:Lightning to USB Cable

                                    PO # PC4420799

                                             PO Line #  R13562024:iPad Mini 4 Silicone Case (Stone)

                                    PO # PC4420798

                                             PO Line # R13562028:iPod Touch (16GB  Gold)

       

      INTERFACE_LINE_ID

      INTERFACE_HEADER_ID

      ACTION

      GROUP_CODE

      ITEM_DESCRIPTION

      LINE_NUM

      PO_LINE_ID

      REQUISITION_LINE_ID

      ITEM_ID

      12130949

      8619350

      ADD

      PC4420797

      R13562015:iPad Mini 4 Silicone Case (Stone)

      1

      9515835

      9144624

      2911225

      12130950

      8619350

      ADD

      PC4420797

      R13562015:iPod Touch (16GB  Gold)

      2

      9515836

      9144611

      2772154

      12130951

      8619350

      ADD

      PC4420796

      R13562017:iPad Mini 2 (7.9in, 32GB, WiFi, Silver)

      3

      9515837

      9144615

      2326374

      12130952

      8619350

      ADD

      PC4420796

      R13562017:5W USB Power Adapter

      4

      9515838

      9144626

      2225986

      12130953

      8619350

      ADD

      PC4420796

      R13562017:Lightning to USB Cable

      5

      9515839

      9144627

      2225985

      12130954

      8619350

      ADD

      PC4420791

      R13562017:iPad Mini 2 (7.9in, 32GB, WiFi, Silver)

      6

      9515840

      9144615

      2326374

      12130955

      8619350

      ADD

      PC4420791

      R13562017:5W USB Power Adapter

      7

      9515841

      9144626

      2225986

      12130956

      8619350

      ADD

      PC4420791

      R13562017:Lightning to USB Cable

      8

      9515842

      9144627

      2225985

      12130957

      8619350

      ADD

      PC4420799

      R13562024:iPad Mini 4 Silicone Case (Stone)

      9

      9515843

      9144609

      2911225

      12130958

      8619350

      ADD

      PC4420798

      R13562028:iPod Touch (16GB  Gold)

      10

      9515844

      9144602

      2772154