APPS.GMF_LAYERS dependencies on GMF_RESOURCE_LAYERS

Line 786: FROM gmf_resource_layers l,

782: /*HALUTHRA BUG 8299247 Adding NVL for the nvl(-sum(consume_ib_doc_qty),0) and outer join for l.layer_id = v.consume_layer_id(+) */
783:
784: SELECT -sum(nvl(consume_ib_doc_qty,0)), l.ROWID
785: INTO l_rev_consume_ib_doc_qty, l_rowid
786: FROM gmf_resource_layers l,
787: gmf_batch_vib_details v
788: WHERE l.poc_trans_id = p_rsrc_rec.reverse_id and
789: l.layer_id = v.consume_layer_id(+)
790: GROUP BY l.ROWID;

Line 798: UPDATE gmf_resource_layers

794: IF l_rev_consume_ib_doc_qty = 0 THEN
795: l_delete_mark := 1;
796: END IF;
797:
798: UPDATE gmf_resource_layers
799: SET remaining_ib_doc_qty = 0,
800: delete_mark = l_delete_mark
801: WHERE
802: ROWID = l_rowid;

Line 934: INSERT INTO gmf_resource_layers(

930: END;
931: END LOOP;
932: END IF;
933:
934: INSERT INTO gmf_resource_layers(
935: layer_id,
936: poc_trans_id,
937: layer_doc_qty,
938: layer_doc_um,

Line 1115: FROM gmf_resource_layers il

1111: AND t.transaction_source_type_id = 5
1112: );
1113:
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

Line 1244: Quanity CONSUME_IB_DOC_QTY needs to be added to REMAINING_IB_DOC_QTY of gmf_outgoing_material_layers or gmf_resource_layers.

1240: PROD_LAYER_ID (These will be deleted.) CONSUME_LAYER_ID ( Quantity needs to be added to this layer)
1241: CONSUME_LAYER_DATE ( Add quantity if CONSUME_LAYER_DATE is in a past period.
1242: That is CONSUME_LAYER_DATE < (select start_date from gmf_period_statuses where period_id = p_period_id)
1243: CONSUME_IB_DOC_QTY, CONSUME_IB_PRI_QTY.
1244: Quanity CONSUME_IB_DOC_QTY needs to be added to REMAINING_IB_DOC_QTY of gmf_outgoing_material_layers or gmf_resource_layers.
1245: Note that CONSUME_LAYER_ID could either belong to gmf_outgoing_material_layers or gmf_resource_layers.
1246: LINE_TYPE will decide whether it is outgoing layer or resource layer.
1247:
1248: */

Line 1245: Note that CONSUME_LAYER_ID could either belong to gmf_outgoing_material_layers or gmf_resource_layers.

1241: CONSUME_LAYER_DATE ( Add quantity if CONSUME_LAYER_DATE is in a past period.
1242: That is CONSUME_LAYER_DATE < (select start_date from gmf_period_statuses where period_id = p_period_id)
1243: CONSUME_IB_DOC_QTY, CONSUME_IB_PRI_QTY.
1244: Quanity CONSUME_IB_DOC_QTY needs to be added to REMAINING_IB_DOC_QTY of gmf_outgoing_material_layers or gmf_resource_layers.
1245: Note that CONSUME_LAYER_ID could either belong to gmf_outgoing_material_layers or gmf_resource_layers.
1246: LINE_TYPE will decide whether it is outgoing layer or resource layer.
1247:
1248: */
1249: FOR vib IN CUR_VIB_DETAILS LOOP

Line 1259: Update gmf_resource_layers

1255: where layer_id = vib.CONSUME_LAYER_ID;
1256:
1257: ELSIF vib.LINE_TYPE = 0 THEN
1258:
1259: Update gmf_resource_layers
1260: set REMAINING_IB_DOC_QTY = REMAINING_IB_DOC_QTY + vib.CONSUME_IB_DOC_QTY
1261: where layer_id = vib.CONSUME_LAYER_ID;
1262:
1263: ELSE

Line 1301: FROM gmf_resource_layers il

1297: AND t.transaction_date >= l_start_date
1298: );
1299:
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

Line 1751: FROM gmf_resource_layers

1747: ROWID = t.r_id;
1748:
1749: SELECT count(*)
1750: INTO l_count
1751: FROM gmf_resource_layers
1752: WHERE
1753: poc_trans_id = rt.poc_trans_id;
1754:
1755: IF l_count = 0 THEN