APPS.CST_LCMADJUSTMENTS_PVT dependencies on CST_LC_RCV_TXN_GT

Line 342: | the organization level information and CST_LC_RCV_TXN_GT |

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. |
346: | |

Line 622: INSERT INTO CST_LC_RCV_TXN_GT

618: corresponding to the lcm adjustment as their root. */
619: for c_lt in c_lcm_txns (p_group_id) loop
620:
621: l_stmt_num := 50;
622: INSERT INTO CST_LC_RCV_TXN_GT
623: (group_id, lcm_transaction_id,
624: rcv_transaction_id,
625: parent_transaction_id,
626: accounting_event_id,

Line 661: INSERT INTO CST_LC_RCV_TXN_GT

657:
658: end loop;
659:
660: l_stmt_num := 60;
661: INSERT INTO CST_LC_RCV_TXN_GT
662: (group_id,
663: lcm_transaction_id,
664: accounting_event_id,
665: rcv_transaction_id,

Line 687: CST_LC_RCV_TXN_GT rt

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;
691:

Line 703: DELETE FROM CST_LC_RCV_TXN_GT

699:
700: END IF;
701:
702: l_stmt_num := 65;
703: DELETE FROM CST_LC_RCV_TXN_GT
704: WHERE lcm_transaction_id < 0;
705:
706: IF (l_sLog AND l_pLog) THEN
707: l_num_records := SQL%ROWCOUNT;

Line 854: cst_lc_rcv_txn_gt rt,

850: Decode(acc.inventory_asset_flag, 'Y', Decode(mse.asset_inventory, 1,
851: 0,
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

Line 985: DELETE FROM cst_lc_rcv_txn_gt t

981:
982: END IF;
983:
984: l_stmt_num := 160;
985: DELETE FROM cst_lc_rcv_txn_gt t
986: WHERE EXISTS (SELECT 1
987: FROM cst_lc_adj_interface_errors e
988: WHERE e.transaction_id = t.lcm_transaction_id
989: AND e.group_id = p_group_id

Line 1272: CST_LC_RCV_TXN_GT RT

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'
1276: AND rt.parent_transaction_type IN ('RECEIVE', 'MATCH', 'RETURN TO VENDOR')))

Line 1418: cst_lc_rcv_txn_gt rt,

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'
1422: and rt.parent_transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')))

Line 1543: cst_lc_rcv_txn_gt rt,

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
1547: WHERE (rt.transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')

Line 1694: cst_lc_rcv_txn_gt rt,

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'
1698: and rt.parent_transaction_type IN ('DELIVER', 'RETURN TO RECEIVING')))