DBA Data[Home] [Help]

APPS.GMF_LOT_COSTING_PUB dependencies on GMF_DEPENDENCY_TYPE

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

634: , NULL, NULL
635: , CAST
636: ( MULTISET
637: (
638: SELECT SYSTEM.gmf_dependency_type(a.batchstep_id, b.actual_step_qty, b.step_qty_um, NULL)
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

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

681: , NULL, NULL
682: , CAST
683: ( MULTISET
684: (
685: SELECT SYSTEM.gmf_dependency_type(NULL, NULL, NULL, NULL)
686: FROM DUAL
687: ) AS SYSTEM.gmf_dependency_tab
688: )
689: )

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

731: , NULL, NULL
732: , CAST
733: ( MULTISET
734: (
735: SELECT SYSTEM.gmf_dependency_type(NULL, NULL, NULL, NULL)
736: FROM DUAL
737: ) AS SYSTEM.gmf_dependency_tab
738: )
739: )

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

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