DBA Data[Home] [Help]

APPS.GMF_LOT_COSTING_PUB dependencies on GMF_DEPENDENCY_TAB

Line 643: ) AS SYSTEM.gmf_dependency_tab

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
644: )
645: )
646: FROM
647: (

Line 687: ) AS SYSTEM.gmf_dependency_tab

683: ( MULTISET
684: (
685: SELECT SYSTEM.gmf_dependency_type(NULL, NULL, NULL, NULL)
686: FROM DUAL
687: ) AS SYSTEM.gmf_dependency_tab
688: )
689: )
690: FROM
691: ( SELECT DISTINCT/*Bug 4320765*/ gbsd.batchstep_id, gbs2.actual_step_qty, gbs2.step_qty_um

Line 737: ) AS SYSTEM.gmf_dependency_tab

733: ( MULTISET
734: (
735: SELECT SYSTEM.gmf_dependency_type(NULL, NULL, NULL, NULL)
736: FROM DUAL
737: ) AS SYSTEM.gmf_dependency_tab
738: )
739: )
740: FROM DUAL;
741:

Line 770: FROM DUAL) AS SYSTEM.gmf_dependency_tab

766: NULL,
767: NULL,
768: CAST
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 ;