DBA Data[Home] [Help]

APPS.GMD_DISP_PUB dependencies on GMD_SUPPLIER_SPEC_VRS

Line 923: FROM gmd_supplier_spec_vrs

919: SELECT control_lot_attrib_ind,
920: in_spec_lot_status_id,
921: out_of_spec_lot_status_id,
922: null
923: FROM gmd_supplier_spec_vrs
924: WHERE spec_vr_id = l_spec_vr_id ;
925:
926: CURSOR cr_get_delayed_lot_entry IS
927: SELECT delayed_lot_entry

Line 936: FROM GMD_SUPPLIER_SPEC_VRS

932: FROM GMD_WIP_SPEC_VRS
933: WHERE spec_vr_id = l_spec_vr_id
934: UNION ALL
935: SELECT delayed_lot_entry
936: FROM GMD_SUPPLIER_SPEC_VRS
937: WHERE spec_vr_id = l_spec_vr_id ;
938:
939: CURSOR cr_get_delayed_lpn_entry IS
940: SELECT delayed_lpn_entry

Line 949: FROM GMD_SUPPLIER_SPEC_VRS

945: FROM GMD_WIP_SPEC_VRS
946: WHERE spec_vr_id = l_spec_vr_id
947: UNION ALL
948: SELECT delayed_lpn_entry
949: FROM GMD_SUPPLIER_SPEC_VRS
950: WHERE spec_vr_id = l_spec_vr_id ;
951:
952: BEGIN
953: IF (l_debug = 'Y') THEN