APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 100: FROM mtl_material_transactions_temp

96: -- Unprocessed Material transactions (must resolve)
97: BEGIN
98: SELECT COUNT(*)
99: INTO l_tcount
100: FROM mtl_material_transactions_temp
101: WHERE organization_id = p_org_id
102: AND transaction_date <= l_sched_close_date
103: AND NVL(transaction_status,0) <> 2; -- 2 indicates a save-only status
104:

Line 1068: FROM mtl_material_transactions_temp

1064: l_stmt_num := 90;
1065: -- check if there are unprocessed transactions in MMTT/MMT/WCTI
1066: SELECT COUNT(*)
1067: INTO l_count
1068: FROM mtl_material_transactions_temp
1069: WHERE organization_id = p_org_id
1070: AND transaction_date < l_sched_close_date
1071: AND NVL(transaction_status,0) <> 2
1072: AND rownum = 1; -- transaction_status = 2 indicates a save-only status

Line 1075: l_unprocessed_table := 'MTL_MATERIAL_TRANSACTIONS_TEMP';

1071: AND NVL(transaction_status,0) <> 2
1072: AND rownum = 1; -- transaction_status = 2 indicates a save-only status
1073:
1074: IF l_count <> 0 THEN
1075: l_unprocessed_table := 'MTL_MATERIAL_TRANSACTIONS_TEMP';
1076: RAISE UNPROCESSED_TXNS_EXIST;
1077: END IF;
1078:
1079: l_stmt_num := 100;