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_OPERATION_REL

Line 1071: FROM MSC_ST_WO_OPERATION_REL mswor

1067: mswor.TO_OP_SEQ_NUM,
1068: mswor.TO_OP_RES_SEQ_NUM,
1069: mswor.ORGANIZATION_ID,
1070: mswor.SR_INSTANCE_ID
1071: FROM MSC_ST_WO_OPERATION_REL mswor
1072: WHERE mswor.deleted_flag = MSC_UTIL.SYS_YES
1073: AND mswor.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
1074:
1075: lv_supplies_tbl VARCHAR2(30);

Line 1079: SUPPLY_ID MSC_ST_WO_OPERATION_REL.SUPPLY_ID%type,

1075: lv_supplies_tbl VARCHAR2(30);
1076: type ref_cur is ref cursor;
1077: c_ref_cur ref_cur;
1078: TYPE cursorRec IS RECORD (
1079: SUPPLY_ID MSC_ST_WO_OPERATION_REL.SUPPLY_ID%type,
1080: PRECEDENCE_CONSTRAINT MSC_ST_WO_OPERATION_REL.PRECEDENCE_CONSTRAINT%type,
1081: MIN_SEPARATION MSC_ST_WO_OPERATION_REL.MIN_SEPARATION%type,
1082: MIN_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MIN_SEP_TIME_UNIT%type,
1083: MAX_SEPARATION MSC_ST_WO_OPERATION_REL.MAX_SEPARATION%type,

Line 1080: PRECEDENCE_CONSTRAINT MSC_ST_WO_OPERATION_REL.PRECEDENCE_CONSTRAINT%type,

1076: type ref_cur is ref cursor;
1077: c_ref_cur ref_cur;
1078: TYPE cursorRec IS RECORD (
1079: SUPPLY_ID MSC_ST_WO_OPERATION_REL.SUPPLY_ID%type,
1080: PRECEDENCE_CONSTRAINT MSC_ST_WO_OPERATION_REL.PRECEDENCE_CONSTRAINT%type,
1081: MIN_SEPARATION MSC_ST_WO_OPERATION_REL.MIN_SEPARATION%type,
1082: MIN_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MIN_SEP_TIME_UNIT%type,
1083: MAX_SEPARATION MSC_ST_WO_OPERATION_REL.MAX_SEPARATION%type,
1084: MAX_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MAX_SEP_TIME_UNIT%type,

Line 1081: MIN_SEPARATION MSC_ST_WO_OPERATION_REL.MIN_SEPARATION%type,

1077: c_ref_cur ref_cur;
1078: TYPE cursorRec IS RECORD (
1079: SUPPLY_ID MSC_ST_WO_OPERATION_REL.SUPPLY_ID%type,
1080: PRECEDENCE_CONSTRAINT MSC_ST_WO_OPERATION_REL.PRECEDENCE_CONSTRAINT%type,
1081: MIN_SEPARATION MSC_ST_WO_OPERATION_REL.MIN_SEPARATION%type,
1082: MIN_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MIN_SEP_TIME_UNIT%type,
1083: MAX_SEPARATION MSC_ST_WO_OPERATION_REL.MAX_SEPARATION%type,
1084: MAX_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MAX_SEP_TIME_UNIT%type,
1085: FROM_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_SEQ_NUM%type,

Line 1082: MIN_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MIN_SEP_TIME_UNIT%type,

1078: TYPE cursorRec IS RECORD (
1079: SUPPLY_ID MSC_ST_WO_OPERATION_REL.SUPPLY_ID%type,
1080: PRECEDENCE_CONSTRAINT MSC_ST_WO_OPERATION_REL.PRECEDENCE_CONSTRAINT%type,
1081: MIN_SEPARATION MSC_ST_WO_OPERATION_REL.MIN_SEPARATION%type,
1082: MIN_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MIN_SEP_TIME_UNIT%type,
1083: MAX_SEPARATION MSC_ST_WO_OPERATION_REL.MAX_SEPARATION%type,
1084: MAX_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MAX_SEP_TIME_UNIT%type,
1085: FROM_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_SEQ_NUM%type,
1086: FROM_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_RES_SEQ_NUM%type,

Line 1083: MAX_SEPARATION MSC_ST_WO_OPERATION_REL.MAX_SEPARATION%type,

1079: SUPPLY_ID MSC_ST_WO_OPERATION_REL.SUPPLY_ID%type,
1080: PRECEDENCE_CONSTRAINT MSC_ST_WO_OPERATION_REL.PRECEDENCE_CONSTRAINT%type,
1081: MIN_SEPARATION MSC_ST_WO_OPERATION_REL.MIN_SEPARATION%type,
1082: MIN_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MIN_SEP_TIME_UNIT%type,
1083: MAX_SEPARATION MSC_ST_WO_OPERATION_REL.MAX_SEPARATION%type,
1084: MAX_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MAX_SEP_TIME_UNIT%type,
1085: FROM_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_SEQ_NUM%type,
1086: FROM_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_RES_SEQ_NUM%type,
1087: FROM_OP_DESC MSC_ST_WO_OPERATION_REL.FROM_OP_DESC%type,

Line 1084: MAX_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MAX_SEP_TIME_UNIT%type,

1080: PRECEDENCE_CONSTRAINT MSC_ST_WO_OPERATION_REL.PRECEDENCE_CONSTRAINT%type,
1081: MIN_SEPARATION MSC_ST_WO_OPERATION_REL.MIN_SEPARATION%type,
1082: MIN_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MIN_SEP_TIME_UNIT%type,
1083: MAX_SEPARATION MSC_ST_WO_OPERATION_REL.MAX_SEPARATION%type,
1084: MAX_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MAX_SEP_TIME_UNIT%type,
1085: FROM_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_SEQ_NUM%type,
1086: FROM_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_RES_SEQ_NUM%type,
1087: FROM_OP_DESC MSC_ST_WO_OPERATION_REL.FROM_OP_DESC%type,
1088: TO_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_SEQ_NUM%type,

Line 1085: FROM_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_SEQ_NUM%type,

1081: MIN_SEPARATION MSC_ST_WO_OPERATION_REL.MIN_SEPARATION%type,
1082: MIN_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MIN_SEP_TIME_UNIT%type,
1083: MAX_SEPARATION MSC_ST_WO_OPERATION_REL.MAX_SEPARATION%type,
1084: MAX_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MAX_SEP_TIME_UNIT%type,
1085: FROM_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_SEQ_NUM%type,
1086: FROM_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_RES_SEQ_NUM%type,
1087: FROM_OP_DESC MSC_ST_WO_OPERATION_REL.FROM_OP_DESC%type,
1088: TO_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_SEQ_NUM%type,
1089: TO_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_RES_SEQ_NUM%type,

Line 1086: FROM_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_RES_SEQ_NUM%type,

1082: MIN_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MIN_SEP_TIME_UNIT%type,
1083: MAX_SEPARATION MSC_ST_WO_OPERATION_REL.MAX_SEPARATION%type,
1084: MAX_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MAX_SEP_TIME_UNIT%type,
1085: FROM_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_SEQ_NUM%type,
1086: FROM_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_RES_SEQ_NUM%type,
1087: FROM_OP_DESC MSC_ST_WO_OPERATION_REL.FROM_OP_DESC%type,
1088: TO_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_SEQ_NUM%type,
1089: TO_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_RES_SEQ_NUM%type,
1090: TO_OP_DESC MSC_ST_WO_OPERATION_REL.TO_OP_DESC%type,

Line 1087: FROM_OP_DESC MSC_ST_WO_OPERATION_REL.FROM_OP_DESC%type,

1083: MAX_SEPARATION MSC_ST_WO_OPERATION_REL.MAX_SEPARATION%type,
1084: MAX_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MAX_SEP_TIME_UNIT%type,
1085: FROM_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_SEQ_NUM%type,
1086: FROM_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_RES_SEQ_NUM%type,
1087: FROM_OP_DESC MSC_ST_WO_OPERATION_REL.FROM_OP_DESC%type,
1088: TO_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_SEQ_NUM%type,
1089: TO_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_RES_SEQ_NUM%type,
1090: TO_OP_DESC MSC_ST_WO_OPERATION_REL.TO_OP_DESC%type,
1091: ORGANIZATION_ID MSC_ST_WO_OPERATION_REL.ORGANIZATION_ID%type,

Line 1088: TO_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_SEQ_NUM%type,

1084: MAX_SEP_TIME_UNIT MSC_ST_WO_OPERATION_REL.MAX_SEP_TIME_UNIT%type,
1085: FROM_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_SEQ_NUM%type,
1086: FROM_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_RES_SEQ_NUM%type,
1087: FROM_OP_DESC MSC_ST_WO_OPERATION_REL.FROM_OP_DESC%type,
1088: TO_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_SEQ_NUM%type,
1089: TO_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_RES_SEQ_NUM%type,
1090: TO_OP_DESC MSC_ST_WO_OPERATION_REL.TO_OP_DESC%type,
1091: ORGANIZATION_ID MSC_ST_WO_OPERATION_REL.ORGANIZATION_ID%type,
1092: WORKORDER_ID MSC_ST_WO_OPERATION_REL.WORKORDER_ID%type,

Line 1089: TO_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_RES_SEQ_NUM%type,

1085: FROM_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_SEQ_NUM%type,
1086: FROM_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_RES_SEQ_NUM%type,
1087: FROM_OP_DESC MSC_ST_WO_OPERATION_REL.FROM_OP_DESC%type,
1088: TO_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_SEQ_NUM%type,
1089: TO_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_RES_SEQ_NUM%type,
1090: TO_OP_DESC MSC_ST_WO_OPERATION_REL.TO_OP_DESC%type,
1091: ORGANIZATION_ID MSC_ST_WO_OPERATION_REL.ORGANIZATION_ID%type,
1092: WORKORDER_ID MSC_ST_WO_OPERATION_REL.WORKORDER_ID%type,
1093: WIP_ENTITY_ID MSC_ST_WO_OPERATION_REL.WIP_ENTITY_ID%type

Line 1090: TO_OP_DESC MSC_ST_WO_OPERATION_REL.TO_OP_DESC%type,

1086: FROM_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.FROM_OP_RES_SEQ_NUM%type,
1087: FROM_OP_DESC MSC_ST_WO_OPERATION_REL.FROM_OP_DESC%type,
1088: TO_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_SEQ_NUM%type,
1089: TO_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_RES_SEQ_NUM%type,
1090: TO_OP_DESC MSC_ST_WO_OPERATION_REL.TO_OP_DESC%type,
1091: ORGANIZATION_ID MSC_ST_WO_OPERATION_REL.ORGANIZATION_ID%type,
1092: WORKORDER_ID MSC_ST_WO_OPERATION_REL.WORKORDER_ID%type,
1093: WIP_ENTITY_ID MSC_ST_WO_OPERATION_REL.WIP_ENTITY_ID%type
1094: );

Line 1091: ORGANIZATION_ID MSC_ST_WO_OPERATION_REL.ORGANIZATION_ID%type,

1087: FROM_OP_DESC MSC_ST_WO_OPERATION_REL.FROM_OP_DESC%type,
1088: TO_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_SEQ_NUM%type,
1089: TO_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_RES_SEQ_NUM%type,
1090: TO_OP_DESC MSC_ST_WO_OPERATION_REL.TO_OP_DESC%type,
1091: ORGANIZATION_ID MSC_ST_WO_OPERATION_REL.ORGANIZATION_ID%type,
1092: WORKORDER_ID MSC_ST_WO_OPERATION_REL.WORKORDER_ID%type,
1093: WIP_ENTITY_ID MSC_ST_WO_OPERATION_REL.WIP_ENTITY_ID%type
1094: );
1095:

Line 1092: WORKORDER_ID MSC_ST_WO_OPERATION_REL.WORKORDER_ID%type,

1088: TO_OP_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_SEQ_NUM%type,
1089: TO_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_RES_SEQ_NUM%type,
1090: TO_OP_DESC MSC_ST_WO_OPERATION_REL.TO_OP_DESC%type,
1091: ORGANIZATION_ID MSC_ST_WO_OPERATION_REL.ORGANIZATION_ID%type,
1092: WORKORDER_ID MSC_ST_WO_OPERATION_REL.WORKORDER_ID%type,
1093: WIP_ENTITY_ID MSC_ST_WO_OPERATION_REL.WIP_ENTITY_ID%type
1094: );
1095:
1096: c_rec cursorRec;

Line 1093: WIP_ENTITY_ID MSC_ST_WO_OPERATION_REL.WIP_ENTITY_ID%type

1089: TO_OP_RES_SEQ_NUM MSC_ST_WO_OPERATION_REL.TO_OP_RES_SEQ_NUM%type,
1090: TO_OP_DESC MSC_ST_WO_OPERATION_REL.TO_OP_DESC%type,
1091: ORGANIZATION_ID MSC_ST_WO_OPERATION_REL.ORGANIZATION_ID%type,
1092: WORKORDER_ID MSC_ST_WO_OPERATION_REL.WORKORDER_ID%type,
1093: WIP_ENTITY_ID MSC_ST_WO_OPERATION_REL.WIP_ENTITY_ID%type
1094: );
1095:
1096: c_rec cursorRec;
1097: BEGIN

Line 1171: ||' FROM MSC_ST_WO_OPERATION_REL mswor,'

1167: ||':v_current_date, '
1168: ||':v_current_user, '
1169: ||':v_current_date, '
1170: ||':v_current_user '
1171: ||' FROM MSC_ST_WO_OPERATION_REL mswor,'
1172: || lv_supplies_tbl||' ms'
1173: ||' WHERE mswor.deleted_flag = '||MSC_UTIL.SYS_NO
1174: ||' AND mswor.SR_INSTANCE_ID= '
1175: ||MSC_CL_COLLECTION.v_instance_id

Line 1237: ||' FROM MSC_ST_WO_OPERATION_REL mswor,'

1233: ||'mswor.TO_OP_DESC, '
1234: ||'mswor.ORGANIZATION_ID, '
1235: ||'mswor.WORKORDER_ID, '
1236: ||'mswor.WIP_ENTITY_ID '
1237: ||' FROM MSC_ST_WO_OPERATION_REL mswor,'
1238: || lv_supplies_tbl||' ms'
1239: ||' WHERE mswor.deleted_flag = '||MSC_UTIL.SYS_NO
1240: ||' AND mswor.SR_INSTANCE_ID= '
1241: ||MSC_CL_COLLECTION.v_instance_id