eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_VIB dependencies on GMF_BATCH_REQUIREMENTS_GTMP

Line 163: FROM gmf_batch_requirements_gtmp

159: last_update_login,
160: requirement_id,
161: organization_id,
162: vib_profile_value
163: FROM gmf_batch_requirements_gtmp
164: WHERE batch_id = p_batch_id;
165:
166: IF g_debug <= gme_debug.g_log_statement THEN
167: gme_debug.put_line (sql%ROWCOUNT || ' rows inserted');

Line 293: FROM gmf_batch_requirements_gtmp;

289: last_update_login,
290: requirement_id,
291: organization_id,
292: vib_profile_value
293: FROM gmf_batch_requirements_gtmp;
294:
295: IF g_debug <= gme_debug.g_log_statement THEN
296: gme_debug.put_line (sql%ROWCOUNT || ' rows inserted');
297: END IF;

Line 473: FROM gmf_batch_requirements_gtmp

469:
470: CURSOR c_total_prod_alloc (c_batch_id NUMBER) IS
471: SELECT ing_material_detail_id, batchstep_resource_id,
472: SUM(derived_cost_alloc) total_prod_alloc
473: FROM gmf_batch_requirements_gtmp
474: WHERE batch_id = c_batch_id
475: GROUP BY ing_material_detail_id, batchstep_resource_id;
476:
477:

Line 548: DELETE from gmf_batch_requirements_gtmp;

544:
545: gme_debug.put_line ('profiles. step_dep: ' || l_use_item_step_dep || ' vib: ' || l_vib_profile_value);
546:
547: -- Delete the temp table first
548: DELETE from gmf_batch_requirements_gtmp;
549:
550: -- Get all products and step association
551: IF g_debug <= gme_debug.g_log_statement THEN
552: gme_debug.put_line ('Get all products and step association');

Line 569: INSERT INTO gmf_batch_requirements_gtmp(

565: -- Get all dependant steps for the product step
566: FOR ds IN c_step_dependencies (p_batch_id, p.batchstep_id)
567: LOOP
568: -- insert records into the batch requirements table
569: INSERT INTO gmf_batch_requirements_gtmp(
570: vib_id,
571: batch_id,
572: product_item_id,
573: prod_material_detail_id,

Line 616: INSERT INTO gmf_batch_requirements_gtmp(

612: WHERE batchstep_id = ds.dep_step_id AND
613: s.material_detail_id = m.material_detail_id AND
614: m.line_type <> 1;
615:
616: INSERT INTO gmf_batch_requirements_gtmp(
617: vib_id,
618: batch_id,
619: product_item_id,
620: prod_material_detail_id,

Line 668: INSERT INTO gmf_batch_requirements_gtmp(

664: IF g_debug <= gme_debug.g_log_statement THEN
665: gme_debug.put_line ('Now insert any remaining ingredients which was not used for any product...');
666: END IF;
667:
668: INSERT INTO gmf_batch_requirements_gtmp(
669: vib_id,
670: batch_id,
671: product_item_id,
672: prod_material_detail_id,

Line 719: FROM gmf_batch_requirements_gtmp f

715: nvl(p.cost_alloc,0) <> 0 AND
716: i.line_type <> 1 AND
717: i.material_detail_id NOT IN (
718: SELECT nvl(ing_material_detail_id, -99)
719: FROM gmf_batch_requirements_gtmp f
720: WHERE
721: batch_id = p_batch_id );
722:
723: IF g_debug <= gme_debug.g_log_statement THEN

Line 730: INSERT INTO gmf_batch_requirements_gtmp(

726: END IF;
727:
728: /* Bug 13442362 13367279 Added gme_batch_steps and joins so that index on gme_batch_step_resources is used */
729:
730: INSERT INTO gmf_batch_requirements_gtmp(
731: vib_id,
732: batch_id,
733: product_item_id,
734: prod_material_detail_id,

Line 781: FROM gmf_batch_requirements_gtmp f

777: decode(p.plan_qty, 0, p.wip_plan_qty, p.plan_qty) <> 0 AND
778: nvl(p.cost_alloc,0) <> 0 AND
779: r.batchstep_resource_id NOT IN (
780: SELECT nvl(batchstep_resource_id, -99)
781: FROM gmf_batch_requirements_gtmp f
782: WHERE
783: batch_id = p_batch_id );
784:
785: IF g_debug <= gme_debug.g_log_statement THEN

Line 794: INSERT INTO gmf_batch_requirements_gtmp(

790: IF g_debug <= gme_debug.g_log_statement THEN
791: gme_debug.put_line ('Now insert any product that may have been missed out...');
792: END IF;
793:
794: INSERT INTO gmf_batch_requirements_gtmp(
795: vib_id,
796: batch_id,
797: product_item_id,
798: prod_material_detail_id,

Line 845: FROM gmf_batch_requirements_gtmp f

841: nvl(p.cost_alloc,0) <> 0 AND
842: i.line_type <> 1 AND
843: p.material_detail_id NOT IN (
844: SELECT prod_material_detail_id
845: FROM gmf_batch_requirements_gtmp f
846: WHERE
847: batch_id = p_batch_id );
848: IF g_debug <= gme_debug.g_log_statement THEN
849: gme_debug.put_line (sql%ROWCOUNT || ' rows inserted');

Line 858: INSERT INTO gmf_batch_requirements_gtmp(

854: END IF;
855:
856: /* Bug 13442362 13367279 Added gme_batch_steps and joins so that index on gme_batch_step_resources is used */
857:
858: INSERT INTO gmf_batch_requirements_gtmp(
859: vib_id,
860: batch_id,
861: product_item_id,
862: prod_material_detail_id,

Line 909: FROM gmf_batch_requirements_gtmp f

905: decode(p.plan_qty, 0, p.wip_plan_qty, p.plan_qty) <> 0 AND
906: nvl(p.cost_alloc,0) <> 0 AND
907: p.material_detail_id NOT IN (
908: SELECT prod_material_detail_id
909: FROM gmf_batch_requirements_gtmp f
910: WHERE
911: batch_id = p_batch_id );
912:
913: IF g_debug <= gme_debug.g_log_statement THEN

Line 925: UPDATE gmf_batch_requirements_gtmp

921: END IF;
922:
923: FOR i IN c_total_prod_alloc(p_batch_id) LOOP
924: BEGIN
925: UPDATE gmf_batch_requirements_gtmp
926: SET derived_cost_alloc = derived_cost_alloc/i.total_prod_alloc,
927: required_doc_qty = required_doc_qty/i.total_prod_alloc
928: WHERE
929: batch_id = p_batch_id AND