DBA Data[Home] [Help]

APPS.CST_PERIODSUMMARY_PVT dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 101: FROM mtl_material_transactions_temp

97:
98: -- check if there are unprocessed transactions in MMTT/MMT/WCTI
99: SELECT COUNT(*)
100: INTO l_count
101: FROM mtl_material_transactions_temp
102: WHERE organization_id = p_org_id
103: AND transaction_date < l_sched_close_date
104: AND NVL(transaction_status,0) <> 2; -- 2 indicates a save-only status
105:

Line 107: l_unprocessed_table := 'MTL_MATERIAL_TRANSACTIONS_TEMP';

103: AND transaction_date < l_sched_close_date
104: AND NVL(transaction_status,0) <> 2; -- 2 indicates a save-only status
105:
106: IF l_count <> 0 THEN
107: l_unprocessed_table := 'MTL_MATERIAL_TRANSACTIONS_TEMP';
108: RAISE l_unprocessed_txn;
109: END IF;
110:
111: SELECT COUNT(*)