[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:
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,
1987: program_id,
2030: SYSDATE,
2031: fnd_global.login_id,
2032: fnd_global.user_id,
2033: fnd_global.conc_request_id,
2034: rcv_receiving_sub_ledger_s.nextval,
2035: rae.accounting_event_id,
2036: rae.debit_accounting_line_type,
2037: rae.rcv_transaction_id,
2038: 'A',
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,
2090: program_id,
2132: SYSDATE,
2133: fnd_global.login_id,
2134: fnd_global.user_id,
2135: fnd_global.conc_request_id,
2136: rcv_receiving_sub_ledger_s.NEXTVAL,
2137: rae.accounting_event_id,
2138: rae.credit_accounting_line_type,
2139: rae.rcv_transaction_id,
2140: 'A',