eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on MTL_MATERIAL_TRANSACTIONS

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 117: SELECT /+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) /

113:
114: l_stmt_num := 20;
115: -- Uncosted Transactions (must resolve)
116: BEGIN
117: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */
118: COUNT(*)
119: INTO l_tcount
120: FROM mtl_material_transactions MMT
121: WHERE organization_id = p_org_id

Line 120: FROM mtl_material_transactions MMT

116: BEGIN
117: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */
118: COUNT(*)
119: INTO l_tcount
120: FROM mtl_material_transactions MMT
121: WHERE organization_id = p_org_id
122: AND transaction_date <= l_sched_close_date
123: AND costed_flag IN('N','E');-- bug 13054482 Changed the not null condition, as it causes a index full scan
124:

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;

Line 1080: SELECT /+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) /

1076: RAISE UNPROCESSED_TXNS_EXIST;
1077: END IF;
1078:
1079: l_stmt_num := 100;
1080: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */
1081: COUNT(*)
1082: INTO l_count
1083: FROM mtl_material_transactions MMT
1084: WHERE organization_id = p_org_id

Line 1083: FROM mtl_material_transactions MMT

1079: l_stmt_num := 100;
1080: SELECT /*+ INDEX (MMT MTL_MATERIAL_TRANSACTIONS_N10) */
1081: COUNT(*)
1082: INTO l_count
1083: FROM mtl_material_transactions MMT
1084: WHERE organization_id = p_org_id
1085: AND transaction_date < l_sched_close_date
1086: AND costed_flag IN('N','E')-- bug 13054482 Changed the not null condition, as it causes a index full scan
1087: AND rownum = 1;

Line 1090: l_unprocessed_table := 'MTL_MATERIAL_TRANSACTIONS';

1086: AND costed_flag IN('N','E')-- bug 13054482 Changed the not null condition, as it causes a index full scan
1087: AND rownum = 1;
1088:
1089: IF l_count <> 0 THEN
1090: l_unprocessed_table := 'MTL_MATERIAL_TRANSACTIONS';
1091: RAISE UNPROCESSED_TXNS_EXIST;
1092: END IF;
1093:
1094: l_stmt_num := 110;

Line 2120: FROM mtl_material_transactions MMT,

2116: MMT.subinventory_code),
2117: MMT.subinventory_code),
2118: MMT.inventory_item_id,
2119: SUM(MTA.base_transaction_value)
2120: FROM mtl_material_transactions MMT,
2121: mtl_transaction_accounts MTA /*,
2122: mtl_secondary_inventories SUB */
2123: WHERE MTA.accounting_line_type = 1 -- inventory
2124: AND MTA.transaction_date >= l_period_start_date

Line 2193: FROM mtl_material_transactions MMT,

2189: MMT.transfer_cost_group_id,
2190: MMT.transfer_subinventory,
2191: MMT.inventory_item_id,
2192: SUM(MTA.base_transaction_value)
2193: FROM mtl_material_transactions MMT,
2194: mtl_transaction_accounts MTA /*,
2195: mtl_secondary_inventories SUB */
2196: WHERE MTA.accounting_line_type = 1 -- inventory
2197: AND MTA.transaction_date >= l_period_start_date

Line 2245: FROM mtl_material_transactions MMT,

2241: MMT.transfer_cost_group_id),
2242: NULL,
2243: MMT.inventory_item_id,
2244: SUM(MTA.base_transaction_value)
2245: FROM mtl_material_transactions MMT,
2246: mtl_transaction_accounts MTA
2247: WHERE MTA.accounting_line_type = 14 -- intransit account
2248: AND MTA.transaction_date >= l_period_start_date
2249: AND MTA.transaction_date <= l_to_date+1-(1/(24*3600))