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_VIB dependencies on GMF_INCOMING_MATERIAL_LAYERS

Line 1004: p_layer_rec IN gmf_incoming_material_layers%ROWTYPE,

1000: PROCEDURE Create_VIB_Details
1001: ( p_api_version IN NUMBER,
1002: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1003: p_tran_rec IN GMF_LAYERS.trans_rec_type,
1004: p_layer_rec IN gmf_incoming_material_layers%ROWTYPE,
1005: x_return_status OUT NOCOPY VARCHAR2,
1006: x_msg_count OUT NOCOPY NUMBER,
1007: x_msg_data OUT NOCOPY VARCHAR2
1008: ) IS

Line 1028: gmf_incoming_material_layers il,

1024: decode (tp.transaction_id2, NULL, ol.layer_doc_qty, ol2.layer_doc_qty) layer_doc_qty,
1025: decode (tp.transaction_id2, NULL, 'N', 'Y') c_rev_layer,
1026: decode (tp.transaction_id2, NULL, ol.ROWID, ol2.ROWID) c_rowid
1027: FROM gmf_batch_vib_details v,
1028: gmf_incoming_material_layers il,
1029: gmf_outgoing_material_layers ol,
1030: mtl_material_transactions t,
1031: gme_transaction_pairs tp,
1032: gmf_outgoing_material_layers ol2,

Line 1062: gmf_incoming_material_layers il,

1058: decode (t.reverse_id, NULL, ol.layer_doc_qty, ol2.layer_doc_qty) layer_doc_qty,
1059: decode (t.reverse_id, NULL, 'N', 'Y') c_rev_layer,
1060: decode (t.reverse_id, NULL, ol.ROWID, ol2.ROWID) c_rowid
1061: FROM gmf_batch_vib_details v,
1062: gmf_incoming_material_layers il,
1063: gmf_resource_layers ol,
1064: gme_resource_txns t,
1065: gmf_resource_layers ol2,
1066: gme_resource_txns t2

Line 1876: gmf_incoming_material_layers l

1872: CURSOR c_null_consume_layers IS
1873: SELECT v.*, l.layer_doc_qty, l.layer_doc_um, l.mmt_transaction_id, l.lot_number, l.mmt_organization_id
1874: FROM gmf_batch_vib_details v,
1875: gmf_batch_requirements r,
1876: gmf_incoming_material_layers l
1877: WHERE
1878: r.batch_id = p_batch_id AND
1879: v.requirement_id = r.requirement_id AND
1880: l.layer_id = v.prod_layer_id AND

Line 1891: FROM gmf_incoming_material_layers l,

1887:
1888: CURSOR c_last_prod_yield (p_prod_material_detail_id NUMBER) IS
1889: SELECT l.*, t.primary_quantity,
1890: t.inventory_item_id -- Bug 5607069
1891: FROM gmf_incoming_material_layers l,
1892: mtl_material_transactions t
1893: WHERE
1894: t.trx_source_line_id = p_prod_material_detail_id AND
1895: t.transaction_source_id = p_batch_id AND

Line 2052: -- Create a pseudo product layer in the gmf_incoming_material_layers table.

2048: END IF;
2049:
2050: BEGIN
2051:
2052: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2053: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2054:
2055:
2056: INSERT INTO gmf_incoming_material_layers(

Line 2056: INSERT INTO gmf_incoming_material_layers(

2052: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2053: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2054:
2055:
2056: INSERT INTO gmf_incoming_material_layers(
2057: layer_id,
2058: mmt_transaction_id,
2059: mmt_organization_id,
2060: lot_number,

Line 2175: gmf_incoming_material_layers il,

2171: THEN
2172: SELECT nvl(sum (consume_ib_doc_qty), 0)
2173: INTO l_prev_consume_ib_doc_qty
2174: FROM gmf_batch_vib_details v,
2175: gmf_incoming_material_layers il,
2176: mtl_material_transactions mmt
2177: WHERE
2178: v.requirement_id = req.requirement_id AND
2179: v.consume_layer_id = ing.layer_id AND

Line 2208: gmf_incoming_material_layers il,

2204: SELECT nvl(sum (consume_ib_doc_qty), 0)
2205: INTO l_orig_layer_consumption_qty
2206: FROM gmf_outgoing_material_layers ol,
2207: gmf_batch_vib_details v,
2208: gmf_incoming_material_layers il,
2209: mtl_material_transactions mmt
2210: WHERE
2211: ol.mmt_transaction_id = ing.reverse_id AND
2212: ol.lot_number = ing.lot_number AND

Line 2236: -- Create a pseudo product layer in the gmf_incoming_material_layers table.

2232: END IF;
2233: -- End bug 5607069
2234:
2235: IF l_pseudo_prod_layer_id IS NULL THEN
2236: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2237: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2238:
2239: INSERT INTO gmf_incoming_material_layers(
2240: layer_id,

Line 2239: INSERT INTO gmf_incoming_material_layers(

2235: IF l_pseudo_prod_layer_id IS NULL THEN
2236: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2237: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2238:
2239: INSERT INTO gmf_incoming_material_layers(
2240: layer_id,
2241: mmt_transaction_id,
2242: mmt_organization_id,
2243: lot_number,

Line 2368: gmf_incoming_material_layers il,

2364: THEN
2365: SELECT nvl(sum (consume_ib_doc_qty), 0)
2366: INTO l_prev_consume_ib_doc_qty
2367: FROM gmf_batch_vib_details v,
2368: gmf_incoming_material_layers il,
2369: mtl_material_transactions mmt
2370: WHERE
2371: v.requirement_id = req.requirement_id AND
2372: v.consume_layer_id = rsrc.layer_id AND

Line 2400: gmf_incoming_material_layers il,

2396: SELECT nvl(sum (consume_ib_doc_qty), 0)
2397: INTO l_orig_layer_consumption_qty
2398: FROM gmf_resource_layers rl,
2399: gmf_batch_vib_details v,
2400: gmf_incoming_material_layers il,
2401: mtl_material_transactions mmt
2402: WHERE
2403: rl.poc_trans_id = rsrc.reverse_id AND
2404: v.consume_layer_id = rl.layer_id AND

Line 2426: -- Create a pseudo product layer in the gmf_incoming_material_layers table.

2422: END IF;
2423: -- End bug 5607069
2424:
2425: IF l_pseudo_prod_layer_id IS NULL THEN
2426: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2427: -- Bug 6887598 mmt_organization_id should not be NULL
2428: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2429: INSERT INTO gmf_incoming_material_layers(
2430: layer_id,

Line 2429: INSERT INTO gmf_incoming_material_layers(

2425: IF l_pseudo_prod_layer_id IS NULL THEN
2426: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2427: -- Bug 6887598 mmt_organization_id should not be NULL
2428: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2429: INSERT INTO gmf_incoming_material_layers(
2430: layer_id,
2431: mmt_transaction_id,
2432: mmt_organization_id, -- B6887598
2433: lot_number,

Line 2754: -- Delete all rows from gmf_incoming_material_layers which are used in

2750: delete from xla_events_int_gt ;
2751: END IF;
2752:
2753: -- End Bug 11839588
2754: -- Delete all rows from gmf_incoming_material_layers which are used in
2755: -- gmf_batch_vib_details with finalize_ind = 1
2756: IF g_debug <= gme_debug.g_log_statement THEN
2757: gme_debug.put_line ('deleting pseudo layers...');
2758: END IF;

Line 2760: DELETE from gmf_incoming_material_layers

2756: IF g_debug <= gme_debug.g_log_statement THEN
2757: gme_debug.put_line ('deleting pseudo layers...');
2758: END IF;
2759:
2760: DELETE from gmf_incoming_material_layers
2761: WHERE
2762: pseudo_layer_id IS NOT NULL AND
2763: layer_id in (
2764: SELECT prod_layer_id

Line 2867: gmf_incoming_material_layers il,

2863: RANK() OVER(partition by hdr.batch_id ORDER BY hdr.batch_id, il.layer_date desc, il.layer_id desc) layer_rank
2864: FROM
2865: gme_batch_header hdr,
2866: sy_orgn_mst orgn,
2867: gmf_incoming_material_layers il,
2868: ic_tran_pnd pnd
2869: WHERE
2870: il.layer_date >= p_start_date
2871: AND il.layer_date <= p_end_date

Line 2888: l_layer_rec gmf_incoming_material_layers%ROWTYPE;

2884: l_co_code cm_cldr_hdr.co_code%TYPE;
2885: l_start_date DATE;
2886: l_end_date DATE;
2887:
2888: l_layer_rec gmf_incoming_material_layers%ROWTYPE;
2889: l_trans_rec ic_tran_pnd%ROWTYPE;
2890:
2891: BEGIN
2892: