APPS.GMF_LOT_COSTING_PUB dependencies on GME_BATCH_STEP_DEPENDENCIES

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 813: FROM gme_batch_step_dependencies

809: )
810: FROM
811: (
812: SELECT MAX(level) seq, dep_step_id, batchstep_id
813: FROM gme_batch_step_dependencies
814: START WITH batch_id = p_batch_id
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

Line 815: AND batchstep_id NOT IN (SELECT dep_step_id FROM gme_batch_step_dependencies WHERE batch_id=p_batch_id)

811: (
812: SELECT MAX(level) seq, dep_step_id, batchstep_id
813: FROM gme_batch_step_dependencies
814: START WITH batch_id = p_batch_id
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

Line 856: FROM gme_batch_step_dependencies gbsd

852: )
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

Line 861: (SELECT dep_step_id from gme_batch_step_dependencies where batch_id = p_batch_id)

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)
862: AND gbsd.batchstep_id = gbs2.batchstep_id ) g
863: ORDER BY 1 desc;
864: --**********************************************************************************************
865: -- *

Line 5003: --* virtual rows in gme_batch_step_dependencies

4999: --* 15-Dec-2004 Dinesh Vadivel Bug# 4053149
5000: --* Earlier we were handling only two cases in the step dependency chain
5001: --* 1. if no routing call the explosion_cursor_nr.
5002: --* 2. if there is routing and dependent_steps == 0 then we will create n-1
5003: --* virtual rows in gme_batch_step_dependencies
5004: --* Now changed the code to handle the following cases if there is routing present
5005: --* 1. All the steps have Dependency defined - Directly call the explosion_cursor
5006: --* 2. Single Step Batch. Obviously No Dependency - So call explosion_cursor_ss
5007: --* 3. All steps are Independent. Here create n-1 virtual rows in dependency table

Line 5087: FROM gme_batch_step_dependencies

5083: WHERE batch_id = p_batch_id
5084: AND batchstep_id NOT IN
5085: (
5086: SELECT batchstep_id
5087: FROM gme_batch_step_dependencies
5088: WHERE batch_id = p_batch_id
5089: UNION ALL
5090: SELECT dep_step_id
5091: FROM gme_batch_step_dependencies

Line 5091: FROM gme_batch_step_dependencies

5087: FROM gme_batch_step_dependencies
5088: WHERE batch_id = p_batch_id
5089: UNION ALL
5090: SELECT dep_step_id
5091: FROM gme_batch_step_dependencies
5092: WHERE batch_id = p_batch_id
5093: )
5094: ORDER BY batchstep_id
5095: ;

Line 5195: FROM gme_batch_step_dependencies

5191: fnd_file.put_line(fnd_file.log,' Entering else part of l_routing=0');
5192: END IF;
5193:
5194: SELECT count(*) INTO l_dep_steps
5195: FROM gme_batch_step_dependencies
5196: WHERE batch_id = transaction_row.doc_id;
5197:
5198: /******* Dinesh Vadivel - Bug 4053149 - Start ********/
5199:

Line 5259: INSERT INTO gme_batch_step_dependencies

5255:
5256: FOR step_row IN steps_cursor(transaction_row.doc_id)
5257: LOOP
5258: IF i > 0 THEN
5259: INSERT INTO gme_batch_step_dependencies
5260: ( batch_id
5261: , batchstep_id
5262: , dep_step_id
5263: , standard_delay

Line 5291: DELETE FROM gme_batch_step_dependencies

5287: OPEN explosion_cursor (transaction_row.doc_id);
5288: FETCH explosion_cursor BULK COLLECT INTO l_step_lev, l_step_tab;
5289: CLOSE explosion_cursor;
5290:
5291: DELETE FROM gme_batch_step_dependencies
5292: WHERE batch_id = transaction_row.doc_id;
5293: -- END OF CASE 3
5294:
5295:

Line 5309: FROM gme_batch_step_dependencies

5305: END IF;
5306:
5307: SELECT MIN(dep_step_id)
5308: INTO l_min_dep_step_id
5309: FROM gme_batch_step_dependencies
5310: START WITH batch_id = transaction_row.doc_id
5311: AND batchstep_id NOT IN (SELECT dep_step_id
5312: FROM gme_batch_step_dependencies
5313: WHERE batch_id = transaction_row.doc_id)

Line 5312: FROM gme_batch_step_dependencies

5308: INTO l_min_dep_step_id
5309: FROM gme_batch_step_dependencies
5310: START WITH batch_id = transaction_row.doc_id
5311: AND batchstep_id NOT IN (SELECT dep_step_id
5312: FROM gme_batch_step_dependencies
5313: WHERE batch_id = transaction_row.doc_id)
5314: CONNECT BY PRIOR dep_step_id = batchstep_id
5315: AND batch_id = PRIOR batch_id;
5316:

Line 5337: INSERT INTO gme_batch_step_dependencies

5333:
5334:
5335: FOR i IN 1..l_independent_steps_cnt
5336: LOOP
5337: INSERT INTO gme_batch_step_dependencies
5338: ( batch_id
5339: , batchstep_id
5340: , dep_step_id
5341: , standard_delay

Line 5380: DELETE FROM gme_batch_step_dependencies

5376: */
5377:
5378: FOR i IN 1 .. l_independent_steps_cnt
5379: LOOP
5380: DELETE FROM gme_batch_step_dependencies
5381: WHERE batch_id = transaction_row.doc_id
5382: AND dep_step_id = l_independent_steps(i);
5383: END LOOP;
5384: