APPS.GMF_VIB dependencies on MTL_MATERIAL_TRANSACTIONS

Line 1030: mtl_material_transactions t,

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,
1033: mtl_material_transactions t2
1034: WHERE

Line 1033: mtl_material_transactions t2

1029: gmf_outgoing_material_layers ol,
1030: mtl_material_transactions t,
1031: gme_transaction_pairs tp,
1032: gmf_outgoing_material_layers ol2,
1033: mtl_material_transactions t2
1034: WHERE
1035: il.mmt_transaction_id = p_tran_rec.reverse_id AND -- incoming layer of reversed prod yield
1036: -- Bug 6312166. il.mmt_transaction_id = p_tran_rec.transaction_id AND -- incoming layer of reversed prod yield
1037: nvl(il.lot_number, 'x') = nvl(p_tran_rec.lot_number, 'x') AND

Line 1083: mtl_material_transactions mmt,

1079: CURSOR c_ing_layers (p_ing_material_detail_id NUMBER) IS
1080: SELECT mmt.inventory_item_id, mmt.organization_id, /* mtln.lot_number, */ mmt.primary_quantity, msi.primary_uom_code,
1081: mmt.transaction_date, md.line_type, tp.transaction_id2 as reverse_id, l.ROWID, l.*
1082: FROM gmf_outgoing_material_layers l,
1083: mtl_material_transactions mmt,
1084: mtl_system_items_b msi,
1085: gme_material_details md,
1086: gme_transaction_pairs tp
1087: WHERE

Line 1104: mtl_material_transactions mmt,

1100:
1101: CURSOR c_ing_layers_cnt (p_ing_material_detail_id NUMBER) IS -- Bug 8472152 Added cursor
1102: SELECT count(*)
1103: FROM gmf_outgoing_material_layers l,
1104: mtl_material_transactions mmt,
1105: mtl_system_items_b msi,
1106: gme_material_details md,
1107: gme_transaction_pairs tp
1108: WHERE

Line 1892: mtl_material_transactions t

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
1896: t.transaction_source_type_id = 5 AND

Line 1909: FROM gmf_outgoing_material_layers l, mtl_material_transactions t,

1905: CURSOR c_remaining_ing_layers (p_ing_material_detail_id NUMBER) IS
1906: SELECT l.layer_id, l.layer_doc_um, l.remaining_ib_doc_qty, t.inventory_item_id, t.transaction_date,
1907: NULL lot_number, md.line_type, t.primary_quantity, msi.primary_uom_code, l.ROWID, tp.transaction_id2 as reverse_id,
1908: l.layer_doc_qty
1909: FROM gmf_outgoing_material_layers l, mtl_material_transactions t,
1910: gme_material_details md,
1911: mtl_system_items_b msi, gme_transaction_pairs tp
1912: WHERE
1913: t.trx_source_line_id = p_ing_material_detail_id AND

Line 2176: mtl_material_transactions mmt

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
2180: il.layer_id = v.prod_layer_id AND

Line 2209: mtl_material_transactions mmt

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
2213: v.consume_layer_id = ol.layer_id AND

Line 2369: mtl_material_transactions mmt

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
2373: il.layer_id = v.prod_layer_id AND

Line 2401: mtl_material_transactions mmt

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
2405: v.requirement_id = req.requirement_id AND

Line 2917: FROM mtl_material_transactions pnd

2913: EXIT WHEN get_latest_yield%NOTFOUND;
2914:
2915: SELECT pnd.*
2916: INTO l_trans_rec
2917: FROM mtl_material_transactions pnd
2918: WHERE transaction_id = l_layer_rec.trans_id
2919: ;
2920:
2921: dbms_output.put_line('processing layer_id: ' || l_layer_rec.layer_id);