[Home] [Help]
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
1052: WHERE
1053: il.mmt_transaction_id = p_tran_rec.reverse_id AND
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
1052: WHERE
1053: il.mmt_transaction_id = p_tran_rec.reverse_id AND
1054: nvl(il.lot_number, '@@@') = nvl(p_tran_rec.lot_number, '@@@') AND
1055: v.prod_layer_id = il.layer_id AND
1087:
1088:
1089: CURSOR c_rsrc_layers (p_batchstep_resource_id NUMBER) IS
1090: SELECT p.resource_usage, p.trans_qty_um as trans_um, p.trans_date, p.line_type, p.reverse_id, p.organization_id, l.ROWID, l.*
1091: FROM gmf_resource_layers l, gme_resource_txns p
1092: WHERE
1093: p.doc_type = 'PROD' AND
1094: p.doc_id = p_tran_rec.transaction_source_id AND
1095: p.line_id = p_batchstep_resource_id AND
1866: CURSOR c_remaining_rsrc_layers (p_batchstep_resource_id NUMBER) IS
1867: SELECT l.layer_id, l.layer_doc_um, l.remaining_ib_doc_qty, t.line_type, t.trans_date,
1868: t.resource_usage, t.trans_qty_um trans_um, l.ROWID, t.reverse_id, l.layer_doc_qty
1869: FROM gmf_resource_layers l,
1870: gme_resource_txns t
1871: WHERE
1872: l.poc_trans_id = t.poc_trans_id AND
1873: t.line_id = p_batchstep_resource_id AND
1874: l.remaining_ib_doc_qty <> 0 and