DBA Data[Home] [Help]

APPS.GMF_LOT_COSTING_PUB dependencies on GMF_STEP_TYPE

Line 778: , SYSTEM.gmf_step_type

774: CURSOR explosion_cursor
775: ( p_batch_id NUMBER )
776: IS
777: SELECT max(grsd.seq)
778: , SYSTEM.gmf_step_type
779: ( grsd.dep_step_id, gbs.actual_step_qty, gbs.step_qty_um, 0
780: , CAST
781: ( MULTISET
782: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 825: , SYSTEM.gmf_step_type

821: AND gbs.batchstep_id = grsd.dep_step_id
822: GROUP BY grsd.dep_step_id, gbs.actual_step_qty, gbs.step_qty_um
823: UNION ALL
824: SELECT 0
825: , SYSTEM.gmf_step_type
826: ( g.batchstep_id, g.actual_step_qty, g.step_qty_um, 0
827: , CAST
828: ( MULTISET
829: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 875: , SYSTEM.gmf_step_type

871:
872: CURSOR explosion_cursor_nr
873: IS
874: SELECT 0
875: , SYSTEM.gmf_step_type
876: ( 1, 0, NULL, 0
877: , CAST
878: ( MULTISET
879: ( SELECT SYSTEM.gmf_cost_type( 0, ' ', 0, 0, 0)

Line 916: SYSTEM.gmf_step_type

912: --**********************************************************************************************
913: CURSOR explosion_cursor_ss(p_batch_id NUMBER)
914: IS
915: SELECT 0,
916: SYSTEM.gmf_step_type
917: (gbs.batchstep_id,
918: gbs.actual_step_qty,
919: gbs.step_qty_um,
920: 0,