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.WIP_MOVPROC_PRIV dependencies on WIP_DISCRETE_JOBS

Line 2244: wip_discrete_jobs wdj

2240: wmti.primary_item_id item_id,
2241: NVL(wdj.serialization_start_op, 0) sn_start_op,
2242: wmti.transaction_date txn_date
2243: FROM wip_move_txn_interface wmti,
2244: wip_discrete_jobs wdj
2245: WHERE wmti.wip_entity_id = wdj.wip_entity_id
2246: AND wmti.group_id = p_group_id
2247: AND TRUNC(wmti.transaction_date) = TRUNC(p_txn_date)
2248: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 3088: wip_discrete_jobs wdj

3084: wmti.batch_id,
3085: wmti.employee_id,
3086: wmti.completed_instructions
3087: FROM wip_move_txn_interface wmti,
3088: wip_discrete_jobs wdj
3089: WHERE wmti.group_id = p_gib.group_id
3090: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
3091: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
3092: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 3535: wip_discrete_jobs wdj,

3531: FROM bom_departments bd,
3532: bom_resources br,
3533: cst_activities ca,
3534: wip_operation_resources wor,
3535: wip_discrete_jobs wdj,
3536: wip_operations wop,
3537: wip_move_txn_interface wmti
3538: WHERE wmti.group_id = p_gib.group_id
3539: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 3988: wip_discrete_jobs wdj,

3984: FROM bom_departments bd,
3985: bom_resources br,
3986: cst_activities ca,
3987: wip_operation_resources wor,
3988: wip_discrete_jobs wdj,
3989: wip_operations wop,
3990: wip_move_txn_interface wmti
3991: WHERE wmti.group_id = p_gib.group_id
3992: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 4825: wip_discrete_jobs wdj,

4821: MAX(wdj.task_id)
4822: FROM bom_departments bd,
4823: wip_operations wop,
4824: wip_operation_resources wor,
4825: wip_discrete_jobs wdj,
4826: wip_move_txn_interface wmti,
4827: wip_requirement_operations WRO
4828: WHERE wmti.group_id = p_gib.group_id
4829: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 5284: wip_discrete_jobs wdj,

5280: MAX(wdj.task_id)
5281: FROM bom_departments bd,
5282: wip_operations wop,
5283: wip_operation_resources wor,
5284: wip_discrete_jobs wdj,
5285: wip_move_txn_interface wmti
5286: WHERE wmti.group_id = p_gib.group_id
5287: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
5288: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 5840: wip_discrete_jobs wdj

5836: wmti.overcompletion_primary_qty oc_qty
5837: FROM wip_move_txn_interface wmti,
5838: wip_operations wo,
5839: wip_operation_resources wor,
5840: wip_discrete_jobs wdj
5841: WHERE wmti.group_id = p_group_id
5842: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
5843: AND wmti.process_status = WIP_CONSTANTS.RUNNING
5844: AND wmti.overcompletion_transaction_qty IS NOT NULL

Line 6070: wip_discrete_jobs wdj,

6066: bom_calendar_dates bcd3,
6067: fnd_user fu,
6068: bom_departments bd,
6069: hr_organization_information hoi,
6070: wip_discrete_jobs wdj,
6071: wip_operations wo1,
6072: wip_operations wo2,
6073: wip_parameters wp /*ER 4276433*/
6074: WHERE wmti.group_id = p_gib.group_id

Line 6494: wip_discrete_jobs wdj,

6490: bom_calendar_dates bcd3,
6491: fnd_user fu,
6492: bom_departments bd,
6493: hr_organization_information hoi,
6494: wip_discrete_jobs wdj,
6495: wip_operations wo1,
6496: wip_operations wo2,
6497: wip_parameters wp /*ER 4276433*/
6498: WHERE wmti.group_id = p_gib.group_id

Line 7868: * This procedure is used to update scrap quantity in WIP_DISCRETE_JOBS for

7864: END update_wo_and_snapshot;
7865:
7866: /*****************************************************************************
7867: * This procedure is equivalent to witpsst_scrap_txns in wiltps5.ppc
7868: * This procedure is used to update scrap quantity in WIP_DISCRETE_JOBS for
7869: * discrete and OSFM jobs, and WIP_REPETITIVE_SCHEDULES for repetitive
7870: * schedules.
7871: * This procedure also insert into MTL_MATERIAL_TRANSACTIONS_TEMP for costing
7872: * purpose IF the user provide scrap account.

Line 8050: UPDATE wip_discrete_jobs wdj

8046:
8047:
8048: /** 3050846 **/
8049:
8050: UPDATE wip_discrete_jobs wdj
8051: SET (quantity_scrapped,
8052: last_updated_by,
8053: last_update_date,
8054: last_update_login,

Line 8073: FROM wip_discrete_jobs wdj1, wip_move_txn_interface wmti

8069: DECODE(p_gib.application_id,-1,NULL,p_gib.application_id),
8070: DECODE(p_gib.program_id,-1,NULL,p_gib.program_id),
8071: DECODE(p_gib.request_id,
8072: -1,NULL,SYSDATE)-- program_update_date
8073: FROM wip_discrete_jobs wdj1, wip_move_txn_interface wmti
8074: WHERE wdj1.rowid = wdj.rowid
8075: AND wmti.group_id = p_gib.group_id
8076: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
8077: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 8088: FROM wip_discrete_jobs wdj2,

8084: OR wmti.to_intraoperation_step_type = WIP_CONSTANTS.SCRAP)
8085: )
8086: WHERE wdj.rowid IN
8087: (SELECT wdj2.rowid
8088: FROM wip_discrete_jobs wdj2,
8089: wip_move_txn_interface wmti
8090: WHERE wmti.group_id = p_gib.group_id
8091: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
8092: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 8108: UPDATE wip_discrete_jobs wdj

8104: from Scrap will re-release a completed job. We will also update the
8105: date_completed IF necessary. See wiltct.ppc for a similar change.
8106: rkaiser, 7/15/98 */
8107:
8108: UPDATE wip_discrete_jobs wdj
8109: SET (status_type,
8110: date_completed
8111: ) =
8112: (SELECT WIP_CONSTANTS.COMP_CHRG, -- status_type

Line 8117: FROM wip_discrete_jobs wdj2,

8113: SYSDATE -- date_completed
8114: FROM DUAL)
8115: WHERE wdj.rowid IN
8116: (SELECT wdj2.rowid
8117: FROM wip_discrete_jobs wdj2,
8118: wip_move_txn_interface wmti
8119: WHERE wmti.group_id = p_gib.group_id
8120: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
8121: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 8140: UPDATE wip_discrete_jobs wdj

8136: from wip_operations
8137: where wip_entity_id = wdj2.wip_entity_id
8138: and organization_id = wdj2.organization_id) = 0);
8139:
8140: UPDATE wip_discrete_jobs wdj
8141: SET status_type = WIP_CONSTANTS.RELEASED,
8142: /*bug 3933240 -> nullify date_completed while changing the status of job to
8143: released */
8144: date_completed = null

Line 8147: FROM wip_discrete_jobs wdj2,

8143: released */
8144: date_completed = null
8145: WHERE wdj.rowid IN
8146: (SELECT wdj2.rowid
8147: FROM wip_discrete_jobs wdj2,
8148: wip_move_txn_interface wmti
8149: WHERE wmti.group_id = p_gib.group_id
8150: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
8151: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 8166: fnd_message.set_token('ENTITY2', 'WIP_DISCRETE_JOBS');

8162: -- IF debug message level = 2, write statement below to log file
8163: IF (l_logLevel <= wip_constants.full_logging) THEN
8164: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
8165: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
8166: fnd_message.set_token('ENTITY2', 'WIP_DISCRETE_JOBS');
8167: l_msg := fnd_message.get;
8168: wip_logger.log(p_msg => l_msg,
8169: x_returnStatus => l_returnStatus);
8170: END IF;

Line 8348: wip_discrete_jobs wdj

8344: wmti.qa_collection_id, /*Added for Bug 7136450 (FP of 7126588 )*/
8345: WIP_CONSTANTS.ASSY_BATCH_SEQ -- transaction_batch_seq
8346: FROM wip_move_txn_interface wmti,
8347: mtl_system_items msi,
8348: wip_discrete_jobs wdj
8349: WHERE wmti.group_id = p_gib.group_id
8350: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
8351: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
8352: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 8885: wip_discrete_jobs wdj

8881: FROM wip_move_txn_interface wmti,
8882: mtl_item_locations mil,
8883: wip_operations wop,
8884: mtl_system_items msi,
8885: wip_discrete_jobs wdj
8886: WHERE wmti.group_id = p_gib.group_id
8887: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
8888: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
8889: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 9135: wip_discrete_jobs wdj

9131: 1, -- Bug 13734082 ,FP Bug for Populating orignation type as 'Production'
9132: mti.transaction_date
9133: FROM mtl_transactions_interface mti,
9134: mtl_system_items msi,
9135: wip_discrete_jobs wdj
9136: WHERE mti.organization_id = msi.organization_id
9137: AND mti.inventory_item_id = msi.inventory_item_id
9138: AND mti.transaction_header_id = p_gib.assy_header_id
9139: AND mti.transaction_action_id = l_txn_action_id

Line 9788: -- Update scrap quantity in WIP_DISCRETE_JOBS and insert into MMTT IF

9784: raise fnd_api.g_exc_unexpected_error;
9785: END IF; -- check return status
9786: END IF;
9787:
9788: -- Update scrap quantity in WIP_DISCRETE_JOBS and insert into MMTT IF
9789: -- scrap account provided
9790: scrap_txns(p_gib => p_gib,
9791: x_returnStatus => x_returnStatus);
9792:

Line 10103: from wip_discrete_jobs

10099: FOR l_jobs IN c_jobs LOOP
10100: wip_logger.log('Looking at job id: ' || l_jobs.wip_entity_id || ' txn id: ' || l_jobs.txn_id || ' txn_type: ' || l_jobs.txn_type, l_returnStatus);
10101: begin
10102: select wip_entity_id into l_wip_entity_id
10103: from wip_discrete_jobs
10104: where wip_entity_id = l_jobs.wip_entity_id
10105: for update nowait;
10106: wip_logger.log('no lock existed for this job', l_returnStatus);
10107: exception