APPS.GMD_SPEC_VRS_GRP dependencies on GMD_OPERATIONS

Line 1745: , gmd_operations o

1741:
1742: CURSOR c_batchstep IS
1743: SELECT bs.batchstep_no
1744: FROM gme_batch_steps bs
1745: , gmd_operations o
1746: WHERE bs.oprn_id = o.oprn_id
1747: AND o.delete_mark = 0
1748: AND bs.delete_mark = 0
1749: AND NVL( l_wip_vr.oprn_id, o.oprn_id) = o.oprn_id

Line 1758: , gmd_operations o

1754:
1755: CURSOR c_routingstep IS
1756: SELECT rd.routingstep_no
1757: FROM fm_rout_dtl rd
1758: , gmd_operations o
1759: WHERE rd.oprn_id = o.oprn_id
1760: AND o.delete_mark = 0
1761: AND NVL( l_wip_vr.oprn_id, o.oprn_id) = o.oprn_id
1762: AND NVL( l_wip_vr.oprn_no, o.oprn_no) = o.oprn_no

Line 1770: FROM gmd_operations o

1766:
1767:
1768: CURSOR c_oprn IS
1769: SELECT oprn_no, oprn_vers
1770: FROM gmd_operations o
1771: WHERE o.delete_mark = 0
1772: AND o.oprn_id = l_wip_vr.oprn_id;
1773:
1774: dummy PLS_INTEGER;

Line 1788: l_oprn_no GMD_OPERATIONS.OPRN_NO%TYPE;

1784: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
1785: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
1786: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
1787: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;
1788: l_oprn_no GMD_OPERATIONS.OPRN_NO%TYPE;
1789: l_oprn_vers GMD_OPERATIONS.OPRN_VERS%TYPE;
1790: l_sample_display GMD_SAMPLES_GRP.sample_display_rec;
1791:
1792: BEGIN

Line 1789: l_oprn_vers GMD_OPERATIONS.OPRN_VERS%TYPE;

1785: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
1786: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
1787: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;
1788: l_oprn_no GMD_OPERATIONS.OPRN_NO%TYPE;
1789: l_oprn_vers GMD_OPERATIONS.OPRN_VERS%TYPE;
1790: l_sample_display GMD_SAMPLES_GRP.sample_display_rec;
1791:
1792: BEGIN
1793: l_wip_vr := p_wip_vr;