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 989: p_layer_rec IN gmf_incoming_material_layers%ROWTYPE,

985: PROCEDURE Create_VIB_Details
986: ( p_api_version IN NUMBER,
987: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
988: p_tran_rec IN GMF_LAYERS.trans_rec_type,
989: p_layer_rec IN gmf_incoming_material_layers%ROWTYPE,
990: x_return_status OUT NOCOPY VARCHAR2,
991: x_msg_count OUT NOCOPY NUMBER,
992: x_msg_data OUT NOCOPY VARCHAR2
993: ) IS

Line 1013: gmf_incoming_material_layers il,

1009: decode (tp.transaction_id2, NULL, ol.layer_doc_qty, ol2.layer_doc_qty) layer_doc_qty,
1010: decode (tp.transaction_id2, NULL, 'N', 'Y') c_rev_layer,
1011: decode (tp.transaction_id2, NULL, ol.ROWID, ol2.ROWID) c_rowid
1012: FROM gmf_batch_vib_details v,
1013: gmf_incoming_material_layers il,
1014: gmf_outgoing_material_layers ol,
1015: mtl_material_transactions t,
1016: gme_transaction_pairs tp,
1017: gmf_outgoing_material_layers ol2,

Line 1047: gmf_incoming_material_layers il,

1043: decode (t.reverse_id, NULL, ol.layer_doc_qty, ol2.layer_doc_qty) layer_doc_qty,
1044: decode (t.reverse_id, NULL, 'N', 'Y') c_rev_layer,
1045: decode (t.reverse_id, NULL, ol.ROWID, ol2.ROWID) c_rowid
1046: FROM gmf_batch_vib_details v,
1047: gmf_incoming_material_layers il,
1048: gmf_resource_layers ol,
1049: gme_resource_txns t,
1050: gmf_resource_layers ol2,
1051: gme_resource_txns t2

Line 1816: gmf_incoming_material_layers l

1812: CURSOR c_null_consume_layers IS
1813: SELECT v.*, l.layer_doc_qty, l.layer_doc_um, l.mmt_transaction_id, l.lot_number, l.mmt_organization_id
1814: FROM gmf_batch_vib_details v,
1815: gmf_batch_requirements r,
1816: gmf_incoming_material_layers l
1817: WHERE
1818: r.batch_id = p_batch_id AND
1819: v.requirement_id = r.requirement_id AND
1820: l.layer_id = v.prod_layer_id AND

Line 1829: FROM gmf_incoming_material_layers l,

1825:
1826: CURSOR c_last_prod_yield (p_prod_material_detail_id NUMBER) IS
1827: SELECT l.*, t.primary_quantity,
1828: t.inventory_item_id -- Bug 5607069
1829: FROM gmf_incoming_material_layers l,
1830: mtl_material_transactions t,
1831: mtl_transaction_lot_numbers mtln
1832: WHERE
1833: t.trx_source_line_id = p_prod_material_detail_id AND

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

1985: END IF;
1986:
1987: BEGIN
1988:
1989: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
1990: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
1991:
1992:
1993: INSERT INTO gmf_incoming_material_layers(

Line 1993: INSERT INTO gmf_incoming_material_layers(

1989: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
1990: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
1991:
1992:
1993: INSERT INTO gmf_incoming_material_layers(
1994: layer_id,
1995: mmt_transaction_id,
1996: mmt_organization_id,
1997: lot_number,

Line 2112: gmf_incoming_material_layers il,

2108: THEN
2109: SELECT nvl(sum (consume_ib_doc_qty), 0)
2110: INTO l_prev_consume_ib_doc_qty
2111: FROM gmf_batch_vib_details v,
2112: gmf_incoming_material_layers il,
2113: mtl_material_transactions mmt
2114: WHERE
2115: v.requirement_id = req.requirement_id AND
2116: v.consume_layer_id = ing.layer_id AND

Line 2145: gmf_incoming_material_layers il,

2141: SELECT nvl(sum (consume_ib_doc_qty), 0)
2142: INTO l_orig_layer_consumption_qty
2143: FROM gmf_outgoing_material_layers ol,
2144: gmf_batch_vib_details v,
2145: gmf_incoming_material_layers il,
2146: mtl_material_transactions mmt
2147: WHERE
2148: ol.mmt_transaction_id = ing.reverse_id AND
2149: ol.lot_number = ing.lot_number AND

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

2169: END IF;
2170: -- End bug 5607069
2171:
2172: IF l_pseudo_prod_layer_id IS NULL THEN
2173: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2174: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2175:
2176: INSERT INTO gmf_incoming_material_layers(
2177: layer_id,

Line 2176: INSERT INTO gmf_incoming_material_layers(

2172: IF l_pseudo_prod_layer_id IS NULL THEN
2173: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2174: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2175:
2176: INSERT INTO gmf_incoming_material_layers(
2177: layer_id,
2178: mmt_transaction_id,
2179: mmt_organization_id,
2180: lot_number,

Line 2305: gmf_incoming_material_layers il,

2301: THEN
2302: SELECT nvl(sum (consume_ib_doc_qty), 0)
2303: INTO l_prev_consume_ib_doc_qty
2304: FROM gmf_batch_vib_details v,
2305: gmf_incoming_material_layers il,
2306: mtl_material_transactions mmt
2307: WHERE
2308: v.requirement_id = req.requirement_id AND
2309: v.consume_layer_id = rsrc.layer_id AND

Line 2337: gmf_incoming_material_layers il,

2333: SELECT nvl(sum (consume_ib_doc_qty), 0)
2334: INTO l_orig_layer_consumption_qty
2335: FROM gmf_resource_layers rl,
2336: gmf_batch_vib_details v,
2337: gmf_incoming_material_layers il,
2338: mtl_material_transactions mmt
2339: WHERE
2340: rl.poc_trans_id = rsrc.reverse_id AND
2341: v.consume_layer_id = rl.layer_id AND

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

2359: END IF;
2360: -- End bug 5607069
2361:
2362: IF l_pseudo_prod_layer_id IS NULL THEN
2363: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2364: -- Bug 6887598 mmt_organization_id should not be NULL
2365: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2366: INSERT INTO gmf_incoming_material_layers(
2367: layer_id,

Line 2366: INSERT INTO gmf_incoming_material_layers(

2362: IF l_pseudo_prod_layer_id IS NULL THEN
2363: -- Create a pseudo product layer in the gmf_incoming_material_layers table.
2364: -- Bug 6887598 mmt_organization_id should not be NULL
2365: SELECT gmf_layer_id_s.nextval INTO l_pseudo_prod_layer_id FROM DUAL;
2366: INSERT INTO gmf_incoming_material_layers(
2367: layer_id,
2368: mmt_transaction_id,
2369: mmt_organization_id, -- B6887598
2370: lot_number,

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

2575: FND_MSG_PUB.Add;
2576: RAISE;
2577: END;
2578:
2579: -- Delete all rows from gmf_incoming_material_layers which are used in
2580: -- gmf_batch_vib_details with finalize_ind = 1
2581: IF g_debug <= gme_debug.g_log_statement THEN
2582: gme_debug.put_line ('deleting pseudo layers...');
2583: END IF;

Line 2585: DELETE from gmf_incoming_material_layers

2581: IF g_debug <= gme_debug.g_log_statement THEN
2582: gme_debug.put_line ('deleting pseudo layers...');
2583: END IF;
2584:
2585: DELETE from gmf_incoming_material_layers
2586: WHERE
2587: pseudo_layer_id IS NOT NULL AND
2588: layer_id in (
2589: SELECT prod_layer_id

Line 2692: gmf_incoming_material_layers il,

2688: RANK() OVER(partition by hdr.batch_id ORDER BY hdr.batch_id, il.layer_date desc, il.layer_id desc) layer_rank
2689: FROM
2690: gme_batch_header hdr,
2691: sy_orgn_mst orgn,
2692: gmf_incoming_material_layers il,
2693: ic_tran_pnd pnd
2694: WHERE
2695: il.layer_date >= p_start_date
2696: AND il.layer_date <= p_end_date

Line 2713: l_layer_rec gmf_incoming_material_layers%ROWTYPE;

2709: l_co_code cm_cldr_hdr.co_code%TYPE;
2710: l_start_date DATE;
2711: l_end_date DATE;
2712:
2713: l_layer_rec gmf_incoming_material_layers%ROWTYPE;
2714: l_trans_rec ic_tran_pnd%ROWTYPE;
2715:
2716: BEGIN
2717: