DBA Data[Home] [Help]

APPS.GMD_DISP_PUB dependencies on GMD_INVENTORY_SPEC_VRS

Line 909: FROM gmd_inventory_spec_vrs

905: SELECT control_lot_attrib_ind,
906: in_spec_lot_status_id,
907: out_of_spec_lot_status_id,
908: null
909: FROM gmd_inventory_spec_vrs
910: WHERE spec_vr_id = l_spec_vr_id
911: UNION ALL
912: SELECT control_lot_attrib_ind,
913: in_spec_lot_status_id,

Line 928: FROM GMD_INVENTORY_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
928: FROM GMD_INVENTORY_SPEC_VRS
929: WHERE spec_vr_id = l_spec_vr_id
930: UNION ALL
931: SELECT delayed_lot_entry
932: FROM GMD_WIP_SPEC_VRS

Line 941: FROM GMD_INVENTORY_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
941: FROM GMD_INVENTORY_SPEC_VRS
942: WHERE spec_vr_id = l_spec_vr_id
943: UNION ALL
944: SELECT delayed_lpn_entry
945: FROM GMD_WIP_SPEC_VRS