[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;
1811: | PROCEDURE : Insert_Adjustment_Data |
1812: | |
1813: | DESCRIPTION : This procedure inserts the receiving events data and the |
1814: | average and layer cost update data from temporary tables |
1815: | into RCV_ACCOUNTING_EVENTS and MTL_MATERIAL_TRANSACTIONS. |
1816: | Accounting and other entries are also calculated and |
1817: | inserted into RCV_RECEIVING_SUBLEDGER, XLA_EVENTS_INT_GT |
1818: | and MTL_CST_TXN_COST_DETAILS. |
1819: | |
1900: l_return_status := FND_API.G_RET_STS_SUCCESS;
1901:
1902: l_stmt_num := 10;
1903:
1904: /* Create RCV accounting events data from the GTT */
1905: INSERT INTO rcv_accounting_events
1906: (accounting_event_id,
1907: event_source,
1908: event_source_id,
1901:
1902: l_stmt_num := 10;
1903:
1904: /* Create RCV accounting events data from the GTT */
1905: INSERT INTO rcv_accounting_events
1906: (accounting_event_id,
1907: event_source,
1908: event_source_id,
1909: event_type_id,
1996: END IF;
1997:
1998: l_stmt_num := 20;
1999:
2000: /* Create the debit lines in the subledger for the rcv accounting events */
2001: INSERT INTO rcv_receiving_sub_ledger
2002: (created_by,
2003: creation_date,
2004: program_application_id,
2099:
2100: END IF;
2101:
2102: l_stmt_num := 30;
2103: /* Create the credit lines in the subledger for the rcv accounting events */
2104: INSERT INTO rcv_receiving_sub_ledger
2105: (created_by,
2106: creation_date,
2107: program_application_id,
2360: transaction_number,
2361: budgetary_control_flag)
2362: SELECT 707,
2363: acc.ledger_id,
2364: 'RCV_ACCOUNTING_EVENTS',
2365: rae.rcv_transaction_id,
2366: rae.accounting_event_id,
2367: rae.organization_id,
2368: cmap.event_class_code,
2396:
2397: /* Call the xla package for creating xla events for the receiving events in bulk */
2398: xla_events_pub_pkg.create_bulk_events(p_application_id => 707,
2399: p_ledger_id => p_ledger_id,
2400: p_entity_type_code => 'RCV_ACCOUNTING_EVENTS',
2401: p_source_application_id => 201);
2402:
2403: l_stmt_num := 80;
2404: /* Insert into the LCM transactions table to maintain history of this adjustment */
2727: msi.inventory_item_id msi_item_id
2728: FROM org_acct_periods oap,
2729: cst_lc_adj_interface clai,
2730: rcv_transactions rt,
2731: rcv_accounting_events rae,
2732: /* Bug 13960596 po_lines_all pol, */
2733: rcv_shipment_lines rsl,
2734: po_line_locations_all poll,
2735: po_distributions_all pod,