APPS.GMF_LOT_COSTING_PUB dependencies on GME_BATCH_STEPS

Line 639: FROM gme_batch_step_dependencies a, gme_batch_steps b

635: , CAST
636: ( MULTISET
637: (
638: SELECT SYSTEM.gmf_dependency_type(a.batchstep_id, b.actual_step_qty, b.step_qty_um, NULL)
639: FROM gme_batch_step_dependencies a, gme_batch_steps b
640: WHERE a.batch_id = p_batch_id and a.dep_step_id = grsd.dep_step_id
641: AND a.batchstep_id = b.batchstep_id
642: AND a.batch_id = b.batch_id
643: ) AS SYSTEM.gmf_dependency_tab

Line 655: , gme_batch_steps gbs

651: AND batchstep_id NOT IN (SELECT dep_step_id FROM gme_batch_step_dependencies WHERE batch_id=p_batch_id)
652: CONNECT BY PRIOR dep_step_id = batchstep_id AND batch_id = PRIOR batch_id
653: GROUP BY dep_step_id, batchstep_id
654: ) grsd
655: , gme_batch_steps gbs
656: WHERE gbs.batch_id = p_batch_id
657: AND gbs.batchstep_id = grsd.dep_step_id
658: GROUP BY grsd.dep_step_id, gbs.actual_step_qty, gbs.step_qty_um
659: UNION ALL

Line 693: , gme_batch_steps gbs2

689: )
690: FROM
691: ( SELECT DISTINCT/*Bug 4320765*/ gbsd.batchstep_id, gbs2.actual_step_qty, gbs2.step_qty_um
692: FROM gme_batch_step_dependencies gbsd
693: , gme_batch_steps gbs2
694: WHERE gbsd.batch_id = p_batch_id
695: AND gbs2.batch_id = p_batch_id
696: AND gbsd.batchstep_id NOT IN
697: (SELECT dep_step_id from gme_batch_step_dependencies where batch_id = p_batch_id)

Line 773: FROM gme_batch_steps gbs

769: (MULTISET (SELECT SYSTEM.gmf_dependency_type (NULL, NULL, NULL, NULL)
770: FROM DUAL) AS SYSTEM.gmf_dependency_tab
771: )
772: )
773: FROM gme_batch_steps gbs
774: WHERE gbs.batch_id = p_batch_id ;
775:
776:
777: --**********************************************************************************************

Line 786: FROM gme_batch_steps

782:
783: CURSOR steps_cursor (p_batch_id NUMBER)
784: IS
785: SELECT batchstep_no, batchstep_id
786: FROM gme_batch_steps
787: WHERE batch_id = p_batch_id
788: ORDER by batchstep_no;
789:
790: --***************************************************************************************************************

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

4424: procedure_name VARCHAR2(100);
4425:
4426:
4427: TYPE l_independent_steps_type IS TABLE OF
4428: gme_batch_steps.batchstep_id%TYPE INDEX BY BINARY_INTEGER;
4429: l_independent_steps l_independent_steps_type;
4430:
4431: -- we'll add order by...doesn't harm. since data is not setup properly, we'll assume
4432: -- steps are in order, at least.

Line 4439: FROM gme_batch_steps

4435: ** i.e., Steps without any dependency defined */
4436: CURSOR independent_steps_cursor(p_batch_id NUMBER)
4437: IS
4438: SELECT batchstep_id
4439: FROM gme_batch_steps
4440: WHERE batch_id = p_batch_id
4441: AND batchstep_id NOT IN
4442: (
4443: SELECT batchstep_id