[Home] [Help]
24: its child transactions (Correct, Return, Deliver).
25: Only transactions that have transaction date prior to the
26: transaction date of the landed cost adjustment transaction
27: are considered for adjustment.
28: b. Generate the RCV_ACCOUNTING_EVENTS for the receipts and
29: delivery adjustments.
30: For each LCM transaction following receiving events are created:-
31: i. Adjustments against the net received quantity.
32: Event Type Id 15 i.e. Landed Cost Adjustments for Receipts.
51: In such a case, multiple average cost update transactions will be created.
52: - The layer cost update is done against the layers that were hit by the
53: original delivery and the layer values are updated in proportion of the
54: delivered quantities against each layer.
55: - Create records into tables rcv_accounting_events, rcv_receiving_sub_ledger,
56: mtl_material_transactions, mtl_cst_txn_cost_details and XLA_EVENTS_INT_GT using
57: the global temporary tables.
58: ------------------------------------------------------------------------------------------*/
59:
682: rt.transaction_type,
683: Decode(rt.transaction_type, 'CORRECT', rt_parent.transaction_type, rt.transaction_type) parent_transaction_type,
684: rt.subinventory_code
685: FROM rcv_transactions rt_parent,
686: rcv_accounting_events rae,
687: CST_LC_RCV_TXN_GT rt
688: WHERE rae.rcv_transaction_id (+) = rt.rcv_transaction_id
689: AND Nvl(rae.event_type_id,2) in (1,2,3,4,5,6)
690: AND rt_parent.transaction_id (+) = rt.parent_transaction_id;
1793: | PROCEDURE : Insert_Adjustment_Data |
1794: | |
1795: | DESCRIPTION : This procedure inserts the receiving events data and the |
1796: | average and layer cost update data from temporary tables |
1797: | into RCV_ACCOUNTING_EVENTS and MTL_MATERIAL_TRANSACTIONS. |
1798: | Accounting and other entries are also calculated and |
1799: | inserted into RCV_RECEIVING_SUBLEDGER, XLA_EVENTS_INT_GT |
1800: | and MTL_CST_TXN_COST_DETAILS. |
1801: | |
1882: l_return_status := FND_API.G_RET_STS_SUCCESS;
1883:
1884: l_stmt_num := 10;
1885:
1886: /* Create RCV accounting events data from the GTT */
1887: INSERT INTO rcv_accounting_events
1888: (accounting_event_id,
1889: event_source,
1890: event_source_id,
1883:
1884: l_stmt_num := 10;
1885:
1886: /* Create RCV accounting events data from the GTT */
1887: INSERT INTO rcv_accounting_events
1888: (accounting_event_id,
1889: event_source,
1890: event_source_id,
1891: event_type_id,
1978: END IF;
1979:
1980: l_stmt_num := 20;
1981:
1982: /* Create the debit lines in the subledger for the rcv accounting events */
1983: INSERT INTO rcv_receiving_sub_ledger
1984: (created_by,
1985: creation_date,
1986: program_application_id,
2081:
2082: END IF;
2083:
2084: l_stmt_num := 30;
2085: /* Create the credit lines in the subledger for the rcv accounting events */
2086: INSERT INTO rcv_receiving_sub_ledger
2087: (created_by,
2088: creation_date,
2089: program_application_id,
2342: transaction_number,
2343: budgetary_control_flag)
2344: SELECT 707,
2345: acc.ledger_id,
2346: 'RCV_ACCOUNTING_EVENTS',
2347: rae.rcv_transaction_id,
2348: rae.accounting_event_id,
2349: rae.organization_id,
2350: cmap.event_class_code,
2378:
2379: /* Call the xla package for creating xla events for the receiving events in bulk */
2380: xla_events_pub_pkg.create_bulk_events(p_application_id => 707,
2381: p_ledger_id => p_ledger_id,
2382: p_entity_type_code => 'RCV_ACCOUNTING_EVENTS',
2383: p_source_application_id => 201);
2384:
2385: l_stmt_num := 80;
2386: /* Insert into the LCM transactions table to maintain history of this adjustment */
2707: msi.inventory_item_id msi_item_id
2708: FROM org_acct_periods oap,
2709: cst_lc_adj_interface clai,
2710: rcv_transactions rt,
2711: rcv_accounting_events rae,
2712: po_lines_all pol,
2713: po_line_locations_all poll,
2714: po_distributions_all pod,
2715: gl_period_statuses gps,