DBA Data[Home] [Help]

APPS.INV_MGD_MVT_STATS_PROC SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 51

g_records_inserted   NUMBER      := 0;
Line: 80

  l_insert_status        VARCHAR2(10);
Line: 153

    ,x_return_status        => l_insert_status
   );
Line: 159

  IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
  THEN
      COMMIT;
Line: 172

  g_records_inserted     := g_records_inserted +1;
Line: 307

    Update_Invoice_Info
      ( p_movement_transaction => l_movement_transaction
      , p_start_date           => p_start_date
      , p_end_date             => p_end_date
      , p_transaction_type     => p_source_type
      , x_return_status        => l_return_status
      );
Line: 321

                        || '.Failed in Update_Invoice_Info'
                      ,'Failed'
                      );
Line: 454

    Update_PO_With_Correction
       ( p_legal_entity_id      => p_legal_entity_id
       , p_start_date           => p_start_date
       , p_end_date             => p_end_date
       , p_transaction_type     => p_source_type
       , x_return_status        => l_return_status
       );
Line: 468

                        || '.Failed in Update_PO_With_Correction'
                      ,'Failed'
                      );
Line: 560

    , '< ***** Records Inserted:   '||g_records_inserted
      );
Line: 742

  l_insert_flag          VARCHAR2(1);
Line: 743

  l_insert_status        VARCHAR2(10);
Line: 945

            l_insert_flag := 'N';
Line: 947

            l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
            ( p_movement_transaction => l_movement_transaction);
Line: 952

          IF l_insert_flag = 'Y'
          THEN
            INV_MGD_MVT_INV_MDTR.Get_INV_Details
            ( x_movement_transaction => l_movement_transaction
            , x_return_status        => l_return_status
            );
Line: 992

                  , x_return_status        => l_insert_status
                  );
Line: 996

                IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
                THEN
                  l_movement_id      := l_movement_transaction.movement_id;
Line: 999

                  g_records_inserted     := g_records_inserted +1;
Line: 1020

      IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
      THEN
        l_movement_transaction.movement_id := l_movement_id;
Line: 1024

        INV_MGD_MVT_INV_MDTR.Update_INV_Transactions
        ( p_movement_transaction => l_movement_transaction
        , x_return_status        => l_return_status );
Line: 1121

  l_insert_flag          VARCHAR2(1);
Line: 1125

  l_insert_status        VARCHAR2(10);
Line: 1147

  SELECT
    item_type_code
  , NVL(shipped_quantity, fulfilled_quantity)
  FROM
    oe_order_lines_all
  WHERE line_id = l_link_to_line_id;
Line: 1427

          l_insert_flag := 'N';
Line: 1429

          l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
          ( p_movement_transaction => l_movement_transaction);
Line: 1437

                         ||'.The need crt kit,kit rec status,insert flg are '
                         ||l_need_create_kit||','||l_kit_record_status
                         ||','||l_insert_flag
                       ,'debug msg');
Line: 1444

        IF l_insert_flag = 'Y'
        THEN
          INV_MGD_MVT_SO_MDTR.Get_SO_Details
           (x_movement_transaction => l_movement_transaction
          ,x_return_status        => l_return_status
           );
Line: 1494

              /*Start Bugfix 13400081: IO records were not getting updated because of
                this if condition.
              IF l_movement_transaction.document_source_type <> 'IO'
              THEN
                IF l_movement_transaction.invoice_id IS NULL
                THEN
                  l_movement_transaction.invoice_quantity        := NULL;
Line: 1533

                SELECT mvt_stat_status
                INTO   l_mvt_stat_status
                FROM   wsh_delivery_details_ob_grp_v
                WHERE  delivery_detail_id = l_movement_transaction.picking_line_detail_id;
Line: 1551

                 ,x_return_status        => l_insert_status
                );
Line: 1555

              IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
              THEN
                l_movement_id      := l_movement_transaction.movement_id;
Line: 1558

                g_records_inserted     := g_records_inserted +1;
Line: 1570

        END IF; --< end of IF from l_insert_flag = 'Y' >
Line: 1576

    IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
    THEN
      l_movement_transaction.movement_id := l_movement_id;
Line: 1594

          INV_MGD_MVT_SO_MDTR.Update_KIT_SO_Transactions
          ( p_movement_id        => l_movement_transaction.movement_id
          , p_delivery_detail_id => l_movement_transaction.picking_line_detail_id
          , p_link_to_line_id    => l_link_to_line_id
          , p_status             => l_cross_le_status
          , x_return_status     => l_return_status
          );
Line: 1603

        INV_MGD_MVT_SO_MDTR.Update_SO_Transactions
        ( p_movement_transaction => l_movement_transaction
        , p_status             => l_cross_le_status
        , x_return_status      => l_return_status
        );
Line: 1710

  l_insert_flag           VARCHAR2(1);
Line: 1713

  l_insert_status         VARCHAR2(10);
Line: 1736

  SELECT
    item_type_code
  , NVL(shipped_quantity, fulfilled_quantity)
  FROM
    oe_order_lines_all
  WHERE line_id = l_link_to_line_id;
Line: 1745

  SELECT
    transactional_curr_code
  , conversion_rate
  , conversion_type_code
  , conversion_rate_date
  FROM oe_order_headers_all
  WHERE header_id = l_movement_transaction2.order_header_id;
Line: 1754

  SELECT
    bill_to_site_use_id
  FROM
    hz_cust_site_uses_all
  WHERE site_use_id = l_movement_transaction.ship_to_site_use_id;
Line: 2050

            l_insert_flag := 'N';
Line: 2052

            l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
            ( p_movement_transaction => l_movement_transaction);
Line: 2061

                           ||'.The need crt kit,kit rec status,insert flg are '
                           ||l_need_create_kit
                           ||','||l_kit_record_status
                           ||','||l_insert_flag
                         ,'debug msg');
Line: 2069

          IF l_insert_flag = 'Y'
          THEN
            INV_MGD_MVT_SO_MDTR.Get_SO_Details
            (x_movement_transaction => l_movement_transaction
            ,x_return_status        => l_return_status
            );
Line: 2138

                ,x_return_status        => l_insert_status
                );
Line: 2142

                IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
                THEN
                  l_movement_id      := l_movement_transaction.movement_id;
Line: 2145

                  g_records_inserted := g_records_inserted +1;
Line: 2191

            l_insert_flag := 'N';
Line: 2193

            l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
            ( p_movement_transaction => l_movement_transaction2);
Line: 2202

                           ||'.The need crt kit,kit rec status,insert flg are '
                           ||l_need_create_kit
                           ||','||l_kit_record_status
                           ||','||l_insert_flag
                         ,'debug msg');
Line: 2210

          IF l_insert_flag = 'Y'
          THEN
            --Clear invoice information
            l_movement_transaction2.invoice_id := null;
Line: 2324

                ,x_return_status        => l_insert_status
                );
Line: 2327

                IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
                THEN
                  l_movement_id2      := l_movement_transaction2.movement_id;
Line: 2330

                  g_records_inserted  := g_records_inserted +1;
Line: 2350

      IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
      THEN
        l_movement_transaction.movement_id := l_movement_id;
Line: 2358

            INV_MGD_MVT_SO_MDTR.Update_KIT_SO_Transactions
            ( p_movement_id        => l_movement_transaction.movement_id
            , p_delivery_detail_id => l_movement_transaction.picking_line_detail_id
            , p_link_to_line_id    => l_link_to_line_id
            , p_status             => 'ARRIVALPROCESSED'
            , x_return_status     => l_return_status
            );
Line: 2367

          INV_MGD_MVT_SO_MDTR.Update_SO_Transactions
          ( p_movement_transaction => l_movement_transaction
          , p_status               => 'ARRIVALPROCESSED'
          , x_return_status        => l_return_status
          );
Line: 2469

  l_insert_flag          VARCHAR2(1);
Line: 2472

  l_insert_status        VARCHAR2(10);
Line: 2499

  SELECT
    MAX(oola.line_id)
  , MAX(wdd.delivery_detail_id) picking_line_detail_id
  FROM
    oe_order_lines_all oola
  , wsh_delivery_details_ob_grp_v wdd
  WHERE oola.order_source_id = 10   --combine 1st and 2nd condition to use index 11
    AND oola.orig_sys_document_ref = l_req_number
    AND oola.source_document_line_id = l_movement_transaction.requisition_line_id
    AND oola.line_id = wdd.source_line_id
    --Bugfix 9024785 - When shipping lines are split and quantity is partially shipped,
    --the existing logic was failing. Added the following and clauses
    AND oola.line_id=nvl(l_movement_transaction.order_line_id,oola.line_id)
    AND wdd.shipped_quantity > 0
    AND wdd.source_code   = 'OE';
Line: 2518

  SELECT
    oola.line_id
  , wdd.delivery_detail_id picking_line_detail_id
  FROM
    oe_order_lines_all oola
  , wsh_delivery_details_ob_grp_v wdd
  , rcv_transactions rcv
  , rcv_shipment_lines rsl
  , mtl_material_transactions mmt
  WHERE oola.order_source_id = 10   --combine 1st and 2nd condition to use index 11
    AND oola.orig_sys_document_ref = l_req_number
    AND oola.source_document_line_id = l_movement_transaction.requisition_line_id
    AND oola.line_id = wdd.source_line_id
    /* Bugfix 9024785 - When shipping lines are split and quantity is partially shipped,
    the existing logic was failing. Added the following and clauses
    */
    AND oola.line_id = nvl(l_movement_transaction.order_line_id,oola.line_id)
    AND wdd.shipped_quantity > 0
    AND wdd.source_code = 'OE'
    AND rcv.transaction_id = l_movement_transaction.rcv_transaction_id
    AND rsl.shipment_line_id = rcv.shipment_line_id
    AND rsl.mmt_transaction_id = mmt.transaction_id
    AND mmt.source_line_id = oola.line_id
    --Bugfix 12635623: Adding this condition to account for a situation
    --where a SO line is shipped out using multiple delivery details but same
    --delivery. This would cause multiple records in wdd but the SO line
    --would not split. The old sql without this new condition would return all
    --delivery detail ids but only one would get used which might not be the
    --correct one.
    AND mmt.picking_line_id = wdd.delivery_detail_id;
Line: 2550

  SELECT
     wdd.organization_id shipping_organization_id
  FROM
   wsh_delivery_details_ob_grp_v wdd
  WHERE wdd.delivery_detail_id=l_movement_transaction.picking_line_detail_id;
Line: 2752

          l_insert_flag := 'N';
Line: 2754

          l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
          ( p_movement_transaction => l_movement_transaction);
Line: 2759

        IF l_insert_flag = 'Y'
        THEN
          INV_MGD_MVT_PO_MDTR.Get_IO_Arrival_Details
          ( x_movement_transaction => l_movement_transaction
          , x_return_status        => l_return_status
          );
Line: 2807

               ,x_return_status        => l_insert_status
               );
Line: 2811

              IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
              THEN
                l_movement_id      := l_movement_transaction.movement_id;
Line: 2814

                g_records_inserted     := g_records_inserted +1;
Line: 2828

        END IF;   --< end of if from l_insert_flag>
Line: 2835

    IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
    THEN
      l_movement_transaction.movement_id := l_movement_id;
Line: 2839

      INV_MGD_MVT_PO_MDTR.Update_PO_Transactions
      ( p_movement_transaction => l_movement_transaction
      , p_mvt_stat_status      => NULL
      , x_return_status        => l_return_status
      );
Line: 2912

PROCEDURE Update_PO_With_RTV
( x_mvt_rtv_transaction IN OUT  NOCOPY
    INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
, x_return_status        OUT NOCOPY VARCHAR2
)
IS
l_parent_mvt_id          NUMBER;
Line: 2924

l_api_name CONSTANT      VARCHAR2(30) := 'Update_PO_With_RTV';
Line: 2928

SELECT
  mms.movement_id
, mms.movement_status
FROM
  mtl_movement_statistics mms
, rcv_transactions rt
WHERE mms.rcv_transaction_id = rt.parent_transaction_id
  AND rt.transaction_id = x_mvt_rtv_transaction.rcv_transaction_id
  AND mms.entity_org_id = x_mvt_rtv_transaction.entity_org_id
  AND mms.zone_code     = x_mvt_rtv_transaction.zone_code
  AND mms.usage_type    = x_mvt_rtv_transaction.usage_type
  AND mms.stat_type     = x_mvt_rtv_transaction.stat_type
  AND mms.movement_type <> 'AA';
Line: 2944

SELECT
  movement_id
, organization_id
, entity_org_id
, movement_type
, movement_status
, transaction_date
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, document_source_type
, creation_method
, document_reference
, document_line_reference
, document_unit_price
, document_line_ext_value
, receipt_reference
, shipment_reference
, shipment_line_reference
, pick_slip_reference
, customer_name
, customer_number
, customer_location
, transacting_from_org
, transacting_to_org
, vendor_name
, vendor_number
, vendor_site
, bill_to_name
, bill_to_number
, bill_to_site
, po_header_id
, po_line_id
, po_line_location_id
, order_header_id
, order_line_id
, picking_line_id
, shipment_header_id
, shipment_line_id
, ship_to_customer_id
, ship_to_site_use_id
, bill_to_customer_id
, bill_to_site_use_id
, vendor_id
, vendor_site_id
, from_organization_id
, to_organization_id
, parent_movement_id
, inventory_item_id
, item_description
, item_cost
, transaction_quantity
, transaction_uom_code
, primary_quantity
, invoice_batch_id
, invoice_id
, customer_trx_line_id
, invoice_batch_reference
, invoice_reference
, invoice_line_reference
, invoice_date_reference
, invoice_quantity
, invoice_unit_price
, invoice_line_ext_value
, outside_code
, outside_ext_value
, outside_unit_price
, currency_code
, currency_conversion_rate
, currency_conversion_type
, currency_conversion_date
, period_name
, report_reference
, report_date
, category_id
, weight_method
, unit_weight
, total_weight
, transaction_nature
, delivery_terms
, transport_mode
, alternate_quantity
, alternate_uom_code
, dispatch_territory_code
, destination_territory_code
, origin_territory_code
, stat_method
, stat_adj_percent
, stat_adj_amount
, stat_ext_value
, area
, port
, stat_type
, comments
, attribute_category
, commodity_code
, commodity_description
, requisition_header_id
, requisition_line_id
, picking_line_detail_id
, usage_type
, zone_code
, edi_sent_flag
, statistical_procedure_code
, movement_amount
, triangulation_country_code
, csa_code
, oil_reference_code
, container_type_code
, flow_indicator_code
, affiliation_reference_code
, origin_territory_eu_code
, destination_territory_eu_code
, dispatch_territory_eu_code
, set_of_books_period
, taric_code
, preference_code
, rcv_transaction_id
, mtl_transaction_id
, total_weight_uom_code
, financial_document_flag
--, opm_trans_id
, customer_vat_number
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, triangulation_country_eu_code
, distribution_line_number
, ship_to_name
, ship_to_number
, ship_to_site
, edi_transaction_date
, edi_transaction_reference
, esl_drop_shipment_code
FROM
  mtl_movement_statistics
WHERE movement_id = l_parent_mvt_id;
Line: 3172

    , l_parent_mvt_transaction.last_update_date
    , l_parent_mvt_transaction.last_updated_by
    , l_parent_mvt_transaction.creation_date
    , l_parent_mvt_transaction.created_by
    , l_parent_mvt_transaction.last_update_login
    , l_parent_mvt_transaction.document_source_type
    , l_parent_mvt_transaction.creation_method
    , l_parent_mvt_transaction.document_reference
    , l_parent_mvt_transaction.document_line_reference
    , l_parent_mvt_transaction.document_unit_price
    , l_parent_mvt_transaction.document_line_ext_value
    , l_parent_mvt_transaction.receipt_reference
    , l_parent_mvt_transaction.shipment_reference
    , l_parent_mvt_transaction.shipment_line_reference
    , l_parent_mvt_transaction.pick_slip_reference
    , l_parent_mvt_transaction.customer_name
    , l_parent_mvt_transaction.customer_number
    , l_parent_mvt_transaction.customer_location
    , l_parent_mvt_transaction.transacting_from_org
    , l_parent_mvt_transaction.transacting_to_org
    , l_parent_mvt_transaction.vendor_name
    , l_parent_mvt_transaction.vendor_number
    , l_parent_mvt_transaction.vendor_site
    , l_parent_mvt_transaction.bill_to_name
    , l_parent_mvt_transaction.bill_to_number
    , l_parent_mvt_transaction.bill_to_site
    , l_parent_mvt_transaction.po_header_id
    , l_parent_mvt_transaction.po_line_id
    , l_parent_mvt_transaction.po_line_location_id
    , l_parent_mvt_transaction.order_header_id
    , l_parent_mvt_transaction.order_line_id
    , l_parent_mvt_transaction.picking_line_id
    , l_parent_mvt_transaction.shipment_header_id
    , l_parent_mvt_transaction.shipment_line_id
    , l_parent_mvt_transaction.ship_to_customer_id
    , l_parent_mvt_transaction.ship_to_site_use_id
    , l_parent_mvt_transaction.bill_to_customer_id
    , l_parent_mvt_transaction.bill_to_site_use_id
    , l_parent_mvt_transaction.vendor_id
    , l_parent_mvt_transaction.vendor_site_id
    , l_parent_mvt_transaction.from_organization_id
    , l_parent_mvt_transaction.to_organization_id
    , l_parent_mvt_transaction.parent_movement_id
    , l_parent_mvt_transaction.inventory_item_id
    , l_parent_mvt_transaction.item_description
    , l_parent_mvt_transaction.item_cost
    , l_parent_mvt_transaction.transaction_quantity
    , l_parent_mvt_transaction.transaction_uom_code
    , l_parent_mvt_transaction.primary_quantity
    , l_parent_mvt_transaction.invoice_batch_id
    , l_parent_mvt_transaction.invoice_id
    , l_parent_mvt_transaction.customer_trx_line_id
    , l_parent_mvt_transaction.invoice_batch_reference
    , l_parent_mvt_transaction.invoice_reference
    , l_parent_mvt_transaction.invoice_line_reference
    , l_parent_mvt_transaction.invoice_date_reference
    , l_parent_mvt_transaction.invoice_quantity
    , l_parent_mvt_transaction.invoice_unit_price
    , l_parent_mvt_transaction.invoice_line_ext_value
    , l_parent_mvt_transaction.outside_code
    , l_parent_mvt_transaction.outside_ext_value
    , l_parent_mvt_transaction.outside_unit_price
    , l_parent_mvt_transaction.currency_code
    , l_parent_mvt_transaction.currency_conversion_rate
    , l_parent_mvt_transaction.currency_conversion_type
    , l_parent_mvt_transaction.currency_conversion_date
    , l_parent_mvt_transaction.period_name
    , l_parent_mvt_transaction.report_reference
    , l_parent_mvt_transaction.report_date
    , l_parent_mvt_transaction.category_id
    , l_parent_mvt_transaction.weight_method
    , l_parent_mvt_transaction.unit_weight
    , l_parent_mvt_transaction.total_weight
    , l_parent_mvt_transaction.transaction_nature
    , l_parent_mvt_transaction.delivery_terms
    , l_parent_mvt_transaction.transport_mode
    , l_parent_mvt_transaction.alternate_quantity
    , l_parent_mvt_transaction.alternate_uom_code
    , l_parent_mvt_transaction.dispatch_territory_code
    , l_parent_mvt_transaction.destination_territory_code
    , l_parent_mvt_transaction.origin_territory_code
    , l_parent_mvt_transaction.stat_method
    , l_parent_mvt_transaction.stat_adj_percent
    , l_parent_mvt_transaction.stat_adj_amount
    , l_parent_mvt_transaction.stat_ext_value
    , l_parent_mvt_transaction.area
    , l_parent_mvt_transaction.port
    , l_parent_mvt_transaction.stat_type
    , l_parent_mvt_transaction.comments
    , l_parent_mvt_transaction.attribute_category
    , l_parent_mvt_transaction.commodity_code
    , l_parent_mvt_transaction.commodity_description
    , l_parent_mvt_transaction.requisition_header_id
    , l_parent_mvt_transaction.requisition_line_id
    , l_parent_mvt_transaction.picking_line_detail_id
    , l_parent_mvt_transaction.usage_type
    , l_parent_mvt_transaction.zone_code
    , l_parent_mvt_transaction.edi_sent_flag
    , l_parent_mvt_transaction.statistical_procedure_code
    , l_parent_mvt_transaction.movement_amount
    , l_parent_mvt_transaction.triangulation_country_code
    , l_parent_mvt_transaction.csa_code
    , l_parent_mvt_transaction.oil_reference_code
    , l_parent_mvt_transaction.container_type_code
    , l_parent_mvt_transaction.flow_indicator_code
    , l_parent_mvt_transaction.affiliation_reference_code
    , l_parent_mvt_transaction.origin_territory_eu_code
    , l_parent_mvt_transaction.destination_territory_eu_code
    , l_parent_mvt_transaction.dispatch_territory_eu_code
    , l_parent_mvt_transaction.set_of_books_period
    , l_parent_mvt_transaction.taric_code
    , l_parent_mvt_transaction.preference_code
    , l_parent_mvt_transaction.rcv_transaction_id
    , l_parent_mvt_transaction.mtl_transaction_id
    , l_parent_mvt_transaction.total_weight_uom_code
    , l_parent_mvt_transaction.financial_document_flag
    --, l_parent_mvt_transaction.opm_trans_id
    , l_parent_mvt_transaction.customer_vat_number
    , l_parent_mvt_transaction.attribute1
    , l_parent_mvt_transaction.attribute2
    , l_parent_mvt_transaction.attribute3
    , l_parent_mvt_transaction.attribute4
    , l_parent_mvt_transaction.attribute5
    , l_parent_mvt_transaction.attribute6
    , l_parent_mvt_transaction.attribute7
    , l_parent_mvt_transaction.attribute8
    , l_parent_mvt_transaction.attribute9
    , l_parent_mvt_transaction.attribute10
    , l_parent_mvt_transaction.attribute11
    , l_parent_mvt_transaction.attribute12
    , l_parent_mvt_transaction.attribute13
    , l_parent_mvt_transaction.attribute14
    , l_parent_mvt_transaction.attribute15
    , l_parent_mvt_transaction.triangulation_country_eu_code
    , l_parent_mvt_transaction.distribution_line_number
    , l_parent_mvt_transaction.ship_to_name
    , l_parent_mvt_transaction.ship_to_number
    , l_parent_mvt_transaction.ship_to_site
    , l_parent_mvt_transaction.edi_transaction_date
    , l_parent_mvt_transaction.edi_transaction_reference
    , l_parent_mvt_transaction.esl_drop_shipment_code;
Line: 3379

    INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
    ( p_movement_statistics  => l_parent_mvt_transaction
    , x_return_status        => l_return_status
    , x_msg_count            => x_msg_count
    , x_msg_data             => x_msg_data
    );
Line: 3412

END Update_PO_With_RTV;
Line: 3447

  l_insert_flag          VARCHAR2(1);
Line: 3454

  l_insert_status        VARCHAR2(10);
Line: 3460

  l_update_status        VARCHAR2(1);
Line: 3475

    select subinventory
      from rcv_transactions
    where po_header_id        = l_movement_transaction.po_header_id
      and po_line_id          = l_movement_transaction.po_line_id
      and po_line_location_id = l_movement_transaction.po_line_location_id
      and shipment_header_id  = l_shipment_header_id
      and shipment_line_id    = l_shipment_line_id
      and transaction_type    = 'DELIVER';
Line: 3485

  SELECT
    drop_ship_source_id
  FROM
    OE_DROP_SHIP_SOURCES
  WHERE po_header_id        = l_movement_transaction.po_header_id
    AND po_line_id          = l_movement_transaction.po_line_id
    AND line_location_id    = l_movement_transaction.po_line_location_id;
Line: 3494

  SELECT
    vendor_site_id
  FROM
    po_headers_all
  WHERE po_header_id = l_movement_transaction.po_header_id;
Line: 3838

            l_insert_flag := 'N';
Line: 3840

            l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
            ( p_movement_transaction => l_movement_transaction);
Line: 3859

            l_update_status := 'N';
Line: 3861

            IF (NVL(l_insert_flag,'N') = 'Y'
                AND l_par_mvt_id IS NOT NULL
                AND l_par_movement_status IN ('F','X'))
            THEN
              l_insert_flag := 'Y';
Line: 3873

              l_insert_flag := 'N';
Line: 3882

                l_update_status := 'N';
Line: 3884

                l_update_status := 'Y';
Line: 3890

          IF l_insert_flag = 'Y'
          THEN
            INV_MGD_MVT_PO_MDTR.Get_PO_Details
            (p_stat_typ_transaction => l_stat_typ_transaction
            ,x_movement_transaction => l_movement_transaction
            ,x_return_status        => l_return_status
            );
Line: 3946

                    Update_PO_With_RTV
                    ( x_mvt_rtv_transaction => l_movement_transaction
                    , x_return_status       => l_insert_status
                    );
Line: 3957

                    ,x_return_status        => l_insert_status
                  );
Line: 3962

                  IF l_insert_status = FND_API.G_RET_STS_SUCCESS
                  THEN
                    l_movement_id      := l_movement_transaction.movement_id;
Line: 3970

                      g_records_inserted     := g_records_inserted +1;
Line: 4034

                        l_insert_flag := 'N';
Line: 4037

                       l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
                       ( p_movement_transaction => l_movement_transaction);
Line: 4041

                      l_insert_flag := 'N';
Line: 4045

                    IF l_insert_flag = 'Y'
                    THEN
                      INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
                      (p_stat_typ_transaction => l_stat_typ_transaction
                      ,x_movement_transaction => l_movement_transaction
                      ,x_return_status        => l_return_status
                      );
Line: 4083

                          g_records_inserted     := g_records_inserted +1;
Line: 4094

                    END IF; -- end l_insert_flag
Line: 4107

            END IF; -- < end insert>
Line: 4176

                      l_insert_flag := 'N';
Line: 4179

                     l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
                     ( p_movement_transaction => l_movement_transaction);
Line: 4183

                    l_insert_flag := 'N';
Line: 4186

                  l_insert_flag := 'N';
Line: 4190

                IF l_insert_flag = 'Y'
                THEN
                  INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
                  (p_stat_typ_transaction => l_stat_typ_transaction
                  ,x_movement_transaction => l_movement_transaction
                  ,x_return_status        => l_return_status
                  );
Line: 4219

                    ,x_return_status        => l_insert_status
                    );
Line: 4223

                    IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) =
                       FND_API.G_RET_STS_SUCCESS
                    THEN
                      l_movement_id := l_movement_transaction.movement_id;
Line: 4227

                      g_records_inserted     := g_records_inserted +1;
Line: 4240

                END IF;  --end insert flag Y
Line: 4250

          END IF; --end if for l_insert_flag
Line: 4262

        IF (NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
             OR l_update_status = 'Y')
        THEN
          l_movement_transaction.movement_id := l_movement_id;
Line: 4267

          INV_MGD_MVT_PO_MDTR.Update_PO_Transactions
          (  p_movement_transaction => l_movement_transaction
           , p_mvt_stat_status      => NULL
           , x_return_status        => l_return_status
           );
Line: 4343

PROCEDURE Update_SO_With_RMA
( x_mvt_rma_transaction IN OUT  NOCOPY
    INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
, x_return_status        OUT NOCOPY VARCHAR2
)
IS
l_parent_mvt_id          NUMBER;
Line: 4355

l_api_name CONSTANT      VARCHAR2(30) := 'Update_SO_With_RMA';
Line: 4359

SELECT
  mms.movement_id
, mms.movement_status
FROM
  mtl_movement_statistics mms
, oe_order_lines_all oola
WHERE mms.order_header_id = oola.reference_header_id
  AND mms.order_line_id   = oola.reference_line_id
  AND oola.line_id        = x_mvt_rma_transaction.order_line_id
  AND mms.entity_org_id   = x_mvt_rma_transaction.entity_org_id
  AND mms.zone_code       = x_mvt_rma_transaction.zone_code
  AND mms.usage_type      = x_mvt_rma_transaction.usage_type
  AND mms.stat_type       = x_mvt_rma_transaction.stat_type
  AND mms.movement_type   <> 'DA';
Line: 4375

SELECT
  movement_id
, organization_id
, entity_org_id
, movement_type
, movement_status
, transaction_date
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, document_source_type
, creation_method
, document_reference
, document_line_reference
, document_unit_price
, document_line_ext_value
, receipt_reference
, shipment_reference
, shipment_line_reference
, pick_slip_reference
, customer_name
, customer_number
, customer_location
, transacting_from_org
, transacting_to_org
, vendor_name
, vendor_number
, vendor_site
, bill_to_name
, bill_to_number
, bill_to_site
, po_header_id
, po_line_id
, po_line_location_id
, order_header_id
, order_line_id
, picking_line_id
, shipment_header_id
, shipment_line_id
, ship_to_customer_id
, ship_to_site_use_id
, bill_to_customer_id
, bill_to_site_use_id
, vendor_id
, vendor_site_id
, from_organization_id
, to_organization_id
, parent_movement_id
, inventory_item_id
, item_description
, item_cost
, transaction_quantity
, transaction_uom_code
, primary_quantity
, invoice_batch_id
, invoice_id
, customer_trx_line_id
, invoice_batch_reference
, invoice_reference
, invoice_line_reference
, invoice_date_reference
, invoice_quantity
, invoice_unit_price
, invoice_line_ext_value
, outside_code
, outside_ext_value
, outside_unit_price
, currency_code
, currency_conversion_rate
, currency_conversion_type
, currency_conversion_date
, period_name
, report_reference
, report_date
, category_id
, weight_method
, unit_weight
, total_weight
, transaction_nature
, delivery_terms
, transport_mode
, alternate_quantity
, alternate_uom_code
, dispatch_territory_code
, destination_territory_code
, origin_territory_code
, stat_method
, stat_adj_percent
, stat_adj_amount
, stat_ext_value
, area
, port
, stat_type
, comments
, attribute_category
, commodity_code
, commodity_description
, requisition_header_id
, requisition_line_id
, picking_line_detail_id
, usage_type
, zone_code
, edi_sent_flag
, statistical_procedure_code
, movement_amount
, triangulation_country_code
, csa_code
, oil_reference_code
, container_type_code
, flow_indicator_code
, affiliation_reference_code
, origin_territory_eu_code
, destination_territory_eu_code
, dispatch_territory_eu_code
, set_of_books_period
, taric_code
, preference_code
, rcv_transaction_id
, mtl_transaction_id
, total_weight_uom_code
, financial_document_flag
--, opm_trans_id
, customer_vat_number
, attribute1
, attribute2
, attribute3
, attribute4
, attribute5
, attribute6
, attribute7
, attribute8
, attribute9
, attribute10
, attribute11
, attribute12
, attribute13
, attribute14
, attribute15
, triangulation_country_eu_code
, distribution_line_number
, ship_to_name
, ship_to_number
, ship_to_site
, edi_transaction_date
, edi_transaction_reference
, esl_drop_shipment_code
FROM
  mtl_movement_statistics
WHERE movement_id = l_parent_mvt_id;
Line: 4603

    , l_parent_mvt_transaction.last_update_date
    , l_parent_mvt_transaction.last_updated_by
    , l_parent_mvt_transaction.creation_date
    , l_parent_mvt_transaction.created_by
    , l_parent_mvt_transaction.last_update_login
    , l_parent_mvt_transaction.document_source_type
    , l_parent_mvt_transaction.creation_method
    , l_parent_mvt_transaction.document_reference
    , l_parent_mvt_transaction.document_line_reference
    , l_parent_mvt_transaction.document_unit_price
    , l_parent_mvt_transaction.document_line_ext_value
    , l_parent_mvt_transaction.receipt_reference
    , l_parent_mvt_transaction.shipment_reference
    , l_parent_mvt_transaction.shipment_line_reference
    , l_parent_mvt_transaction.pick_slip_reference
    , l_parent_mvt_transaction.customer_name
    , l_parent_mvt_transaction.customer_number
    , l_parent_mvt_transaction.customer_location
    , l_parent_mvt_transaction.transacting_from_org
    , l_parent_mvt_transaction.transacting_to_org
    , l_parent_mvt_transaction.vendor_name
    , l_parent_mvt_transaction.vendor_number
    , l_parent_mvt_transaction.vendor_site
    , l_parent_mvt_transaction.bill_to_name
    , l_parent_mvt_transaction.bill_to_number
    , l_parent_mvt_transaction.bill_to_site
    , l_parent_mvt_transaction.po_header_id
    , l_parent_mvt_transaction.po_line_id
    , l_parent_mvt_transaction.po_line_location_id
    , l_parent_mvt_transaction.order_header_id
    , l_parent_mvt_transaction.order_line_id
    , l_parent_mvt_transaction.picking_line_id
    , l_parent_mvt_transaction.shipment_header_id
    , l_parent_mvt_transaction.shipment_line_id
    , l_parent_mvt_transaction.ship_to_customer_id
    , l_parent_mvt_transaction.ship_to_site_use_id
    , l_parent_mvt_transaction.bill_to_customer_id
    , l_parent_mvt_transaction.bill_to_site_use_id
    , l_parent_mvt_transaction.vendor_id
    , l_parent_mvt_transaction.vendor_site_id
    , l_parent_mvt_transaction.from_organization_id
    , l_parent_mvt_transaction.to_organization_id
    , l_parent_mvt_transaction.parent_movement_id
    , l_parent_mvt_transaction.inventory_item_id
    , l_parent_mvt_transaction.item_description
    , l_parent_mvt_transaction.item_cost
    , l_parent_mvt_transaction.transaction_quantity
    , l_parent_mvt_transaction.transaction_uom_code
    , l_parent_mvt_transaction.primary_quantity
    , l_parent_mvt_transaction.invoice_batch_id
    , l_parent_mvt_transaction.invoice_id
    , l_parent_mvt_transaction.customer_trx_line_id
    , l_parent_mvt_transaction.invoice_batch_reference
    , l_parent_mvt_transaction.invoice_reference
    , l_parent_mvt_transaction.invoice_line_reference
    , l_parent_mvt_transaction.invoice_date_reference
    , l_parent_mvt_transaction.invoice_quantity
    , l_parent_mvt_transaction.invoice_unit_price
    , l_parent_mvt_transaction.invoice_line_ext_value
    , l_parent_mvt_transaction.outside_code
    , l_parent_mvt_transaction.outside_ext_value
    , l_parent_mvt_transaction.outside_unit_price
    , l_parent_mvt_transaction.currency_code
    , l_parent_mvt_transaction.currency_conversion_rate
    , l_parent_mvt_transaction.currency_conversion_type
    , l_parent_mvt_transaction.currency_conversion_date
    , l_parent_mvt_transaction.period_name
    , l_parent_mvt_transaction.report_reference
    , l_parent_mvt_transaction.report_date
    , l_parent_mvt_transaction.category_id
    , l_parent_mvt_transaction.weight_method
    , l_parent_mvt_transaction.unit_weight
    , l_parent_mvt_transaction.total_weight
    , l_parent_mvt_transaction.transaction_nature
    , l_parent_mvt_transaction.delivery_terms
    , l_parent_mvt_transaction.transport_mode
    , l_parent_mvt_transaction.alternate_quantity
    , l_parent_mvt_transaction.alternate_uom_code
    , l_parent_mvt_transaction.dispatch_territory_code
    , l_parent_mvt_transaction.destination_territory_code
    , l_parent_mvt_transaction.origin_territory_code
    , l_parent_mvt_transaction.stat_method
    , l_parent_mvt_transaction.stat_adj_percent
    , l_parent_mvt_transaction.stat_adj_amount
    , l_parent_mvt_transaction.stat_ext_value
    , l_parent_mvt_transaction.area
    , l_parent_mvt_transaction.port
    , l_parent_mvt_transaction.stat_type
    , l_parent_mvt_transaction.comments
    , l_parent_mvt_transaction.attribute_category
    , l_parent_mvt_transaction.commodity_code
    , l_parent_mvt_transaction.commodity_description
    , l_parent_mvt_transaction.requisition_header_id
    , l_parent_mvt_transaction.requisition_line_id
    , l_parent_mvt_transaction.picking_line_detail_id
    , l_parent_mvt_transaction.usage_type
    , l_parent_mvt_transaction.zone_code
    , l_parent_mvt_transaction.edi_sent_flag
    , l_parent_mvt_transaction.statistical_procedure_code
    , l_parent_mvt_transaction.movement_amount
    , l_parent_mvt_transaction.triangulation_country_code
    , l_parent_mvt_transaction.csa_code
    , l_parent_mvt_transaction.oil_reference_code
    , l_parent_mvt_transaction.container_type_code
    , l_parent_mvt_transaction.flow_indicator_code
    , l_parent_mvt_transaction.affiliation_reference_code
    , l_parent_mvt_transaction.origin_territory_eu_code
    , l_parent_mvt_transaction.destination_territory_eu_code
    , l_parent_mvt_transaction.dispatch_territory_eu_code
    , l_parent_mvt_transaction.set_of_books_period
    , l_parent_mvt_transaction.taric_code
    , l_parent_mvt_transaction.preference_code
    , l_parent_mvt_transaction.rcv_transaction_id
    , l_parent_mvt_transaction.mtl_transaction_id
    , l_parent_mvt_transaction.total_weight_uom_code
    , l_parent_mvt_transaction.financial_document_flag
    --, l_parent_mvt_transaction.opm_trans_id
    , l_parent_mvt_transaction.customer_vat_number
    , l_parent_mvt_transaction.attribute1
    , l_parent_mvt_transaction.attribute2
    , l_parent_mvt_transaction.attribute3
    , l_parent_mvt_transaction.attribute4
    , l_parent_mvt_transaction.attribute5
    , l_parent_mvt_transaction.attribute6
    , l_parent_mvt_transaction.attribute7
    , l_parent_mvt_transaction.attribute8
    , l_parent_mvt_transaction.attribute9
    , l_parent_mvt_transaction.attribute10
    , l_parent_mvt_transaction.attribute11
    , l_parent_mvt_transaction.attribute12
    , l_parent_mvt_transaction.attribute13
    , l_parent_mvt_transaction.attribute14
    , l_parent_mvt_transaction.attribute15
    , l_parent_mvt_transaction.triangulation_country_eu_code
    , l_parent_mvt_transaction.distribution_line_number
    , l_parent_mvt_transaction.ship_to_name
    , l_parent_mvt_transaction.ship_to_number
    , l_parent_mvt_transaction.ship_to_site
    , l_parent_mvt_transaction.edi_transaction_date
    , l_parent_mvt_transaction.edi_transaction_reference
    , l_parent_mvt_transaction.esl_drop_shipment_code;
Line: 4810

    INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
    ( p_movement_statistics  => l_parent_mvt_transaction
    , x_return_status        => l_return_status
    , x_msg_count            => x_msg_count
    , x_msg_data             => x_msg_data
    );
Line: 4843

END Update_SO_With_RMA;
Line: 4877

  l_insert_flag          VARCHAR2(1);
Line: 4883

  l_insert_status        VARCHAR2(10);
Line: 4903

  l_insert               VARCHAR2(1);-- 7165989
Line: 4908

  SELECT
    oola2.item_type_code
  FROM
    oe_order_lines_all oola1
  , oe_order_lines_all oola2
  WHERE oola1.line_id = l_movement_transaction.order_line_id
    AND oola2.line_id = oola1.reference_line_id;
Line: 4982

                          SELECT  ooha.order_number order_number
                          INTO  l_movement_transaction.order_number
                          FROM OE_ORDER_HEADERS_ALL ooha
                          WHERE ooha.header_id= l_movement_transaction.order_header_id;
Line: 5220

        l_insert_flag := 'N';
Line: 5250

              l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
                               ( p_movement_transaction => l_movement_transaction);
Line: 5263

                               ',l_insert_flag:' || l_insert_flag ||
                               ',l_process_flag:' || l_process_flag
                              );
Line: 5268

              IF (l_insert_flag = 'Y' ) THEN
                Process_RMA_Triangulation
                ( p_movement_transaction => l_movement_transaction
                , p_stat_typ_transaction => l_stat_typ_transaction
                , x_return_status        =>  x_return_status
                );
Line: 5286

                FND_FILE.put_line (FND_FILE.log  ,'mvt stat status after update'||l_mvt_stat_status );
Line: 5298

              ELSIF (l_insert_flag = 'N') THEN
                l_dispatch :=
                  INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.sold_from_org_id);
Line: 5346

                      l_insert := 'Y';
Line: 5348

                      l_insert := 'N';
Line: 5355

                       l_insert_flag := 'N';
Line: 5360

                      l_insert := 'Y';
Line: 5362

                      l_insert := 'N';
Line: 5365

                    l_insert := 'N';
Line: 5373

                                  ,'l_insert:' || l_insert
                                  );
Line: 5377

                  if (l_insert = 'Y') THEN

                          Process_RMA_Triangulation
                          ( p_movement_transaction => l_movement_transaction
                          , p_stat_typ_transaction => l_stat_typ_transaction
                          , x_return_status        =>  x_return_status
                          );
Line: 5397

                          FND_FILE.put_line (FND_FILE.log  ,'mvt stat status after update'||l_mvt_stat_status );
Line: 5410

              END IF;  --l_insert_flag = 'N'
Line: 5446

                l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
                                 ( p_movement_transaction => l_movement_transaction);
Line: 5456

                              ,'l_insert_flag:' || l_insert_flag
                              );
Line: 5504

                l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
                                 ( p_movement_transaction => l_movement_transaction);
Line: 5512

                                ,'l_insert_flag:' || l_insert_flag ||
                                 ':mvt_status:' || l_mvt_stat_status
                                );
Line: 5521

              IF (l_insert_flag  = 'Y') THEN
                IF (l_mvt_stat_status is NOT NULL AND l_mvt_stat_status = 'NEW') THEN
                    l_mvt_stat_status := 'FORDISP';
Line: 5569

            l_insert_flag := INV_MGD_MVT_SETUP_MDTR.Process_Setup_Context
                           ( p_movement_transaction => l_movement_transaction);
Line: 5576

                            ,'l_insert_flag:' || l_insert_flag
                            );
Line: 5588

                        ,'l_insert_flag:' || l_insert_flag ||
                         ':l_return_status:' || l_return_status
                        );
Line: 5593

        IF (l_insert_flag = 'Y' AND l_return_status = 'Y')
        THEN
          l_process_flag := 'Y';
Line: 5633

              Update_SO_With_RMA
              ( x_mvt_rma_transaction => l_movement_transaction
              , x_return_status       => l_insert_status
              );
Line: 5644

              ,x_return_status        => l_insert_status
              );
Line: 5649

            IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
               AND l_movement_transaction.movement_id IS NOT NULL
            THEN
              l_movement_id      := l_movement_transaction.movement_id;
Line: 5653

              g_records_inserted     := g_records_inserted +1;
Line: 5676

    IF NVL(l_insert_status,FND_API.G_RET_STS_SUCCESS) = FND_API.G_RET_STS_SUCCESS
    THEN
      l_movement_transaction.movement_id := l_movement_id;
Line: 5691

        INV_MGD_MVT_PO_MDTR.Update_PO_Transactions
        ( p_movement_transaction => l_movement_transaction
         , p_mvt_stat_status      => l_mvt_stat_status /* 7165989 - Pass the appropriate mvt_stat_status for RMA triangulation txns */
        , x_return_status        => l_return_status
         );
Line: 5772

PROCEDURE Update_Invoice_Info
( p_movement_transaction IN
    INV_MGD_MVT_DATA_STR.Movement_Transaction_Rec_Type
, p_start_date           IN  DATE
, p_end_date             IN  DATE
, p_transaction_type     IN  VARCHAR2
, x_return_status        OUT NOCOPY VARCHAR2
)
IS
  -- Declare the REF Cursor
  inv_crsr               INV_MGD_MVT_DATA_STR.invCurTyp;
Line: 5786

  l_insert_flag          VARCHAR2(1);
Line: 5789

  l_insert_status        VARCHAR2(10);
Line: 5792

  l_api_name CONSTANT    VARCHAR2(30) := 'Update_Invoice_Info';
Line: 5830

    , l_movement_transaction.last_update_date
    , l_movement_transaction.last_updated_by
    , l_movement_transaction.creation_date
    , l_movement_transaction.created_by
    , l_movement_transaction.last_update_login
    , l_movement_transaction.document_source_type
    , l_movement_transaction.creation_method
    , l_movement_transaction.document_reference
    , l_movement_transaction.document_line_reference
    , l_movement_transaction.document_unit_price
    , l_movement_transaction.document_line_ext_value
    , l_movement_transaction.receipt_reference
    , l_movement_transaction.shipment_reference
    , l_movement_transaction.shipment_line_reference
    , l_movement_transaction.pick_slip_reference
    , l_movement_transaction.customer_name
    , l_movement_transaction.customer_number
    , l_movement_transaction.customer_location
    , l_movement_transaction.transacting_from_org
    , l_movement_transaction.transacting_to_org
    , l_movement_transaction.vendor_name
    , l_movement_transaction.vendor_number
    , l_movement_transaction.vendor_site
    , l_movement_transaction.bill_to_name
    , l_movement_transaction.bill_to_number
    , l_movement_transaction.bill_to_site
    , l_movement_transaction.po_header_id
    , l_movement_transaction.po_line_id
    , l_movement_transaction.po_line_location_id
    , l_movement_transaction.order_header_id
    , l_movement_transaction.order_line_id
    , l_movement_transaction.picking_line_id
    , l_movement_transaction.shipment_header_id
    , l_movement_transaction.shipment_line_id
    , l_movement_transaction.ship_to_customer_id
    , l_movement_transaction.ship_to_site_use_id
    , l_movement_transaction.bill_to_customer_id
    , l_movement_transaction.bill_to_site_use_id
    , l_movement_transaction.vendor_id
    , l_movement_transaction.vendor_site_id
    , l_movement_transaction.from_organization_id
    , l_movement_transaction.to_organization_id
    , l_movement_transaction.parent_movement_id
    , l_movement_transaction.inventory_item_id
    , l_movement_transaction.item_description
    , l_movement_transaction.item_cost
    , l_movement_transaction.transaction_quantity
    , l_movement_transaction.transaction_uom_code
    , l_movement_transaction.primary_quantity
    , l_movement_transaction.invoice_batch_id
    , l_movement_transaction.invoice_id
    , l_movement_transaction.customer_trx_line_id
    , l_movement_transaction.invoice_batch_reference
    , l_movement_transaction.invoice_reference
    , l_movement_transaction.invoice_line_reference
    , l_movement_transaction.invoice_date_reference
    , l_movement_transaction.invoice_quantity
    , l_movement_transaction.invoice_unit_price
    , l_movement_transaction.invoice_line_ext_value
    , l_movement_transaction.outside_code
    , l_movement_transaction.outside_ext_value
    , l_movement_transaction.outside_unit_price
    , l_movement_transaction.currency_code
    , l_movement_transaction.currency_conversion_rate
    , l_movement_transaction.currency_conversion_type
    , l_movement_transaction.currency_conversion_date
    , l_movement_transaction.period_name
    , l_movement_transaction.report_reference
    , l_movement_transaction.report_date
    , l_movement_transaction.category_id
    , l_movement_transaction.weight_method
    , l_movement_transaction.unit_weight
    , l_movement_transaction.total_weight
    , l_movement_transaction.transaction_nature
    , l_movement_transaction.delivery_terms
    , l_movement_transaction.transport_mode
    , l_movement_transaction.alternate_quantity
    , l_movement_transaction.alternate_uom_code
    , l_movement_transaction.dispatch_territory_code
    , l_movement_transaction.destination_territory_code
    , l_movement_transaction.origin_territory_code
    , l_movement_transaction.stat_method
    , l_movement_transaction.stat_adj_percent
    , l_movement_transaction.stat_adj_amount
    , l_movement_transaction.stat_ext_value
    , l_movement_transaction.area
    , l_movement_transaction.port
    , l_movement_transaction.stat_type
    , l_movement_transaction.comments
    , l_movement_transaction.attribute_category
    , l_movement_transaction.commodity_code
    , l_movement_transaction.commodity_description
    , l_movement_transaction.requisition_header_id
    , l_movement_transaction.requisition_line_id
    , l_movement_transaction.picking_line_detail_id
    , l_movement_transaction.usage_type
    , l_movement_transaction.zone_code
    , l_movement_transaction.edi_sent_flag
    , l_movement_transaction.statistical_procedure_code
    , l_movement_transaction.movement_amount
    , l_movement_transaction.triangulation_country_code
    , l_movement_transaction.csa_code
    , l_movement_transaction.oil_reference_code
    , l_movement_transaction.container_type_code
    , l_movement_transaction.flow_indicator_code
    , l_movement_transaction.affiliation_reference_code
    , l_movement_transaction.origin_territory_eu_code
    , l_movement_transaction.destination_territory_eu_code
    , l_movement_transaction.dispatch_territory_eu_code
    , l_movement_transaction.set_of_books_period
    , l_movement_transaction.taric_code
    , l_movement_transaction.preference_code
    , l_movement_transaction.rcv_transaction_id
    , l_movement_transaction.mtl_transaction_id
    , l_movement_transaction.total_weight_uom_code
    , l_movement_transaction.financial_document_flag
    --, l_movement_transaction.opm_trans_id
    , l_movement_transaction.customer_vat_number
    , l_movement_transaction.attribute1
    , l_movement_transaction.attribute2
    , l_movement_transaction.attribute3
    , l_movement_transaction.attribute4
    , l_movement_transaction.attribute5
    , l_movement_transaction.attribute6
    , l_movement_transaction.attribute7
    , l_movement_transaction.attribute8
    , l_movement_transaction.attribute9
    , l_movement_transaction.attribute10
    , l_movement_transaction.attribute11
    , l_movement_transaction.attribute12
    , l_movement_transaction.attribute13
    , l_movement_transaction.attribute14
    , l_movement_transaction.attribute15
    , l_movement_transaction.triangulation_country_eu_code
    , l_movement_transaction.distribution_line_number
    , l_movement_transaction.ship_to_name
    , l_movement_transaction.ship_to_number
    , l_movement_transaction.ship_to_site
    , l_movement_transaction.edi_transaction_date
    , l_movement_transaction.edi_transaction_reference
    , l_movement_transaction.esl_drop_shipment_code;
Line: 6048

      INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
       (p_movement_statistics  => l_movement_transaction
      , x_return_status        => l_return_status
      , x_msg_count            => x_msg_count
      , x_msg_data             => x_msg_data
      );
Line: 6111

END Update_Invoice_Info;
Line: 6127

PROCEDURE Update_PO_With_Correction
( p_legal_entity_id      IN  NUMBER
, p_start_date           IN  DATE
, p_end_date             IN  DATE
, p_transaction_type     IN  VARCHAR2
, x_return_status        OUT NOCOPY VARCHAR2
)
IS
  -- Declare the REF Cursor
  inv_crsr                 INV_MGD_MVT_DATA_STR.invCurTyp;
Line: 6147

  l_api_name CONSTANT      VARCHAR2(30) := 'Update_PO_With_Correction';
Line: 6152

  SELECT
    SUM(quantity)
  , SUM(primary_quantity)
  FROM
    rcv_transactions
  WHERE parent_transaction_id = l_movement_transaction.rcv_transaction_id
    AND mvt_stat_status = 'NEW'
    AND transaction_type = 'CORRECT';
Line: 6191

    , l_movement_transaction.last_update_date
    , l_movement_transaction.last_updated_by
    , l_movement_transaction.creation_date
    , l_movement_transaction.created_by
    , l_movement_transaction.last_update_login
    , l_movement_transaction.document_source_type
    , l_movement_transaction.creation_method
    , l_movement_transaction.document_reference
    , l_movement_transaction.document_line_reference
    , l_movement_transaction.document_unit_price
    , l_movement_transaction.document_line_ext_value
    , l_movement_transaction.receipt_reference
    , l_movement_transaction.shipment_reference
    , l_movement_transaction.shipment_line_reference
    , l_movement_transaction.pick_slip_reference
    , l_movement_transaction.customer_name
    , l_movement_transaction.customer_number
    , l_movement_transaction.customer_location
    , l_movement_transaction.transacting_from_org
    , l_movement_transaction.transacting_to_org
    , l_movement_transaction.vendor_name
    , l_movement_transaction.vendor_number
    , l_movement_transaction.vendor_site
    , l_movement_transaction.bill_to_name
    , l_movement_transaction.bill_to_number
    , l_movement_transaction.bill_to_site
    , l_movement_transaction.po_header_id
    , l_movement_transaction.po_line_id
    , l_movement_transaction.po_line_location_id
    , l_movement_transaction.order_header_id
    , l_movement_transaction.order_line_id
    , l_movement_transaction.picking_line_id
    , l_movement_transaction.shipment_header_id
    , l_movement_transaction.shipment_line_id
    , l_movement_transaction.ship_to_customer_id
    , l_movement_transaction.ship_to_site_use_id
    , l_movement_transaction.bill_to_customer_id
    , l_movement_transaction.bill_to_site_use_id
    , l_movement_transaction.vendor_id
    , l_movement_transaction.vendor_site_id
    , l_movement_transaction.from_organization_id
    , l_movement_transaction.to_organization_id
    , l_movement_transaction.parent_movement_id
    , l_movement_transaction.inventory_item_id
    , l_movement_transaction.item_description
    , l_movement_transaction.item_cost
    , l_movement_transaction.transaction_quantity
    , l_movement_transaction.transaction_uom_code
    , l_movement_transaction.primary_quantity
    , l_movement_transaction.invoice_batch_id
    , l_movement_transaction.invoice_id
    , l_movement_transaction.customer_trx_line_id
    , l_movement_transaction.invoice_batch_reference
    , l_movement_transaction.invoice_reference
    , l_movement_transaction.invoice_line_reference
    , l_movement_transaction.invoice_date_reference
    , l_movement_transaction.invoice_quantity
    , l_movement_transaction.invoice_unit_price
    , l_movement_transaction.invoice_line_ext_value
    , l_movement_transaction.outside_code
    , l_movement_transaction.outside_ext_value
    , l_movement_transaction.outside_unit_price
    , l_movement_transaction.currency_code
    , l_movement_transaction.currency_conversion_rate
    , l_movement_transaction.currency_conversion_type
    , l_movement_transaction.currency_conversion_date
    , l_movement_transaction.period_name
    , l_movement_transaction.report_reference
    , l_movement_transaction.report_date
    , l_movement_transaction.category_id
    , l_movement_transaction.weight_method
    , l_movement_transaction.unit_weight
    , l_movement_transaction.total_weight
    , l_movement_transaction.transaction_nature
    , l_movement_transaction.delivery_terms
    , l_movement_transaction.transport_mode
    , l_movement_transaction.alternate_quantity
    , l_movement_transaction.alternate_uom_code
    , l_movement_transaction.dispatch_territory_code
    , l_movement_transaction.destination_territory_code
    , l_movement_transaction.origin_territory_code
    , l_movement_transaction.stat_method
    , l_movement_transaction.stat_adj_percent
    , l_movement_transaction.stat_adj_amount
    , l_movement_transaction.stat_ext_value
    , l_movement_transaction.area
    , l_movement_transaction.port
    , l_movement_transaction.stat_type
    , l_movement_transaction.comments
    , l_movement_transaction.attribute_category
    , l_movement_transaction.commodity_code
    , l_movement_transaction.commodity_description
    , l_movement_transaction.requisition_header_id
    , l_movement_transaction.requisition_line_id
    , l_movement_transaction.picking_line_detail_id
    , l_movement_transaction.usage_type
    , l_movement_transaction.zone_code
    , l_movement_transaction.edi_sent_flag
    , l_movement_transaction.statistical_procedure_code
    , l_movement_transaction.movement_amount
    , l_movement_transaction.triangulation_country_code
    , l_movement_transaction.csa_code
    , l_movement_transaction.oil_reference_code
    , l_movement_transaction.container_type_code
    , l_movement_transaction.flow_indicator_code
    , l_movement_transaction.affiliation_reference_code
    , l_movement_transaction.origin_territory_eu_code
    , l_movement_transaction.destination_territory_eu_code
    , l_movement_transaction.dispatch_territory_eu_code
    , l_movement_transaction.set_of_books_period
    , l_movement_transaction.taric_code
    , l_movement_transaction.preference_code
    , l_movement_transaction.rcv_transaction_id
    , l_movement_transaction.mtl_transaction_id
    , l_movement_transaction.total_weight_uom_code
    , l_movement_transaction.financial_document_flag
    --, l_movement_transaction.opm_trans_id
    , l_movement_transaction.customer_vat_number
    , l_movement_transaction.attribute1
    , l_movement_transaction.attribute2
    , l_movement_transaction.attribute3
    , l_movement_transaction.attribute4
    , l_movement_transaction.attribute5
    , l_movement_transaction.attribute6
    , l_movement_transaction.attribute7
    , l_movement_transaction.attribute8
    , l_movement_transaction.attribute9
    , l_movement_transaction.attribute10
    , l_movement_transaction.attribute11
    , l_movement_transaction.attribute12
    , l_movement_transaction.attribute13
    , l_movement_transaction.attribute14
    , l_movement_transaction.attribute15
    , l_movement_transaction.triangulation_country_eu_code
    , l_movement_transaction.distribution_line_number
    , l_movement_transaction.ship_to_name
    , l_movement_transaction.ship_to_number
    , l_movement_transaction.ship_to_site
    , l_movement_transaction.edi_transaction_date
    , l_movement_transaction.edi_transaction_reference
    , l_movement_transaction.esl_drop_shipment_code;
Line: 6411

    INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
    ( p_movement_statistics  => l_movement_transaction
    , x_return_status        => l_return_status
    , x_msg_count            => x_msg_count
    , x_msg_data             => x_msg_data
    );
Line: 6420

      UPDATE rcv_transactions
      SET
        mvt_stat_status   = 'PROCESSED'
      , movement_id       = l_movement_transaction.movement_id
      WHERE mvt_stat_status = 'NEW'
        AND transaction_type = 'CORRECT'
        AND parent_transaction_id  = l_movement_transaction.rcv_transaction_id;
Line: 6483

END Update_PO_With_Correction;
Line: 6513

  l_insert_flag          VARCHAR2(1);
Line: 6516

  l_insert_status        VARCHAR2(10);
Line: 6556

    , l_movement_transaction.last_update_date
    , l_movement_transaction.last_updated_by
    , l_movement_transaction.creation_date
    , l_movement_transaction.created_by
    , l_movement_transaction.last_update_login
    , l_movement_transaction.document_source_type
    , l_movement_transaction.creation_method
    , l_movement_transaction.document_reference
    , l_movement_transaction.document_line_reference
    , l_movement_transaction.document_unit_price
    , l_movement_transaction.document_line_ext_value
    , l_movement_transaction.receipt_reference
    , l_movement_transaction.shipment_reference
    , l_movement_transaction.shipment_line_reference
    , l_movement_transaction.pick_slip_reference
    , l_movement_transaction.customer_name
    , l_movement_transaction.customer_number
    , l_movement_transaction.customer_location
    , l_movement_transaction.transacting_from_org
    , l_movement_transaction.transacting_to_org
    , l_movement_transaction.vendor_name
    , l_movement_transaction.vendor_number
    , l_movement_transaction.vendor_site
    , l_movement_transaction.bill_to_name
    , l_movement_transaction.bill_to_number
    , l_movement_transaction.bill_to_site
    , l_movement_transaction.po_header_id
    , l_movement_transaction.po_line_id
    , l_movement_transaction.po_line_location_id
    , l_movement_transaction.order_header_id
    , l_movement_transaction.order_line_id
    , l_movement_transaction.picking_line_id
    , l_movement_transaction.shipment_header_id
    , l_movement_transaction.shipment_line_id
    , l_movement_transaction.ship_to_customer_id
    , l_movement_transaction.ship_to_site_use_id
    , l_movement_transaction.bill_to_customer_id
    , l_movement_transaction.bill_to_site_use_id
    , l_movement_transaction.vendor_id
    , l_movement_transaction.vendor_site_id
    , l_movement_transaction.from_organization_id
    , l_movement_transaction.to_organization_id
    , l_movement_transaction.parent_movement_id
    , l_movement_transaction.inventory_item_id
    , l_movement_transaction.item_description
    , l_movement_transaction.item_cost
    , l_movement_transaction.transaction_quantity
    , l_movement_transaction.transaction_uom_code
    , l_movement_transaction.primary_quantity
    , l_movement_transaction.invoice_batch_id
    , l_movement_transaction.invoice_id
    , l_movement_transaction.customer_trx_line_id
    , l_movement_transaction.invoice_batch_reference
    , l_movement_transaction.invoice_reference
    , l_movement_transaction.invoice_line_reference
    , l_movement_transaction.invoice_date_reference
    , l_movement_transaction.invoice_quantity
    , l_movement_transaction.invoice_unit_price
    , l_movement_transaction.invoice_line_ext_value
    , l_movement_transaction.outside_code
    , l_movement_transaction.outside_ext_value
    , l_movement_transaction.outside_unit_price
    , l_movement_transaction.currency_code
    , l_movement_transaction.currency_conversion_rate
    , l_movement_transaction.currency_conversion_type
    , l_movement_transaction.currency_conversion_date
    , l_movement_transaction.period_name
    , l_movement_transaction.report_reference
    , l_movement_transaction.report_date
    , l_movement_transaction.category_id
    , l_movement_transaction.weight_method
    , l_movement_transaction.unit_weight
    , l_movement_transaction.total_weight
    , l_movement_transaction.transaction_nature
    , l_movement_transaction.delivery_terms
    , l_movement_transaction.transport_mode
    , l_movement_transaction.alternate_quantity
    , l_movement_transaction.alternate_uom_code
    , l_movement_transaction.dispatch_territory_code
    , l_movement_transaction.destination_territory_code
    , l_movement_transaction.origin_territory_code
    , l_movement_transaction.stat_method
    , l_movement_transaction.stat_adj_percent
    , l_movement_transaction.stat_adj_amount
    , l_movement_transaction.stat_ext_value
    , l_movement_transaction.area
    , l_movement_transaction.port
    , l_movement_transaction.stat_type
    , l_movement_transaction.comments
    , l_movement_transaction.attribute_category
    , l_movement_transaction.commodity_code
    , l_movement_transaction.commodity_description
    , l_movement_transaction.requisition_header_id
    , l_movement_transaction.requisition_line_id
    , l_movement_transaction.picking_line_detail_id
    , l_movement_transaction.usage_type
    , l_movement_transaction.zone_code
    , l_movement_transaction.edi_sent_flag
    , l_movement_transaction.statistical_procedure_code
    , l_movement_transaction.movement_amount
    , l_movement_transaction.triangulation_country_code
    , l_movement_transaction.csa_code
    , l_movement_transaction.oil_reference_code
    , l_movement_transaction.container_type_code
    , l_movement_transaction.flow_indicator_code
    , l_movement_transaction.affiliation_reference_code
    , l_movement_transaction.origin_territory_eu_code
    , l_movement_transaction.destination_territory_eu_code
    , l_movement_transaction.dispatch_territory_eu_code
    , l_movement_transaction.set_of_books_period
    , l_movement_transaction.taric_code
    , l_movement_transaction.preference_code
    , l_movement_transaction.rcv_transaction_id
    , l_movement_transaction.mtl_transaction_id
    , l_movement_transaction.total_weight_uom_code
    , l_movement_transaction.financial_document_flag
    --, l_movement_transaction.opm_trans_id
    , l_movement_transaction.customer_vat_number
    , l_movement_transaction.attribute1
    , l_movement_transaction.attribute2
    , l_movement_transaction.attribute3
    , l_movement_transaction.attribute4
    , l_movement_transaction.attribute5
    , l_movement_transaction.attribute6
    , l_movement_transaction.attribute7
    , l_movement_transaction.attribute8
    , l_movement_transaction.attribute9
    , l_movement_transaction.attribute10
    , l_movement_transaction.attribute11
    , l_movement_transaction.attribute12
    , l_movement_transaction.attribute13
    , l_movement_transaction.attribute14
    , l_movement_transaction.attribute15
    , l_movement_transaction.triangulation_country_eu_code
    , l_movement_transaction.distribution_line_number
    , l_movement_transaction.ship_to_name
    , l_movement_transaction.ship_to_number
    , l_movement_transaction.ship_to_site
    , l_movement_transaction.edi_transaction_date
    , l_movement_transaction.edi_transaction_reference
    , l_movement_transaction.esl_drop_shipment_code;
Line: 6806

        INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
        (p_movement_statistics  => l_movement_transaction
        , x_return_status        => l_return_status
        , x_msg_count            => x_msg_count
        , x_msg_data             => x_msg_data
        );
Line: 6819

         INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
          (p_movement_statistics  => l_movement_transaction
         , x_return_status        => l_return_status
         , x_msg_count            => x_msg_count
         , x_msg_data             => x_msg_data
          );