APPS.GMF_LOT_COSTING_PUB dependencies on GME_BATCH_STEPS

Line 803: FROM gme_batch_step_dependencies a, gme_batch_steps b

799: , CAST
800: ( MULTISET
801: (
802: SELECT SYSTEM.gmf_dependency_type(a.batchstep_id, b.actual_step_qty, b.step_qty_um, NULL)
803: FROM gme_batch_step_dependencies a, gme_batch_steps b
804: WHERE a.batch_id = p_batch_id and a.dep_step_id = grsd.dep_step_id
805: AND a.batchstep_id = b.batchstep_id
806: AND a.batch_id = b.batch_id
807: ) AS SYSTEM.gmf_dependency_tab

Line 819: , gme_batch_steps gbs

815: AND batchstep_id NOT IN (SELECT dep_step_id FROM gme_batch_step_dependencies WHERE batch_id=p_batch_id)
816: CONNECT BY PRIOR dep_step_id = batchstep_id AND batch_id = PRIOR batch_id
817: GROUP BY dep_step_id, batchstep_id
818: ) grsd
819: , gme_batch_steps gbs
820: WHERE gbs.batch_id = p_batch_id
821: AND gbs.batchstep_id = grsd.dep_step_id
822: GROUP BY grsd.dep_step_id, gbs.actual_step_qty, gbs.step_qty_um
823: UNION ALL

Line 857: , gme_batch_steps gbs2

853: )
854: FROM
855: ( SELECT DISTINCT/*Bug 4320765*/ gbsd.batchstep_id, gbs2.actual_step_qty, gbs2.step_qty_um
856: FROM gme_batch_step_dependencies gbsd
857: , gme_batch_steps gbs2
858: WHERE gbsd.batch_id = p_batch_id
859: AND gbs2.batch_id = p_batch_id
860: AND gbsd.batchstep_id NOT IN
861: (SELECT dep_step_id from gme_batch_step_dependencies where batch_id = p_batch_id)

Line 937: FROM gme_batch_steps gbs

933: (MULTISET (SELECT SYSTEM.gmf_dependency_type (NULL, NULL, NULL, NULL)
934: FROM DUAL) AS SYSTEM.gmf_dependency_tab
935: )
936: )
937: FROM gme_batch_steps gbs
938: WHERE gbs.batch_id = p_batch_id ;
939:
940:
941: --**********************************************************************************************

Line 950: FROM gme_batch_steps

946:
947: CURSOR steps_cursor (p_batch_id NUMBER)
948: IS
949: SELECT batchstep_no, batchstep_id
950: FROM gme_batch_steps
951: WHERE batch_id = p_batch_id
952: ORDER by batchstep_no;
953:
954: --***************************************************************************************************************

Line 5071: gme_batch_steps.batchstep_id%TYPE INDEX BY BINARY_INTEGER;

5067: l_independent_steps_cnt NUMBER;
5068: procedure_name VARCHAR2(100);
5069:
5070: TYPE l_independent_steps_type IS TABLE OF
5071: gme_batch_steps.batchstep_id%TYPE INDEX BY BINARY_INTEGER;
5072: l_independent_steps l_independent_steps_type;
5073:
5074: -- we'll add order by...doesn't harm. since data is not setup properly, we'll assume
5075: -- steps are in order, at least.

Line 5082: FROM gme_batch_steps

5078: ** i.e., Steps without any dependency defined */
5079: CURSOR independent_steps_cursor(p_batch_id NUMBER)
5080: IS
5081: SELECT batchstep_id
5082: FROM gme_batch_steps
5083: WHERE batch_id = p_batch_id
5084: AND batchstep_id NOT IN
5085: (
5086: SELECT batchstep_id