DBA Data[Home] [Help]

APPS.GMF_LOT_COSTING_PUB dependencies on GMF_DEPENDENCY_TYPE

Line 802: SELECT SYSTEM.gmf_dependency_type(a.batchstep_id, b.actual_step_qty, b.step_qty_um, NULL)

798: , NULL, NULL
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

Line 849: SELECT SYSTEM.gmf_dependency_type(NULL, NULL, NULL, NULL)

845: , NULL, NULL
846: , CAST
847: ( MULTISET
848: (
849: SELECT SYSTEM.gmf_dependency_type(NULL, NULL, NULL, NULL)
850: FROM DUAL
851: ) AS SYSTEM.gmf_dependency_tab
852: )
853: )

Line 899: SELECT SYSTEM.gmf_dependency_type(NULL, NULL, NULL, NULL)

895: , NULL, NULL
896: , CAST
897: ( MULTISET
898: (
899: SELECT SYSTEM.gmf_dependency_type(NULL, NULL, NULL, NULL)
900: FROM DUAL
901: ) AS SYSTEM.gmf_dependency_tab
902: )
903: )

Line 933: (MULTISET (SELECT SYSTEM.gmf_dependency_type (NULL, NULL, NULL, NULL)

929: ),
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