[Home] [Help]
337: /*===========================================================================+
338: | |
339: | PROCEDURE : Populate_Lcm_Adjustment_Info |
340: | |
341: | DESCRIPTION : This procedure populates CST_LC_ADJ_ACCTG_INFO_GT with |
342: | the organization level information and CST_LC_RCV_TXN_GT |
343: | with the entire hierarchy of transaction within the |
344: | cutoff date under the parent receipt transaction of the |
345: | lcm adjustment transaction. |
515:
516: /* Insert all the PO, accounting and Landed cost adjustment related information for
517: the lcm transaction. This will be used by all the events and accounting created
518: for this lcm transaction */
519: INSERT INTO CST_LC_ADJ_ACCTG_INFO_GT
520: (lcm_transaction_id,
521: rcv_transaction_id,
522: inventory_item_id,
523: prior_landed_cost,
852: 1), 1) exp_flag
853: FROM mtl_material_transactions mmt,
854: cst_lc_rcv_txn_gt rt,
855: cst_cost_group_accounts ccga,
856: cst_lc_adj_acctg_info_gt acc,
857: mtl_secondary_inventories mse
858: WHERE mmt.transaction_source_type_id = 1
859: AND mmt.organization_id = p_organization_id
860: AND mmt.rcv_transaction_id = rt.rcv_transaction_id
999:
1000: END IF;
1001:
1002: l_stmt_num := 170;
1003: DELETE FROM cst_lc_adj_acctg_info_gt t
1004: WHERE EXISTS (SELECT 1
1005: FROM cst_lc_adj_interface_errors e
1006: WHERE e.transaction_id = t.lcm_transaction_id
1007: AND e.group_id = p_group_id
1267: fnd_global.login_id,
1268: fnd_global.user_id,
1269: fnd_global.conc_request_id,
1270: 'N'
1271: FROM CST_LC_ADJ_ACCTG_INFO_GT ACC,
1272: CST_LC_RCV_TXN_GT RT
1273: WHERE acc.lcm_transaction_id = RT.lcm_transaction_id
1274: AND (rt.transaction_type IN ('RECEIVE', 'MATCH', 'RETURN TO VENDOR')
1275: OR (rt.transaction_type = 'CORRECT'
1422: fnd_global.login_id,
1423: fnd_global.user_id,
1424: fnd_global.conc_request_id,
1425: 'N'
1426: FROM cst_lc_adj_acctg_info_gt acc,
1427: cst_lc_rcv_txn_gt rt,
1428: cst_lc_accounts_gt adj_acc
1429: WHERE (rt.transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')
1430: or (rt.transaction_type = 'CORRECT'
1554: NULL,
1555: acc.organization_id,
1556: 2,
1557: msi.primary_uom_code
1558: FROM cst_lc_adj_acctg_info_gt acc,
1559: cst_lc_rcv_txn_gt rt,
1560: mtl_secondary_inventories mse,
1561: mtl_material_transactions mmt,
1562: mtl_system_items_b msi
1706: acc.lcm_var_account,
1707: (layer_quantity * (acc.new_landed_cost - acc.prior_landed_cost)) value_change
1708: FROM mtl_material_transactions mmt,
1709: mtl_cst_layer_act_cost_details mclacd,
1710: cst_lc_adj_acctg_info_gt acc,
1711: cst_lc_rcv_txn_gt rt,
1712: mtl_secondary_inventories mse
1713: WHERE (rt.transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')
1714: or (rt.transaction_type = 'CORRECT'
2085: 0,
2086: 0,
2087: 0
2088: FROM cst_lc_rae_events_gt rae,
2089: cst_lc_adj_acctg_info_gt acc
2090: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id;
2091:
2092: IF (l_sLog AND l_pLog) THEN
2093: l_num_records := SQL%ROWCOUNT;
2187: 0,
2188: 0,
2189: 0
2190: FROM cst_lc_rae_events_gt rae,
2191: cst_lc_adj_acctg_info_gt acc
2192: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id;
2193:
2194: IF (l_sLog AND l_pLog) THEN
2195: l_num_records := SQL%ROWCOUNT;
2235: fnd_global.prog_appl_id,
2236: fnd_global.conc_program_id,
2237: SYSDATE
2238: FROM cst_lc_mmt_gt mmt,
2239: cst_lc_adj_acctg_info_gt acc
2240: WHERE mmt.lcm_transaction_id = acc.lcm_transaction_id;
2241:
2242: IF (l_sLog AND l_pLog) THEN
2243: l_num_records := SQL%ROWCOUNT;
2375: acc.accounting_date,
2376: rae.accounting_event_id,
2377: NULL
2378: FROM cst_lc_rae_events_gt rae,
2379: cst_lc_adj_acctg_info_gt acc,
2380: cst_xla_rcv_event_map cmap
2381: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id
2382: AND cmap.event_class_code IN ('LDD_COST_ADJ_RCV', 'LDD_COST_ADJ_DEL')
2383: AND cmap.transaction_type_id = rae.event_type_id;