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.MSC_CL_AHL_ODS_LOAD dependencies on MSC_ST_WO_TASK_HIERARCHY

Line 790: FROM MSC_ST_WO_TASK_HIERARCHY mswth

786: SELECT mswth.CURR_SUPPLY_ID,
787: mswth.NEXT_SUPPLY_ID,
788: mswth.ORGANIZATION_ID,
789: mswth.SR_INSTANCE_ID
790: FROM MSC_ST_WO_TASK_HIERARCHY mswth
791: WHERE mswth.deleted_flag = MSC_UTIL.SYS_YES
792: AND mswth.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
793: lv_supplies_tbl VARCHAR2(30);
794: type ref_cur is ref cursor;

Line 797: CURR_SUPPLY_ID MSC_ST_WO_TASK_HIERARCHY.CURR_SUPPLY_ID%type,

793: lv_supplies_tbl VARCHAR2(30);
794: type ref_cur is ref cursor;
795: c_ref_cur ref_cur;
796: TYPE cursorRec IS RECORD (
797: CURR_SUPPLY_ID MSC_ST_WO_TASK_HIERARCHY.CURR_SUPPLY_ID%type,
798: NEXT_SUPPLY_ID MSC_ST_WO_TASK_HIERARCHY.NEXT_SUPPLY_ID%type,
799: PRECEDENCE_CONSTRAINT MSC_ST_WO_TASK_HIERARCHY.PRECEDENCE_CONSTRAINT%type,
800: MIN_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MIN_SEPARATION%type,
801: MIN_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MIN_SEP_TIME_UNIT%type,

Line 798: NEXT_SUPPLY_ID MSC_ST_WO_TASK_HIERARCHY.NEXT_SUPPLY_ID%type,

794: type ref_cur is ref cursor;
795: c_ref_cur ref_cur;
796: TYPE cursorRec IS RECORD (
797: CURR_SUPPLY_ID MSC_ST_WO_TASK_HIERARCHY.CURR_SUPPLY_ID%type,
798: NEXT_SUPPLY_ID MSC_ST_WO_TASK_HIERARCHY.NEXT_SUPPLY_ID%type,
799: PRECEDENCE_CONSTRAINT MSC_ST_WO_TASK_HIERARCHY.PRECEDENCE_CONSTRAINT%type,
800: MIN_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MIN_SEPARATION%type,
801: MIN_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MIN_SEP_TIME_UNIT%type,
802: MAX_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MAX_SEPARATION%type,

Line 799: PRECEDENCE_CONSTRAINT MSC_ST_WO_TASK_HIERARCHY.PRECEDENCE_CONSTRAINT%type,

795: c_ref_cur ref_cur;
796: TYPE cursorRec IS RECORD (
797: CURR_SUPPLY_ID MSC_ST_WO_TASK_HIERARCHY.CURR_SUPPLY_ID%type,
798: NEXT_SUPPLY_ID MSC_ST_WO_TASK_HIERARCHY.NEXT_SUPPLY_ID%type,
799: PRECEDENCE_CONSTRAINT MSC_ST_WO_TASK_HIERARCHY.PRECEDENCE_CONSTRAINT%type,
800: MIN_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MIN_SEPARATION%type,
801: MIN_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MIN_SEP_TIME_UNIT%type,
802: MAX_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MAX_SEPARATION%type,
803: MAX_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MAX_SEP_TIME_UNIT%type,

Line 800: MIN_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MIN_SEPARATION%type,

796: TYPE cursorRec IS RECORD (
797: CURR_SUPPLY_ID MSC_ST_WO_TASK_HIERARCHY.CURR_SUPPLY_ID%type,
798: NEXT_SUPPLY_ID MSC_ST_WO_TASK_HIERARCHY.NEXT_SUPPLY_ID%type,
799: PRECEDENCE_CONSTRAINT MSC_ST_WO_TASK_HIERARCHY.PRECEDENCE_CONSTRAINT%type,
800: MIN_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MIN_SEPARATION%type,
801: MIN_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MIN_SEP_TIME_UNIT%type,
802: MAX_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MAX_SEPARATION%type,
803: MAX_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MAX_SEP_TIME_UNIT%type,
804: ORGANIZATION_ID MSC_ST_WO_TASK_HIERARCHY.ORGANIZATION_ID%type,

Line 801: MIN_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MIN_SEP_TIME_UNIT%type,

797: CURR_SUPPLY_ID MSC_ST_WO_TASK_HIERARCHY.CURR_SUPPLY_ID%type,
798: NEXT_SUPPLY_ID MSC_ST_WO_TASK_HIERARCHY.NEXT_SUPPLY_ID%type,
799: PRECEDENCE_CONSTRAINT MSC_ST_WO_TASK_HIERARCHY.PRECEDENCE_CONSTRAINT%type,
800: MIN_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MIN_SEPARATION%type,
801: MIN_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MIN_SEP_TIME_UNIT%type,
802: MAX_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MAX_SEPARATION%type,
803: MAX_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MAX_SEP_TIME_UNIT%type,
804: ORGANIZATION_ID MSC_ST_WO_TASK_HIERARCHY.ORGANIZATION_ID%type,
805: TASK_LINK_ID MSC_ST_WO_TASK_HIERARCHY.TASK_LINK_ID%type,

Line 802: MAX_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MAX_SEPARATION%type,

798: NEXT_SUPPLY_ID MSC_ST_WO_TASK_HIERARCHY.NEXT_SUPPLY_ID%type,
799: PRECEDENCE_CONSTRAINT MSC_ST_WO_TASK_HIERARCHY.PRECEDENCE_CONSTRAINT%type,
800: MIN_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MIN_SEPARATION%type,
801: MIN_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MIN_SEP_TIME_UNIT%type,
802: MAX_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MAX_SEPARATION%type,
803: MAX_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MAX_SEP_TIME_UNIT%type,
804: ORGANIZATION_ID MSC_ST_WO_TASK_HIERARCHY.ORGANIZATION_ID%type,
805: TASK_LINK_ID MSC_ST_WO_TASK_HIERARCHY.TASK_LINK_ID%type,
806: CURRENT_WIP_ENTITY_ID MSC_ST_WO_TASK_HIERARCHY.CURRENT_WIP_ENTITY_ID%type,

Line 803: MAX_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MAX_SEP_TIME_UNIT%type,

799: PRECEDENCE_CONSTRAINT MSC_ST_WO_TASK_HIERARCHY.PRECEDENCE_CONSTRAINT%type,
800: MIN_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MIN_SEPARATION%type,
801: MIN_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MIN_SEP_TIME_UNIT%type,
802: MAX_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MAX_SEPARATION%type,
803: MAX_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MAX_SEP_TIME_UNIT%type,
804: ORGANIZATION_ID MSC_ST_WO_TASK_HIERARCHY.ORGANIZATION_ID%type,
805: TASK_LINK_ID MSC_ST_WO_TASK_HIERARCHY.TASK_LINK_ID%type,
806: CURRENT_WIP_ENTITY_ID MSC_ST_WO_TASK_HIERARCHY.CURRENT_WIP_ENTITY_ID%type,
807: NEXT_WIP_ENTITY_ID MSC_ST_WO_TASK_HIERARCHY.NEXT_WIP_ENTITY_ID%type

Line 804: ORGANIZATION_ID MSC_ST_WO_TASK_HIERARCHY.ORGANIZATION_ID%type,

800: MIN_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MIN_SEPARATION%type,
801: MIN_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MIN_SEP_TIME_UNIT%type,
802: MAX_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MAX_SEPARATION%type,
803: MAX_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MAX_SEP_TIME_UNIT%type,
804: ORGANIZATION_ID MSC_ST_WO_TASK_HIERARCHY.ORGANIZATION_ID%type,
805: TASK_LINK_ID MSC_ST_WO_TASK_HIERARCHY.TASK_LINK_ID%type,
806: CURRENT_WIP_ENTITY_ID MSC_ST_WO_TASK_HIERARCHY.CURRENT_WIP_ENTITY_ID%type,
807: NEXT_WIP_ENTITY_ID MSC_ST_WO_TASK_HIERARCHY.NEXT_WIP_ENTITY_ID%type
808: );

Line 805: TASK_LINK_ID MSC_ST_WO_TASK_HIERARCHY.TASK_LINK_ID%type,

801: MIN_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MIN_SEP_TIME_UNIT%type,
802: MAX_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MAX_SEPARATION%type,
803: MAX_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MAX_SEP_TIME_UNIT%type,
804: ORGANIZATION_ID MSC_ST_WO_TASK_HIERARCHY.ORGANIZATION_ID%type,
805: TASK_LINK_ID MSC_ST_WO_TASK_HIERARCHY.TASK_LINK_ID%type,
806: CURRENT_WIP_ENTITY_ID MSC_ST_WO_TASK_HIERARCHY.CURRENT_WIP_ENTITY_ID%type,
807: NEXT_WIP_ENTITY_ID MSC_ST_WO_TASK_HIERARCHY.NEXT_WIP_ENTITY_ID%type
808: );
809:

Line 806: CURRENT_WIP_ENTITY_ID MSC_ST_WO_TASK_HIERARCHY.CURRENT_WIP_ENTITY_ID%type,

802: MAX_SEPARATION MSC_ST_WO_TASK_HIERARCHY.MAX_SEPARATION%type,
803: MAX_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MAX_SEP_TIME_UNIT%type,
804: ORGANIZATION_ID MSC_ST_WO_TASK_HIERARCHY.ORGANIZATION_ID%type,
805: TASK_LINK_ID MSC_ST_WO_TASK_HIERARCHY.TASK_LINK_ID%type,
806: CURRENT_WIP_ENTITY_ID MSC_ST_WO_TASK_HIERARCHY.CURRENT_WIP_ENTITY_ID%type,
807: NEXT_WIP_ENTITY_ID MSC_ST_WO_TASK_HIERARCHY.NEXT_WIP_ENTITY_ID%type
808: );
809:
810: c_rec cursorRec;

Line 807: NEXT_WIP_ENTITY_ID MSC_ST_WO_TASK_HIERARCHY.NEXT_WIP_ENTITY_ID%type

803: MAX_SEP_TIME_UNIT MSC_ST_WO_TASK_HIERARCHY.MAX_SEP_TIME_UNIT%type,
804: ORGANIZATION_ID MSC_ST_WO_TASK_HIERARCHY.ORGANIZATION_ID%type,
805: TASK_LINK_ID MSC_ST_WO_TASK_HIERARCHY.TASK_LINK_ID%type,
806: CURRENT_WIP_ENTITY_ID MSC_ST_WO_TASK_HIERARCHY.CURRENT_WIP_ENTITY_ID%type,
807: NEXT_WIP_ENTITY_ID MSC_ST_WO_TASK_HIERARCHY.NEXT_WIP_ENTITY_ID%type
808: );
809:
810: c_rec cursorRec;
811: BEGIN

Line 876: ||' FROM MSC_ST_WO_TASK_HIERARCHY mswth, '

872: ||':v_current_date, '
873: ||':v_current_user, '
874: ||':v_current_date, '
875: ||':v_current_user '
876: ||' FROM MSC_ST_WO_TASK_HIERARCHY mswth, '
877: || lv_supplies_tbl||' ms1,'
878: || lv_supplies_tbl||' ms2'
879: ||' WHERE mswth.deleted_flag = '|| MSC_UTIL.SYS_NO
880: ||' AND mswth.SR_INSTANCE_ID= '

Line 941: ||' FROM MSC_ST_WO_TASK_HIERARCHY mswth, '

937: ||'mswth.ORGANIZATION_ID, '
938: ||'mswth.TASK_LINK_ID, '
939: ||'mswth.CURRENT_WIP_ENTITY_ID, '
940: ||'mswth.NEXT_WIP_ENTITY_ID '
941: ||' FROM MSC_ST_WO_TASK_HIERARCHY mswth, '
942: || lv_supplies_tbl||' ms1,'
943: || lv_supplies_tbl||' ms2'
944: ||' WHERE mswth.deleted_flag = '|| MSC_UTIL.SYS_NO
945: ||' AND mswth.SR_INSTANCE_ID= '