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.GMF_LAYERS dependencies on GME_BATCH_HEADER

Line 1064: FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il

1060: FROM gmf_layer_cost_details c
1061: WHERE
1062: c.layer_id IN
1063: (SELECT il.layer_id
1064: FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il
1065: WHERE h.batch_id = p_batch_id
1066: AND h.batch_id = t.transaction_source_id
1067: AND t.transaction_source_type_id = 5
1068: AND il.mmt_transaction_id = t.transaction_id

Line 1081: FROM gme_batch_header h, mtl_material_transactions t,

1077: FROM gmf_incoming_material_layers il
1078: WHERE il.PSEUDO_LAYER_ID IS NOT NULL
1079: AND EXISTS
1080: (SELECT 1
1081: FROM gme_batch_header h, mtl_material_transactions t,
1082: gmf_incoming_material_layers im
1083: WHERE h.batch_id = p_batch_id
1084: AND h.batch_id = t.transaction_source_id
1085: AND t.transaction_source_type_id = 5

Line 1098: FROM gme_batch_header h, mtl_material_transactions t

1094: DELETE
1095: FROM gmf_incoming_material_layers il
1096: WHERE (il.mmt_organization_id, il.mmt_transaction_id) IN
1097: (SELECT distinct t.organization_id, t.transaction_id
1098: FROM gme_batch_header h, mtl_material_transactions t
1099: WHERE h.batch_id = p_batch_id
1100: AND h.batch_id = t.transaction_source_id
1101: AND t.transaction_source_type_id = 5
1102: );

Line 1108: FROM gme_batch_header h, mtl_material_transactions t

1104: DELETE
1105: FROM gmf_outgoing_material_layers ol
1106: WHERE (ol.mmt_organization_id, ol.mmt_transaction_id) IN
1107: (SELECT distinct t.organization_id, t.transaction_id
1108: FROM gme_batch_header h, mtl_material_transactions t
1109: WHERE h.batch_id = p_batch_id
1110: AND h.batch_id = t.transaction_source_id
1111: AND t.transaction_source_type_id = 5
1112: );

Line 1118: FROM gme_batch_header h, gme_resource_txns t

1114: DELETE
1115: FROM gmf_resource_layers il
1116: WHERE il.poc_trans_id IN
1117: (SELECT t.poc_trans_id
1118: FROM gme_batch_header h, gme_resource_txns t
1119: WHERE h.batch_id = p_batch_id
1120: AND h.batch_id = t.doc_id
1121: AND t.doc_type = 'PROD'
1122: );

Line 1128: FROM gmf_batch_requirements br, gme_batch_header h

1124: DELETE
1125: FROM gmf_batch_vib_details bvd
1126: WHERE bvd.requirement_id IN
1127: (SELECT br.requirement_id
1128: FROM gmf_batch_requirements br, gme_batch_header h
1129: WHERE h.batch_id = p_batch_id
1130: AND h.batch_id = br.batch_id
1131: );
1132:

Line 1137: FROM gme_batch_header

1133: DELETE
1134: FROM gmf_batch_requirements br
1135: WHERE br.batch_id IN
1136: (SELECT batch_id
1137: FROM gme_batch_header
1138: WHERE batch_id = p_batch_id
1139: ) ;
1140:
1141: EXCEPTION

Line 1192: FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il

1188: e_baddata EXCEPTION;
1189:
1190: CURSOR cur_incoming_layers IS
1191: select count(*)
1192: FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il
1193: WHERE h.batch_id = p_batch_id
1194: AND h.batch_id = t.transaction_source_id
1195: AND t.transaction_source_type_id = 5
1196: AND il.mmt_transaction_id = t.transaction_id

Line 1206: FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il

1202: FROM gmf_batch_vib_details bvd
1203: WHERE bvd.CONSUME_LAYER_DATE < l_start_date
1204: AND bvd.prod_layer_id IN
1205: (SELECT il.layer_id
1206: FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il
1207: WHERE h.batch_id = p_batch_id
1208: AND h.batch_id = t.transaction_source_id
1209: AND t.transaction_source_type_id = 5
1210: AND il.mmt_transaction_id = t.transaction_id

Line 1228: FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il

1224: DELETE
1225: FROM gmf_layer_cost_details c
1226: WHERE c.layer_id IN
1227: (SELECT il.layer_id
1228: FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il
1229: WHERE h.batch_id = p_batch_id
1230: AND h.batch_id = t.transaction_source_id
1231: AND t.transaction_source_type_id = 5
1232: AND il.mmt_transaction_id = t.transaction_id

Line 1280: FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il

1276: DELETE
1277: FROM gmf_batch_vib_details bvd
1278: WHERE bvd.prod_layer_id IN
1279: (SELECT il.layer_id
1280: FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il
1281: WHERE h.batch_id = p_batch_id
1282: AND h.batch_id = t.transaction_source_id
1283: AND t.transaction_source_type_id = 5
1284: AND il.mmt_transaction_id = t.transaction_id

Line 1293: FROM gme_batch_header h, mtl_material_transactions t

1289: DELETE
1290: FROM gmf_outgoing_material_layers ol
1291: WHERE (ol.mmt_organization_id, ol.mmt_transaction_id) IN
1292: (SELECT distinct t.organization_id, t.transaction_id
1293: FROM gme_batch_header h, mtl_material_transactions t
1294: WHERE h.batch_id = p_batch_id
1295: AND h.batch_id = t.transaction_source_id
1296: AND t.transaction_source_type_id = 5
1297: AND t.transaction_date >= l_start_date

Line 1304: FROM gme_batch_header h, gme_resource_txns t

1300: DELETE
1301: FROM gmf_resource_layers il
1302: WHERE il.poc_trans_id IN
1303: (SELECT t.poc_trans_id
1304: FROM gme_batch_header h, gme_resource_txns t
1305: WHERE h.batch_id = p_batch_id
1306: AND h.batch_id = t.doc_id
1307: AND t.doc_type = 'PROD'
1308: AND t.trans_date >= l_start_date

Line 1315: FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il1

1311: DELETE
1312: FROM gmf_incoming_material_layers il
1313: WHERE il.layer_id IN
1314: (SELECT il1.layer_id
1315: FROM gme_batch_header h, mtl_material_transactions t, gmf_incoming_material_layers il1
1316: WHERE h.batch_id = p_batch_id
1317: AND h.batch_id = t.transaction_source_id
1318: AND t.transaction_source_type_id = 5
1319: AND il1.mmt_transaction_id = t.transaction_id

Line 1337: FROM gme_batch_header

1333: DELETE
1334: FROM gmf_batch_requirements br
1335: WHERE br.batch_id IN
1336: (SELECT batch_id
1337: FROM gme_batch_header
1338: WHERE batch_id = p_batch_id
1339: );
1340:
1341: END IF;

Line 1405: gme_batch_header b

1401: tp.transaction_id2 as reverse_id
1402: from mtl_material_transactions mmt,
1403: gme_transaction_pairs tp,
1404: gme_material_details md,
1405: gme_batch_header b
1406: where md.batch_id = b.batch_id
1407: and b.batch_id = l_batch_id
1408: and mmt.transaction_source_type_id = 5
1409: and mmt.transaction_source_id = b.batch_id

Line 1669: FROM gme_resource_txns rt, gme_batch_header b

1665: select *
1666: from
1667: ( SELECT rt.rowid r_id, rt.poc_trans_id as trans_id, rt.trans_date, rt.line_type as line_type, rt.trans_qty_um as doc_um, 'R' as type,
1668: rt.resource_usage as trans_qty, rt.reverse_id
1669: FROM gme_resource_txns rt, gme_batch_header b
1670: WHERE rt.doc_type = 'PROD'
1671: AND rt.doc_id = b.batch_id
1672: AND rt.completed_ind = 1
1673: AND rt.delete_mark = 0

Line 1849: gme_batch_header b

1845: tp.transaction_id2 as reverse_id, mmt.trx_source_line_id AS mat_det_id
1846: from mtl_material_transactions mmt,
1847: gme_transaction_pairs tp,
1848: gme_material_details md,
1849: gme_batch_header b
1850: where md.batch_id = b.batch_id
1851: and b.batch_id = l_batch_id
1852: and mmt.transaction_source_type_id = 5
1853: and mmt.transaction_source_id = b.batch_id

Line 2135: FROM gme_batch_header b

2131: l_end_date DATE ;
2132:
2133: CURSOR c_mig_closed_batches IS
2134: SELECT batch_id
2135: FROM gme_batch_header b
2136: WHERE b.batch_status = 4
2137: AND b.batch_id = l_batch_id
2138: AND b.batch_close_date >= l_start_date
2139: AND b.batch_close_date <= l_end_date;

Line 2385: FROM gme_batch_header h,

2381: SELECT batch_id, batch_no, batch_status , asd, batch_close_date
2382: FROM (
2383: SELECT h.batch_id, h.batch_no, h.batch_status , h.actual_start_date asd,
2384: h.batch_close_date, h.organization_id
2385: FROM gme_batch_header h,
2386: mtl_material_transactions t
2387: WHERE h.batch_status in (2,3,4) -- B9441550
2388: AND h.actual_start_date <= l_enddate
2389: AND h.batch_id = t.transaction_source_id

Line 2396: FROM gme_batch_header h,

2392: AND t.transaction_date <= l_enddate
2393: UNION
2394: SELECT h.batch_id, h.batch_no, h.batch_status , h.actual_start_date asd,
2395: h.batch_close_date, h.organization_id
2396: FROM gme_batch_header h,
2397: gme_resource_txns r
2398: WHERE h.batch_status in (2,3,4) -- B9441550
2399: AND h.actual_start_date <= l_enddate
2400: AND h.batch_id = r.doc_id

Line 2408: FROM gme_batch_header h

2404: AND r.delete_mark = 0
2405: UNION
2406: SELECT h.batch_id, h.batch_no, h.batch_status , h.actual_start_date asd,
2407: h.batch_close_date, h.organization_id
2408: FROM gme_batch_header h
2409: WHERE h.batch_status = 4
2410: AND h.actual_start_date <= l_enddate
2411: AND h.batch_close_date >= l_startdate
2412: AND h.batch_close_date <= l_enddate

Line 2416: FROM gme_batch_header h

2412: AND h.batch_close_date <= l_enddate
2413: UNION -- B9441550
2414: SELECT h.batch_id, h.batch_no, h.batch_status , h.plan_start_date asd,
2415: h.batch_close_date, h.organization_id
2416: FROM gme_batch_header h
2417: WHERE h.batch_status = -1
2418: AND h.batch_id = l_batch_id
2419: ) batches
2420: WHERE batches.batch_id = l_batch_id

Line 2437: FROM gme_batch_header h,

2433: SELECT batch_id, batch_no, batch_status , asd, batch_close_date
2434: FROM (
2435: SELECT h.batch_id, h.batch_no, h.batch_status , h.actual_start_date asd,
2436: h.batch_close_date, h.organization_id
2437: FROM gme_batch_header h,
2438: mtl_material_transactions t
2439: WHERE h.batch_status in (2,3,4) -- B9441550
2440: AND h.actual_start_date <= l_enddate
2441: AND h.batch_id = t.transaction_source_id

Line 2448: FROM gme_batch_header h,

2444: AND t.transaction_date <= l_enddate
2445: UNION
2446: SELECT h.batch_id, h.batch_no, h.batch_status , h.actual_start_date asd,
2447: h.batch_close_date, h.organization_id
2448: FROM gme_batch_header h,
2449: gme_resource_txns r
2450: WHERE h.batch_status in (2,3,4) -- B9441550
2451: AND h.actual_start_date <= l_enddate
2452: AND h.batch_id = r.doc_id

Line 2460: FROM gme_batch_header h

2456: AND r.delete_mark = 0
2457: UNION
2458: SELECT h.batch_id, h.batch_no, h.batch_status , h.actual_start_date asd,
2459: h.batch_close_date, h.organization_id
2460: FROM gme_batch_header h
2461: WHERE h.batch_status = 4
2462: AND h.actual_start_date <= l_enddate
2463: AND h.batch_close_date >= l_startdate
2464: AND h.batch_close_date <= l_enddate

Line 2468: FROM gme_batch_header h

2464: AND h.batch_close_date <= l_enddate
2465: UNION -- B9441550
2466: SELECT h.batch_id, h.batch_no, h.batch_status , h.plan_start_date asd,
2467: h.batch_close_date, h.organization_id
2468: FROM gme_batch_header h
2469: WHERE h.batch_status = -1
2470: AND h.organization_id = l_org_id
2471: AND h.plan_start_date <= l_enddate
2472: AND h.plan_start_date >= l_startdate

Line 2490: FROM gme_batch_header h,

2486: SELECT batch_id, batch_no, batch_status , asd, batch_close_date
2487: FROM (
2488: SELECT h.batch_id, h.batch_no, h.batch_status , h.actual_start_date asd,
2489: h.batch_close_date, h.organization_id
2490: FROM gme_batch_header h,
2491: mtl_material_transactions t
2492: WHERE h.batch_status in (2,3,4) -- B9441550
2493: AND h.actual_start_date <= l_enddate
2494: AND h.batch_id = t.transaction_source_id

Line 2501: FROM gme_batch_header h,

2497: AND t.transaction_date <= l_enddate
2498: UNION
2499: SELECT h.batch_id, h.batch_no, h.batch_status , h.actual_start_date asd,
2500: h.batch_close_date, h.organization_id
2501: FROM gme_batch_header h,
2502: gme_resource_txns r
2503: WHERE h.batch_status in (2,3,4) -- B9441550
2504: AND h.actual_start_date <= l_enddate
2505: AND h.batch_id = r.doc_id

Line 2513: FROM gme_batch_header h

2509: AND r.delete_mark = 0
2510: UNION
2511: SELECT h.batch_id, h.batch_no, h.batch_status , h.actual_start_date asd,
2512: h.batch_close_date, h.organization_id
2513: FROM gme_batch_header h
2514: WHERE h.batch_status = 4
2515: AND h.actual_start_date <= l_enddate
2516: AND h.batch_close_date >= l_startdate
2517: AND h.batch_close_date <= l_enddate

Line 2521: FROM gme_batch_header h

2517: AND h.batch_close_date <= l_enddate
2518: UNION -- B9441550
2519: SELECT h.batch_id, h.batch_no, h.batch_status , h.plan_start_date asd,
2520: h.batch_close_date, h.organization_id
2521: FROM gme_batch_header h
2522: WHERE h.batch_status = -1
2523: AND h.plan_start_date <= l_enddate
2524: AND h.plan_start_date >= l_startdate
2525: ) batches

Line 2586: FROM gme_batch_header h, mtl_material_transactions t,

2582: FROM gmf_incoming_material_layers il
2583: WHERE il.PSEUDO_LAYER_ID IS NOT NULL
2584: AND EXISTS
2585: (SELECT 1
2586: FROM gme_batch_header h, mtl_material_transactions t,
2587: gmf_incoming_material_layers im
2588: WHERE h.batch_id = rec.batch_id
2589: AND h.batch_id = t.transaction_source_id
2590: AND t.transaction_source_type_id = 5

Line 2600: FROM gme_batch_header h, mtl_material_transactions t

2596: SELECT count(*) INTO l_count
2597: FROM gmf_incoming_material_layers il
2598: WHERE (il.mmt_organization_id, il.mmt_transaction_id) IN
2599: (SELECT DISTINCT t.organization_id, t.transaction_id
2600: FROM gme_batch_header h, mtl_material_transactions t
2601: WHERE h.batch_id = rec.batch_id
2602: AND h.batch_id = t.transaction_source_id
2603: AND t.transaction_source_type_id = 5
2604: );

Line 2610: FROM gme_batch_header h, mtl_material_transactions t

2606: SELECT count(*) INTO l_count
2607: FROM gmf_outgoing_material_layers ol
2608: WHERE (ol.mmt_organization_id, ol.mmt_transaction_id) IN
2609: (SELECT DISTINCT t.organization_id, t.transaction_id
2610: FROM gme_batch_header h, mtl_material_transactions t
2611: WHERE h.batch_id = rec.batch_id
2612: AND h.batch_id = t.transaction_source_id
2613: AND t.transaction_source_type_id = 5
2614: );

Line 2620: FROM gmf_batch_requirements br, gme_batch_header h

2616: SELECT count(*) INTO l_count
2617: FROM gmf_batch_vib_details bvd
2618: WHERE bvd.requirement_id IN
2619: (SELECT br.requirement_id
2620: FROM gmf_batch_requirements br, gme_batch_header h
2621: WHERE h.batch_id = rec.batch_id
2622: AND h.batch_id = br.batch_id
2623: );
2624: fnd_file.put_line(fnd_file.log, ' Batch Vib details count = '|| l_count);

Line 2629: FROM gme_batch_header

2625: SELECT count(*) INTO l_count
2626: FROM gmf_batch_requirements br
2627: WHERE br.batch_id IN
2628: (SELECT batch_id
2629: FROM gme_batch_header
2630: WHERE batch_id = rec.batch_id
2631: );
2632: fnd_file.put_line(fnd_file.log, ' Batch requirements count = '|| l_count);
2633: