DBA Data[Home] [Help]

APPS.GMF_LAYERS dependencies on GMF_RESOURCE_LAYERS

Line 757: FROM gmf_resource_layers l,

753: -- We need to leave that much qty to reverse those VIB details later.
754: BEGIN
755: SELECT -sum(consume_ib_doc_qty), l.ROWID
756: INTO l_rev_consume_ib_doc_qty, l_rowid
757: FROM gmf_resource_layers l,
758: gmf_batch_vib_details v
759: WHERE l.poc_trans_id = p_rsrc_rec.reverse_id and
760: l.layer_id = v.consume_layer_id
761: GROUP BY l.ROWID;

Line 769: UPDATE gmf_resource_layers

765: IF l_rev_consume_ib_doc_qty = 0 THEN
766: l_delete_mark := 1;
767: END IF;
768:
769: UPDATE gmf_resource_layers
770: SET remaining_ib_doc_qty = 0,
771: delete_mark = l_delete_mark
772: WHERE
773: ROWID = l_rowid;

Line 904: INSERT INTO gmf_resource_layers(

900: END;
901: END LOOP;
902: END IF;
903:
904: INSERT INTO gmf_resource_layers(
905: layer_id,
906: poc_trans_id,
907: layer_doc_qty,
908: layer_doc_um,