[Home] [Help]
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:
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,
2005: program_id,
2048: SYSDATE,
2049: fnd_global.login_id,
2050: fnd_global.user_id,
2051: fnd_global.conc_request_id,
2052: rcv_receiving_sub_ledger_s.nextval,
2053: rae.accounting_event_id,
2054: rae.debit_accounting_line_type,
2055: rae.rcv_transaction_id,
2056: 'A',
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,
2108: program_id,
2150: SYSDATE,
2151: fnd_global.login_id,
2152: fnd_global.user_id,
2153: fnd_global.conc_request_id,
2154: rcv_receiving_sub_ledger_s.NEXTVAL,
2155: rae.accounting_event_id,
2156: rae.credit_accounting_line_type,
2157: rae.rcv_transaction_id,
2158: 'A',