DBA Data[Home] [Help]

APPS.GMF_LOT_COSTING_PUB dependencies on GMF_DEPENDENCY_TAB

Line 807: ) AS SYSTEM.gmf_dependency_tab

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
808: )
809: )
810: FROM
811: (

Line 851: ) AS SYSTEM.gmf_dependency_tab

847: ( MULTISET
848: (
849: SELECT SYSTEM.gmf_dependency_type(NULL, NULL, NULL, NULL)
850: FROM DUAL
851: ) AS SYSTEM.gmf_dependency_tab
852: )
853: )
854: FROM
855: ( SELECT DISTINCT/*Bug 4320765*/ gbsd.batchstep_id, gbs2.actual_step_qty, gbs2.step_qty_um

Line 901: ) AS SYSTEM.gmf_dependency_tab

897: ( MULTISET
898: (
899: SELECT SYSTEM.gmf_dependency_type(NULL, NULL, NULL, NULL)
900: FROM DUAL
901: ) AS SYSTEM.gmf_dependency_tab
902: )
903: )
904: FROM DUAL;
905:

Line 934: FROM DUAL) AS SYSTEM.gmf_dependency_tab

930: NULL,
931: NULL,
932: CAST
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 ;