[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'
1413: fnd_global.login_id,
1414: fnd_global.user_id,
1415: fnd_global.conc_request_id,
1416: 'N'
1417: FROM cst_lc_adj_acctg_info_gt acc,
1418: cst_lc_rcv_txn_gt rt,
1419: cst_lc_accounts_gt adj_acc
1420: WHERE (rt.transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')
1421: or (rt.transaction_type = 'CORRECT'
1538: NULL,
1539: acc.organization_id,
1540: 2,
1541: msi.primary_uom_code
1542: FROM cst_lc_adj_acctg_info_gt acc,
1543: cst_lc_rcv_txn_gt rt,
1544: mtl_secondary_inventories mse,
1545: mtl_material_transactions mmt,
1546: mtl_system_items_b msi
1689: acc.lcm_var_account,
1690: (layer_quantity * (acc.new_landed_cost - acc.prior_landed_cost)) value_change
1691: FROM mtl_material_transactions mmt,
1692: mtl_cst_layer_act_cost_details mclacd,
1693: cst_lc_adj_acctg_info_gt acc,
1694: cst_lc_rcv_txn_gt rt,
1695: mtl_secondary_inventories mse
1696: WHERE (rt.transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')
1697: or (rt.transaction_type = 'CORRECT'
2067: 0,
2068: 0,
2069: 0
2070: FROM cst_lc_rae_events_gt rae,
2071: cst_lc_adj_acctg_info_gt acc
2072: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id;
2073:
2074: IF (l_sLog AND l_pLog) THEN
2075: l_num_records := SQL%ROWCOUNT;
2169: 0,
2170: 0,
2171: 0
2172: FROM cst_lc_rae_events_gt rae,
2173: cst_lc_adj_acctg_info_gt acc
2174: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id;
2175:
2176: IF (l_sLog AND l_pLog) THEN
2177: l_num_records := SQL%ROWCOUNT;
2217: fnd_global.prog_appl_id,
2218: fnd_global.conc_program_id,
2219: SYSDATE
2220: FROM cst_lc_mmt_gt mmt,
2221: cst_lc_adj_acctg_info_gt acc
2222: WHERE mmt.lcm_transaction_id = acc.lcm_transaction_id;
2223:
2224: IF (l_sLog AND l_pLog) THEN
2225: l_num_records := SQL%ROWCOUNT;
2357: acc.accounting_date,
2358: rae.accounting_event_id,
2359: NULL
2360: FROM cst_lc_rae_events_gt rae,
2361: cst_lc_adj_acctg_info_gt acc,
2362: cst_xla_rcv_event_map cmap
2363: WHERE rae.lcm_transaction_id = acc.lcm_transaction_id
2364: AND cmap.event_class_code IN ('LDD_COST_ADJ_RCV', 'LDD_COST_ADJ_DEL')
2365: AND cmap.transaction_type_id = rae.event_type_id;