APPS.GMD_SPEC_VRS_GRP dependencies on GMD_OPERATIONS

Line 1794: , gmd_operations o

1790:
1791: CURSOR c_batchstep IS
1792: SELECT bs.batchstep_no
1793: FROM gme_batch_steps bs
1794: , gmd_operations o
1795: WHERE bs.oprn_id = o.oprn_id
1796: AND o.delete_mark = 0
1797: AND bs.delete_mark = 0
1798: AND NVL( l_wip_vr.oprn_id, o.oprn_id) = o.oprn_id

Line 1807: , gmd_operations o

1803:
1804: CURSOR c_routingstep IS
1805: SELECT rd.routingstep_no
1806: FROM fm_rout_dtl rd
1807: , gmd_operations o
1808: WHERE rd.oprn_id = o.oprn_id
1809: AND o.delete_mark = 0
1810: AND NVL( l_wip_vr.oprn_id, o.oprn_id) = o.oprn_id
1811: AND NVL( l_wip_vr.oprn_no, o.oprn_no) = o.oprn_no

Line 1819: FROM gmd_operations o

1815:
1816:
1817: CURSOR c_oprn IS
1818: SELECT oprn_no, oprn_vers
1819: FROM gmd_operations o
1820: WHERE o.delete_mark = 0
1821: AND o.oprn_id = l_wip_vr.oprn_id;
1822:
1823: -- 8901257 start

Line 1887: l_oprn_no GMD_OPERATIONS.OPRN_NO%TYPE;

1883: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
1884: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
1885: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
1886: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;
1887: l_oprn_no GMD_OPERATIONS.OPRN_NO%TYPE;
1888: l_oprn_vers GMD_OPERATIONS.OPRN_VERS%TYPE;
1889: l_sample_display GMD_SAMPLES_GRP.sample_display_rec;
1890:
1891: BEGIN

Line 1888: l_oprn_vers GMD_OPERATIONS.OPRN_VERS%TYPE;

1884: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
1885: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
1886: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;
1887: l_oprn_no GMD_OPERATIONS.OPRN_NO%TYPE;
1888: l_oprn_vers GMD_OPERATIONS.OPRN_VERS%TYPE;
1889: l_sample_display GMD_SAMPLES_GRP.sample_display_rec;
1890:
1891: BEGIN
1892: l_wip_vr := p_wip_vr;