APPS.GMP_APS_DS_PULL dependencies on MSC_ST_JOB_OPERATIONS

Line 338: jo_index NUMBER := 0; /* NAMIT :- For msc_st_job_operations */

334: rr_index NUMBER := 0 ;
335: arr_index NUMBER := 0 ;
336: si_index NUMBER := 0 ;
337: inst_indx NUMBER := 0 ; /* NAVIN :- - For Resource Instance */
338: jo_index NUMBER := 0; /* NAMIT :- For msc_st_job_operations */
339:
340: /* ------------------- Supply declaration ---------------------*/
341:
342: s_plan_id number_idx_tbl ;

Line 1225: || ' r.plan_start_date, ' /* populate msc_st_job_operations.reco_start_date */

1221: || ' gs.usage_um ,' --invconv :- sowmya changed this to usage um
1222: || ' r.step_qty_um ,' --invconv :- sowmya changed this to step_qty_um
1223: || ' gri.equipment_item_id ,' /* SOWMYA - As Per latest FDD changes */
1224: || ' gs.plan_rsrc_count gmd_rsrc_count,' /*passed on msc_st_resource_requirements*/
1225: || ' r.plan_start_date, ' /* populate msc_st_job_operations.reco_start_date */
1226: || ' r.plan_cmplt_date, ' /* populate msc_st_job_operations.reco_completion_date */
1227: || ' DECODE(nvl(c.efficiency,0),0,100) ' /*B4320561 - If null then resource is 100%efficient */
1228: || ' FROM'
1229: || ' mtl_units_of_measure'||pdblink||' uom, '

Line 1226: || ' r.plan_cmplt_date, ' /* populate msc_st_job_operations.reco_completion_date */

1222: || ' r.step_qty_um ,' --invconv :- sowmya changed this to step_qty_um
1223: || ' gri.equipment_item_id ,' /* SOWMYA - As Per latest FDD changes */
1224: || ' gs.plan_rsrc_count gmd_rsrc_count,' /*passed on msc_st_resource_requirements*/
1225: || ' r.plan_start_date, ' /* populate msc_st_job_operations.reco_start_date */
1226: || ' r.plan_cmplt_date, ' /* populate msc_st_job_operations.reco_completion_date */
1227: || ' DECODE(nvl(c.efficiency,0),0,100) ' /*B4320561 - If null then resource is 100%efficient */
1228: || ' FROM'
1229: || ' mtl_units_of_measure'||pdblink||' uom, '
1230: || ' mtl_units_of_measure'||pdblink||' uom2, '

Line 1566: /* nsinghi APSK - Insert Step related information in msc_st_job_operations

1562: V_ACTIVITY_GROUP_ID := 0; /* B3995361 rpatangy */
1563: v_seq_dep_usage := 0;
1564: found_chrg_rsrc := 0;
1565: chrg_activity := -1;
1566: /* nsinghi APSK - Insert Step related information in msc_st_job_operations
1567: every time step changes. */
1568:
1569: jo_index := jo_index + 1;
1570: jo_wip_entity_id(jo_index) := rsrc_tab(r).x_batch_id;

Line 2964: INSERT INTO msc_st_job_operations

2960: i := 1 ;
2961: log_message(jo_wip_entity_id.FIRST || ' *jo*' || jo_wip_entity_id.LAST );
2962: IF jo_wip_entity_id.FIRST > 0 THEN
2963: FORALL i IN jo_wip_entity_id.FIRST..jo_wip_entity_id.LAST
2964: INSERT INTO msc_st_job_operations
2965: (
2966: wip_entity_id,
2967: sr_instance_id,
2968: operation_seq_num,