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 1156: v_job_ops(l_counter).STANDARD_OPERATION_ID := l_job_op.STANDARD_OPERATION_ID;

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

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

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

Line 1600: STANDARD_OPERATION_ID,

1596: NETWORK_START_END,
1597: OPERATION_SEQUENCE_ID,
1598: ROUTING_SEQUENCE_ID,
1599: ORGANIZATION_ID,
1600: STANDARD_OPERATION_ID,
1601: STANDARD_OPERATION_CODE,
1602: DEPARTMENT_ID,
1603: DEPARTMENT_CODE,
1604: SCRAP_ACCOUNT,

Line 1601: STANDARD_OPERATION_CODE,

1597: OPERATION_SEQUENCE_ID,
1598: ROUTING_SEQUENCE_ID,
1599: ORGANIZATION_ID,
1600: STANDARD_OPERATION_ID,
1601: STANDARD_OPERATION_CODE,
1602: DEPARTMENT_ID,
1603: DEPARTMENT_CODE,
1604: SCRAP_ACCOUNT,
1605: EST_ABSORPTION_ACCOUNT,

Line 1680: v_job_ops(l_index).STANDARD_OPERATION_ID,

1676: v_job_ops(l_index).NETWORK_START_END,
1677: v_job_ops(l_index).OPERATION_SEQUENCE_ID,
1678: v_job_ops(l_index).ROUTING_SEQUENCE_ID,
1679: v_job_ops(l_index).ORGANIZATION_ID,
1680: v_job_ops(l_index).STANDARD_OPERATION_ID,
1681: v_job_ops(l_index).STANDARD_OPERATION_CODE,
1682: v_job_ops(l_index).DEPARTMENT_ID,
1683: v_job_ops(l_index).DEPARTMENT_CODE,
1684: v_job_ops(l_index).SCRAP_ACCOUNT,

Line 1681: v_job_ops(l_index).STANDARD_OPERATION_CODE,

1677: v_job_ops(l_index).OPERATION_SEQUENCE_ID,
1678: v_job_ops(l_index).ROUTING_SEQUENCE_ID,
1679: v_job_ops(l_index).ORGANIZATION_ID,
1680: v_job_ops(l_index).STANDARD_OPERATION_ID,
1681: v_job_ops(l_index).STANDARD_OPERATION_CODE,
1682: v_job_ops(l_index).DEPARTMENT_ID,
1683: v_job_ops(l_index).DEPARTMENT_CODE,
1684: v_job_ops(l_index).SCRAP_ACCOUNT,
1685: v_job_ops(l_index).EST_ABSORPTION_ACCOUNT,

Line 1886: STANDARD_RATE_FLAG,

1882: PHANTOM_FLAG,
1883: PHANTOM_OP_SEQ_NUM,
1884: PHANTOM_ITEM_ID,
1885: ACTIVITY_ID,
1886: STANDARD_RATE_FLAG,
1887: ASSIGNED_UNITS,
1888: -- ST : Detailed Scheduling
1889: MAX_ASSIGNED_UNITS,
1890: FIRM_TYPE,

Line 1948: bor.STANDARD_RATE_FLAG,

1944: NULL, --PHANTOM_FLAG
1945: NULL, --PHANTOM_OP_SEQ_NUM
1946: NULL, --PHANTOM_ITEM_ID
1947: bor.ACTIVITY_ID,
1948: bor.STANDARD_RATE_FLAG,
1949: bor.ASSIGNED_UNITS,
1950: -- ST : Detailed Scheduling
1951: bor.ASSIGNED_UNITS,
1952: 0, -- None - NOT FIRMED

Line 2043: STANDARD_RATE_FLAG,

2039: RECO_COMPLETION_DATE,
2040: RESOURCE_ID,
2041: RESOURCE_CODE,
2042: ACTIVITY_ID,
2043: STANDARD_RATE_FLAG,
2044: ASSIGNED_UNITS,
2045: -- ST : Detailed Scheduling
2046: MAX_ASSIGNED_UNITS,
2047: FIRM_TYPE,

Line 2103: bsor.STANDARD_RATE_FLAG,

2099: NULL, --RECO_COMPLETION_DATE
2100: bsor.RESOURCE_ID,
2101: br.RESOURCE_CODE,
2102: bsor.ACTIVITY_ID,
2103: bsor.STANDARD_RATE_FLAG,
2104: bsor.ASSIGNED_UNITS,
2105: bsor.ASSIGNED_UNITS,
2106: 0, -- None - NOT FIRMED
2107: bsor.USAGE_RATE_OR_AMOUNT,

Line 3536: BOR.standard_rate_flag,

3532: BOS.department_id,
3533: -(WCRO.OPERATION_SEQ_NUM) phantom_op_seq_num,
3534: WCRO.component_ITEM_ID phantom_item_id,
3535: BOR.activity_id,
3536: BOR.standard_rate_flag,
3537: BOR.assigned_units,
3538: decode(BOR.basis_type,
3539: wip_constants.PER_LOT,
3540: BOR.usage_rate_or_amount,

Line 3657: STANDARD_RATE_FLAG,

3653: PHANTOM_FLAG,
3654: PHANTOM_OP_SEQ_NUM,
3655: PHANTOM_ITEM_ID,
3656: ACTIVITY_ID,
3657: STANDARD_RATE_FLAG,
3658: ASSIGNED_UNITS,
3659: -- ST : Detailed Scheduling
3660: MAX_ASSIGNED_UNITS,
3661: FIRM_TYPE,

Line 3720: cur_resc.standard_rate_flag,

3716: 1,
3717: cur_resc.phantom_op_seq_num,
3718: cur_resc.phantom_item_id,
3719: cur_resc.activity_id,
3720: cur_resc.standard_rate_flag,
3721: cur_resc.assigned_units,
3722: -- ST : Detailed Scheduling
3723: cur_resc.assigned_units,
3724: 0, -- Not firmed

Line 4278: STANDARD_OPERATION_ID,

4274: RECO_COMPLETION_DATE,
4275: OPERATION_SEQUENCE_ID,
4276: ROUTING_SEQUENCE_ID,
4277: ORGANIZATION_ID,
4278: STANDARD_OPERATION_ID,
4279: STANDARD_OPERATION_CODE,
4280: DEPARTMENT_ID,
4281: DEPARTMENT_CODE,
4282: SCRAP_ACCOUNT,

Line 4279: STANDARD_OPERATION_CODE,

4275: OPERATION_SEQUENCE_ID,
4276: ROUTING_SEQUENCE_ID,
4277: ORGANIZATION_ID,
4278: STANDARD_OPERATION_ID,
4279: STANDARD_OPERATION_CODE,
4280: DEPARTMENT_ID,
4281: DEPARTMENT_CODE,
4282: SCRAP_ACCOUNT,
4283: EST_ABSORPTION_ACCOUNT,

Line 4357: STANDARD_OPERATION_ID,

4353: NULL, --RECO_COMPLETION_DATE,
4354: OPERATION_SEQUENCE_ID,
4355: ROUTING_SEQUENCE_ID,
4356: ORGANIZATION_ID,
4357: STANDARD_OPERATION_ID,
4358: STANDARD_OPERATION_CODE,
4359: DEPARTMENT_ID,
4360: DEPARTMENT_CODE,
4361: SCRAP_ACCOUNT,

Line 4358: STANDARD_OPERATION_CODE,

4354: OPERATION_SEQUENCE_ID,
4355: ROUTING_SEQUENCE_ID,
4356: ORGANIZATION_ID,
4357: STANDARD_OPERATION_ID,
4358: STANDARD_OPERATION_CODE,
4359: DEPARTMENT_ID,
4360: DEPARTMENT_CODE,
4361: SCRAP_ACCOUNT,
4362: EST_ABSORPTION_ACCOUNT,

Line 4469: STANDARD_RATE_FLAG,

4465: RECO_COMPLETION_DATE,
4466: RESOURCE_ID,
4467: RESOURCE_CODE,
4468: ACTIVITY_ID,
4469: STANDARD_RATE_FLAG,
4470: ASSIGNED_UNITS,
4471: -- ST : Detailed Scheduling
4472: MAX_ASSIGNED_UNITS,
4473: firm_type,

Line 4535: STANDARD_RATE_FLAG,

4531: NULL, --RECO_COMPLETION_DATE,
4532: RESOURCE_ID,
4533: RESOURCE_CODE,
4534: ACTIVITY_ID,
4535: STANDARD_RATE_FLAG,
4536: ASSIGNED_UNITS,
4537: -- ST : Detailed Scheduling
4538: MAX_ASSIGNED_UNITS,
4539: decode(firm_type

Line 5515: STANDARD_OPERATION_ID,

5511: PROGRAM_APPLICATION_ID,
5512: PROGRAM_ID,
5513: PROGRAM_UPDATE_DATE,
5514: OPERATION_SEQUENCE_ID,
5515: STANDARD_OPERATION_ID,
5516: DEPARTMENT_ID,
5517: DESCRIPTION,
5518: SCHEDULED_QUANTITY,
5519: QUANTITY_IN_QUEUE,

Line 5569: WCO.STANDARD_OPERATION_ID,

5565: WCO.PROGRAM_APPLICATION_ID,
5566: WCO.PROGRAM_ID,
5567: WCO.PROGRAM_UPDATE_DATE,
5568: WCO.OPERATION_SEQUENCE_ID,
5569: WCO.STANDARD_OPERATION_ID,
5570: WCO.DEPARTMENT_ID,
5571: WCO.OPERATION_DESCRIPTION,
5572: -- Bug 5603843. Modified inside nvl clause from 0 to wdj.start_quantity
5573: ROUND(nvl(WCO.RECO_SCHEDULED_QUANTITY, wdj.start_quantity), WIP_CONSTANTS.MAX_DISPLAYED_PRECISION),

Line 5789: STANDARD_RATE_FLAG, APPLIED_RESOURCE_UNITS, APPLIED_RESOURCE_VALUE,

5785: group_sequence_number,
5786: parent_resource_seq,
5787: /* ST : Detailed Scheduling */
5788: AUTOCHARGE_TYPE,
5789: STANDARD_RATE_FLAG, APPLIED_RESOURCE_UNITS, APPLIED_RESOURCE_VALUE,
5790: START_DATE, COMPLETION_DATE,
5791: ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2,
5792: ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5,
5793: ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,

Line 5831: , WCOR.STANDARD_RATE_FLAG

5827: , WCOR.group_sequence_id
5828: , WCOR.group_sequence_num
5829: , WCOR.parent_resource_seq_num
5830: , WCOR.AUTOCHARGE_TYPE
5831: , WCOR.STANDARD_RATE_FLAG
5832: , 0
5833: , 0
5834: , decode(recommended, 'Y', nvl(RECO_START_DATE, SYSDATE), SYSDATE)
5835: , decode(recommended, 'Y', nvl(RECO_COMPLETION_DATE, SYSDATE), SYSDATE)

Line 5885: standard_rate_flag,

5881: scheduled_flag,
5882: assigned_units,
5883: maximum_assigned_units, /* ST : Detailed Scheduling */
5884: autocharge_type,
5885: standard_rate_flag,
5886: applied_resource_units,
5887: applied_resource_value,
5888: attribute_category,
5889: attribute1,

Line 5929: WCOR.standard_rate_flag,

5925: WCOR.schedule_flag,
5926: WCOR.assigned_units,
5927: WCOR.max_assigned_units,
5928: WCOR.autocharge_type,
5929: WCOR.standard_rate_flag,
5930: 0, --WCOR.applied_resource_units,--move enh?
5931: 0, -- WCOR.applied_resource_value, --move enh?
5932: WCOR.attribute_category,
5933: WCOR.attribute1,