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_DESIGNATORS

Line 449: TYPE designator IS TABLE OF msc_st_designators.designator%TYPE INDEX BY BINARY_INTEGER;

445:
446: d_index NUMBER := 0 ;
447:
448: /* ---------------- Designator declaration ----------------------*/
449: TYPE designator IS TABLE OF msc_st_designators.designator%TYPE INDEX BY BINARY_INTEGER;
450: i_designator designator ;
451:
452: TYPE forecast_set IS TABLE OF msc_st_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;
453: i_forecast_set forecast_set;

Line 452: TYPE forecast_set IS TABLE OF msc_st_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;

448: /* ---------------- Designator declaration ----------------------*/
449: TYPE designator IS TABLE OF msc_st_designators.designator%TYPE INDEX BY BINARY_INTEGER;
450: i_designator designator ;
451:
452: TYPE forecast_set IS TABLE OF msc_st_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;
453: i_forecast_set forecast_set;
454:
455: TYPE description IS TABLE OF msc_st_designators.description%TYPE INDEX BY BINARY_INTEGER;
456: i_description description ;

Line 455: TYPE description IS TABLE OF msc_st_designators.description%TYPE INDEX BY BINARY_INTEGER;

451:
452: TYPE forecast_set IS TABLE OF msc_st_designators.forecast_set%TYPE INDEX BY BINARY_INTEGER;
453: i_forecast_set forecast_set;
454:
455: TYPE description IS TABLE OF msc_st_designators.description%TYPE INDEX BY BINARY_INTEGER;
456: i_description description ;
457:
458: i_disable_date date_idx_tbl;
459: i_consume_forecast number_idx_tbl;

Line 4632: ' INSERT INTO msc_st_designators ( '

4628: || ' and d.trans_qty <> 0 '
4629: || ' ORDER BY wm.mtl_organization_id ,FSET DESC,h.forecast_id ' ;
4630:
4631: l_insert_set_stmt :=
4632: ' INSERT INTO msc_st_designators ( '
4633: ||' designator,forecast_set, organization_id, sr_instance_id, '
4634: ||' description, mps_relief, inventory_atp_flag, '
4635: ||' designator_type,disable_date,consume_forecast, '
4636: ||' update_type,backward_update_time_fence,forward_update_time_fence, '

Line 4972: INSERT INTO msc_st_designators (

4968: i := 1 ;
4969: log_message(i_organization_id.FIRST || ' *Designator*' || i_organization_id.LAST );
4970: IF i_organization_id.FIRST > 0 THEN
4971: FORALL i IN i_organization_id.FIRST..i_organization_id.LAST
4972: INSERT INTO msc_st_designators (
4973: designator,
4974: forecast_set,
4975: organization_id,
4976: sr_instance_id,

Line 5623: ' INSERT INTO msc_st_designators ( '

5619: BEGIN
5620:
5621: g_delimiter := '/';
5622: st_designators :=
5623: ' INSERT INTO msc_st_designators ( '
5624: ||' designator, organization_id, sr_instance_id, '
5625: ||' description, mps_relief, inventory_atp_flag, '
5626: ||' designator_type ) '
5627: ||' VALUES '