eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMP_APS_DS_PULL dependencies on MSC_ST_RESOURCE_REQUIREMENTS

Line 1224: || ' gs.plan_rsrc_count gmd_rsrc_count,' /passed on msc_st_resource_requirements/

1220: || ' DECODE(NVL(o.break_ind,0), 1, 1, 2) breakable_activity_flag , '
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'

Line 2328: INSERT INTO msc_st_resource_requirements (

2324: i := 1 ;
2325: log_message(rr_organization_id.FIRST || ' *rr*' || rr_organization_id.LAST );
2326: IF rr_organization_id.FIRST > 0 THEN
2327: FORALL i IN rr_organization_id.FIRST..rr_organization_id.LAST
2328: INSERT INTO msc_st_resource_requirements (
2329: organization_id,
2330: sr_instance_id,
2331: supply_id,
2332: supply_type, /* kbanddyo B6407864 Need to populate supply_type field */

Line 3139: * msc_st_resource_requirements using the parameters passed in

3135: * insert_resource_requirements
3136: *
3137: * DESCRIPTION
3138: * This procedure wil insert a row into the table
3139: * msc_st_resource_requirements using the parameters passed in
3140: * HISTORY
3141: * M Craig
3142: * 10/13/99 - Added deleted_flag in the insert statement
3143: * 13-SEP-2002 - firm_flag = 1 for WIP steps B2266934

Line 3166: ' INSERT INTO msc_st_resource_requirements ( '

3162: st_resource_requirements VARCHAR2(2000) ;
3163:
3164: BEGIN
3165: st_resource_requirements :=
3166: ' INSERT INTO msc_st_resource_requirements ( '
3167: ||' organization_id, sr_instance_id, supply_id, resource_seq_num,'
3168: ||' resource_id, start_date, end_date, operation_hours_required,'
3169: ||' assigned_units, department_id, wip_entity_id, operation_seq_num, '
3170: ||' deleted_flag, firm_flag, minimum_transfer_quantity, '

Line 3200: log_message('Failure occured during the insert into msc_st_resource_requirements');