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.WSM_JOBCOPIES_PVT dependencies on STANDARD

Line 119: standard_operation_id,

115:
116: l_stmt_num := 30;
117:
118: SELECT operation_sequence_id,
119: standard_operation_id,
120: department_id,
121: quantity_in_queue,
122: quantity_running,
123: quantity_waiting_to_move,

Line 315: BOS.standard_operation_id,

311: null network_start_end,
312: null RECO_PATH_SEQ_NUM,
313: BOS.operation_sequence_id,
314: BOS.routing_sequence_id,
315: BOS.standard_operation_id,
316: BSO.operation_code Standard_operation_code,
317: BOS.department_id,
318: BD.department_code,
319: BD.scrap_account,

Line 316: BSO.operation_code Standard_operation_code,

312: null RECO_PATH_SEQ_NUM,
313: BOS.operation_sequence_id,
314: BOS.routing_sequence_id,
315: BOS.standard_operation_id,
316: BSO.operation_code Standard_operation_code,
317: BOS.department_id,
318: BD.department_code,
319: BD.scrap_account,
320: BD.est_absorption_account,

Line 383: BOM_STANDARD_OPERATIONS BSO,

379: BOS.attribute15,
380: BOS.original_system_reference,
381: BOS.lowest_acceptable_yield --mes
382: FROM BOM_OPERATION_SEQUENCES BOS,
383: BOM_STANDARD_OPERATIONS BSO,
384: BOM_DEPARTMENTS BD
385: WHERE BOS.routing_sequence_id = p_common_rtg_seq_id
386: AND p_rtg_rev_date between BOS.effectivity_date and nvl(BOS.disable_date, p_rtg_rev_date+1)
387: AND BOS.standard_operation_id = BSO.standard_operation_id (+)

Line 387: AND BOS.standard_operation_id = BSO.standard_operation_id (+)

383: BOM_STANDARD_OPERATIONS BSO,
384: BOM_DEPARTMENTS BD
385: WHERE BOS.routing_sequence_id = p_common_rtg_seq_id
386: AND p_rtg_rev_date between BOS.effectivity_date and nvl(BOS.disable_date, p_rtg_rev_date+1)
387: AND BOS.standard_operation_id = BSO.standard_operation_id (+)
388: AND BOS.department_id = BD.department_id;
389:
390: CURSOR c_job_nw is
391: SELECT

Line 1155: v_job_ops(l_counter).STANDARD_OPERATION_ID := l_job_op.STANDARD_OPERATION_ID;

1151: v_job_ops(l_counter).NETWORK_START_END := l_job_op.NETWORK_START_END;
1152: v_job_ops(l_counter).OPERATION_SEQUENCE_ID := l_job_op.OPERATION_SEQUENCE_ID;
1153: v_job_ops(l_counter).ROUTING_SEQUENCE_ID := l_job_op.ROUTING_SEQUENCE_ID;
1154: v_job_ops(l_counter).ORGANIZATION_ID := p_org_id;
1155: v_job_ops(l_counter).STANDARD_OPERATION_ID := l_job_op.STANDARD_OPERATION_ID;
1156: v_job_ops(l_counter).STANDARD_OPERATION_CODE := l_job_op.STANDARD_OPERATION_CODE;
1157: v_job_ops(l_counter).DEPARTMENT_ID := l_job_op.DEPARTMENT_ID;
1158: v_job_ops(l_counter).DEPARTMENT_CODE := l_job_op.DEPARTMENT_CODE;
1159: v_job_ops(l_counter).SCRAP_ACCOUNT := l_job_op.SCRAP_ACCOUNT;

Line 1156: v_job_ops(l_counter).STANDARD_OPERATION_CODE := l_job_op.STANDARD_OPERATION_CODE;

1152: v_job_ops(l_counter).OPERATION_SEQUENCE_ID := l_job_op.OPERATION_SEQUENCE_ID;
1153: v_job_ops(l_counter).ROUTING_SEQUENCE_ID := l_job_op.ROUTING_SEQUENCE_ID;
1154: v_job_ops(l_counter).ORGANIZATION_ID := p_org_id;
1155: v_job_ops(l_counter).STANDARD_OPERATION_ID := l_job_op.STANDARD_OPERATION_ID;
1156: v_job_ops(l_counter).STANDARD_OPERATION_CODE := l_job_op.STANDARD_OPERATION_CODE;
1157: v_job_ops(l_counter).DEPARTMENT_ID := l_job_op.DEPARTMENT_ID;
1158: v_job_ops(l_counter).DEPARTMENT_CODE := l_job_op.DEPARTMENT_CODE;
1159: v_job_ops(l_counter).SCRAP_ACCOUNT := l_job_op.SCRAP_ACCOUNT;
1160: v_job_ops(l_counter).EST_ABSORPTION_ACCOUNT := l_job_op.EST_ABSORPTION_ACCOUNT;

Line 1656: STANDARD_RATE_FLAG,

1652: PHANTOM_FLAG,
1653: PHANTOM_OP_SEQ_NUM,
1654: PHANTOM_ITEM_ID,
1655: ACTIVITY_ID,
1656: STANDARD_RATE_FLAG,
1657: ASSIGNED_UNITS,
1658: -- ST : Detailed Scheduling
1659: MAX_ASSIGNED_UNITS,
1660: FIRM_TYPE,

Line 1718: bor.STANDARD_RATE_FLAG,

1714: NULL, --PHANTOM_FLAG
1715: NULL, --PHANTOM_OP_SEQ_NUM
1716: NULL, --PHANTOM_ITEM_ID
1717: bor.ACTIVITY_ID,
1718: bor.STANDARD_RATE_FLAG,
1719: bor.ASSIGNED_UNITS,
1720: -- ST : Detailed Scheduling
1721: bor.ASSIGNED_UNITS,
1722: 0, -- None - NOT FIRMED

Line 1813: STANDARD_RATE_FLAG,

1809: RECO_COMPLETION_DATE,
1810: RESOURCE_ID,
1811: RESOURCE_CODE,
1812: ACTIVITY_ID,
1813: STANDARD_RATE_FLAG,
1814: ASSIGNED_UNITS,
1815: -- ST : Detailed Scheduling
1816: MAX_ASSIGNED_UNITS,
1817: FIRM_TYPE,

Line 1873: bsor.STANDARD_RATE_FLAG,

1869: NULL, --RECO_COMPLETION_DATE
1870: bsor.RESOURCE_ID,
1871: br.RESOURCE_CODE,
1872: bsor.ACTIVITY_ID,
1873: bsor.STANDARD_RATE_FLAG,
1874: bsor.ASSIGNED_UNITS,
1875: bsor.ASSIGNED_UNITS,
1876: 0, -- None - NOT FIRMED
1877: bsor.USAGE_RATE_OR_AMOUNT,

Line 3305: BOR.standard_rate_flag,

3301: BOS.department_id,
3302: -(WCRO.OPERATION_SEQ_NUM) phantom_op_seq_num,
3303: WCRO.component_ITEM_ID phantom_item_id,
3304: BOR.activity_id,
3305: BOR.standard_rate_flag,
3306: BOR.assigned_units,
3307: decode(BOR.basis_type,
3308: wip_constants.PER_LOT,
3309: BOR.usage_rate_or_amount,

Line 3426: STANDARD_RATE_FLAG,

3422: PHANTOM_FLAG,
3423: PHANTOM_OP_SEQ_NUM,
3424: PHANTOM_ITEM_ID,
3425: ACTIVITY_ID,
3426: STANDARD_RATE_FLAG,
3427: ASSIGNED_UNITS,
3428: -- ST : Detailed Scheduling
3429: MAX_ASSIGNED_UNITS,
3430: FIRM_TYPE,

Line 3489: cur_resc.standard_rate_flag,

3485: 1,
3486: cur_resc.phantom_op_seq_num,
3487: cur_resc.phantom_item_id,
3488: cur_resc.activity_id,
3489: cur_resc.standard_rate_flag,
3490: cur_resc.assigned_units,
3491: -- ST : Detailed Scheduling
3492: cur_resc.assigned_units,
3493: 0, -- Not firmed

Line 4047: STANDARD_OPERATION_ID,

4043: RECO_COMPLETION_DATE,
4044: OPERATION_SEQUENCE_ID,
4045: ROUTING_SEQUENCE_ID,
4046: ORGANIZATION_ID,
4047: STANDARD_OPERATION_ID,
4048: STANDARD_OPERATION_CODE,
4049: DEPARTMENT_ID,
4050: DEPARTMENT_CODE,
4051: SCRAP_ACCOUNT,

Line 4048: STANDARD_OPERATION_CODE,

4044: OPERATION_SEQUENCE_ID,
4045: ROUTING_SEQUENCE_ID,
4046: ORGANIZATION_ID,
4047: STANDARD_OPERATION_ID,
4048: STANDARD_OPERATION_CODE,
4049: DEPARTMENT_ID,
4050: DEPARTMENT_CODE,
4051: SCRAP_ACCOUNT,
4052: EST_ABSORPTION_ACCOUNT,

Line 4126: STANDARD_OPERATION_ID,

4122: NULL, --RECO_COMPLETION_DATE,
4123: OPERATION_SEQUENCE_ID,
4124: ROUTING_SEQUENCE_ID,
4125: ORGANIZATION_ID,
4126: STANDARD_OPERATION_ID,
4127: STANDARD_OPERATION_CODE,
4128: DEPARTMENT_ID,
4129: DEPARTMENT_CODE,
4130: SCRAP_ACCOUNT,

Line 4127: STANDARD_OPERATION_CODE,

4123: OPERATION_SEQUENCE_ID,
4124: ROUTING_SEQUENCE_ID,
4125: ORGANIZATION_ID,
4126: STANDARD_OPERATION_ID,
4127: STANDARD_OPERATION_CODE,
4128: DEPARTMENT_ID,
4129: DEPARTMENT_CODE,
4130: SCRAP_ACCOUNT,
4131: EST_ABSORPTION_ACCOUNT,

Line 4238: STANDARD_RATE_FLAG,

4234: RECO_COMPLETION_DATE,
4235: RESOURCE_ID,
4236: RESOURCE_CODE,
4237: ACTIVITY_ID,
4238: STANDARD_RATE_FLAG,
4239: ASSIGNED_UNITS,
4240: -- ST : Detailed Scheduling
4241: MAX_ASSIGNED_UNITS,
4242: firm_type,

Line 4304: STANDARD_RATE_FLAG,

4300: NULL, --RECO_COMPLETION_DATE,
4301: RESOURCE_ID,
4302: RESOURCE_CODE,
4303: ACTIVITY_ID,
4304: STANDARD_RATE_FLAG,
4305: ASSIGNED_UNITS,
4306: -- ST : Detailed Scheduling
4307: MAX_ASSIGNED_UNITS,
4308: decode(firm_type

Line 5284: STANDARD_OPERATION_ID,

5280: PROGRAM_APPLICATION_ID,
5281: PROGRAM_ID,
5282: PROGRAM_UPDATE_DATE,
5283: OPERATION_SEQUENCE_ID,
5284: STANDARD_OPERATION_ID,
5285: DEPARTMENT_ID,
5286: DESCRIPTION,
5287: SCHEDULED_QUANTITY,
5288: QUANTITY_IN_QUEUE,

Line 5338: WCO.STANDARD_OPERATION_ID,

5334: WCO.PROGRAM_APPLICATION_ID,
5335: WCO.PROGRAM_ID,
5336: WCO.PROGRAM_UPDATE_DATE,
5337: WCO.OPERATION_SEQUENCE_ID,
5338: WCO.STANDARD_OPERATION_ID,
5339: WCO.DEPARTMENT_ID,
5340: WCO.OPERATION_DESCRIPTION,
5341: -- Bug 5603843. Modified inside nvl clause from 0 to wdj.start_quantity
5342: ROUND(nvl(WCO.RECO_SCHEDULED_QUANTITY, wdj.start_quantity), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

Line 5558: STANDARD_RATE_FLAG, APPLIED_RESOURCE_UNITS, APPLIED_RESOURCE_VALUE,

5554: group_sequence_number,
5555: parent_resource_seq,
5556: /* ST : Detailed Scheduling */
5557: AUTOCHARGE_TYPE,
5558: STANDARD_RATE_FLAG, APPLIED_RESOURCE_UNITS, APPLIED_RESOURCE_VALUE,
5559: START_DATE, COMPLETION_DATE,
5560: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
5561: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5,
5562: ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,

Line 5600: , WCOR.STANDARD_RATE_FLAG

5596: , WCOR.group_sequence_id
5597: , WCOR.group_sequence_num
5598: , WCOR.parent_resource_seq_num
5599: , WCOR.AUTOCHARGE_TYPE
5600: , WCOR.STANDARD_RATE_FLAG
5601: , 0
5602: , 0
5603: , decode(recommended, 'Y', nvl(RECO_START_DATE, SYSDATE), SYSDATE)
5604: , decode(recommended, 'Y', nvl(RECO_COMPLETION_DATE, SYSDATE), SYSDATE)

Line 5654: standard_rate_flag,

5650: scheduled_flag,
5651: assigned_units,
5652: maximum_assigned_units, /* ST : Detailed Scheduling */
5653: autocharge_type,
5654: standard_rate_flag,
5655: applied_resource_units,
5656: applied_resource_value,
5657: attribute_category,
5658: attribute1,

Line 5698: WCOR.standard_rate_flag,

5694: WCOR.schedule_flag,
5695: WCOR.assigned_units,
5696: WCOR.max_assigned_units,
5697: WCOR.autocharge_type,
5698: WCOR.standard_rate_flag,
5699: 0, --WCOR.applied_resource_units,--move enh?
5700: 0, -- WCOR.applied_resource_value, --move enh?
5701: WCOR.attribute_category,
5702: WCOR.attribute1,