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 2123: wip_discrete_jobs wdj

2119: wmti.primary_item_id item_id,
2120: NVL(wdj.serialization_start_op, 0) sn_start_op,
2121: wmti.transaction_date txn_date
2122: FROM wip_move_txn_interface wmti,
2123: wip_discrete_jobs wdj
2124: WHERE wmti.wip_entity_id = wdj.wip_entity_id
2125: AND wmti.group_id = p_group_id
2126: AND TRUNC(wmti.transaction_date) = TRUNC(p_txn_date)
2127: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 2959: wip_discrete_jobs wdj

2955: wmti.batch_id,
2956: wmti.employee_id,
2957: wmti.completed_instructions
2958: FROM wip_move_txn_interface wmti,
2959: wip_discrete_jobs wdj
2960: WHERE wmti.group_id = p_gib.group_id
2961: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
2962: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
2963: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 3406: wip_discrete_jobs wdj,

3402: FROM bom_departments bd,
3403: bom_resources br,
3404: cst_activities ca,
3405: wip_operation_resources wor,
3406: wip_discrete_jobs wdj,
3407: wip_operations wop,
3408: wip_move_txn_interface wmti
3409: WHERE wmti.group_id = p_gib.group_id
3410: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 3859: wip_discrete_jobs wdj,

3855: FROM bom_departments bd,
3856: bom_resources br,
3857: cst_activities ca,
3858: wip_operation_resources wor,
3859: wip_discrete_jobs wdj,
3860: wip_operations wop,
3861: wip_move_txn_interface wmti
3862: WHERE wmti.group_id = p_gib.group_id
3863: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 4696: wip_discrete_jobs wdj,

4692: MAX(wdj.task_id)
4693: FROM bom_departments bd,
4694: wip_operations wop,
4695: wip_operation_resources wor,
4696: wip_discrete_jobs wdj,
4697: wip_move_txn_interface wmti,
4698: wip_requirement_operations WRO
4699: WHERE wmti.group_id = p_gib.group_id
4700: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 5155: wip_discrete_jobs wdj,

5151: MAX(wdj.task_id)
5152: FROM bom_departments bd,
5153: wip_operations wop,
5154: wip_operation_resources wor,
5155: wip_discrete_jobs wdj,
5156: wip_move_txn_interface wmti
5157: WHERE wmti.group_id = p_gib.group_id
5158: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
5159: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 5711: wip_discrete_jobs wdj

5707: wmti.overcompletion_primary_qty oc_qty
5708: FROM wip_move_txn_interface wmti,
5709: wip_operations wo,
5710: wip_operation_resources wor,
5711: wip_discrete_jobs wdj
5712: WHERE wmti.group_id = p_group_id
5713: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
5714: AND wmti.process_status = WIP_CONSTANTS.RUNNING
5715: AND wmti.overcompletion_transaction_qty IS NOT NULL

Line 5936: wip_discrete_jobs wdj,

5932: bom_calendar_dates bcd3,
5933: fnd_user fu,
5934: bom_departments bd,
5935: hr_organization_information hoi,
5936: wip_discrete_jobs wdj,
5937: wip_operations wo1,
5938: wip_operations wo2
5939: WHERE wmti.group_id = p_gib.group_id
5940: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 6346: wip_discrete_jobs wdj,

6342: bom_calendar_dates bcd3,
6343: fnd_user fu,
6344: bom_departments bd,
6345: hr_organization_information hoi,
6346: wip_discrete_jobs wdj,
6347: wip_operations wo1,
6348: wip_operations wo2
6349: WHERE wmti.group_id = p_gib.group_id
6350: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

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

7663: END update_wo_and_snapshot;
7664:
7665: /*****************************************************************************
7666: * This procedure is equivalent to witpsst_scrap_txns in wiltps5.ppc
7667: * This procedure is used to update scrap quantity in WIP_DISCRETE_JOBS for
7668: * discrete and OSFM jobs, and WIP_REPETITIVE_SCHEDULES for repetitive
7669: * schedules.
7670: * This procedure also insert into MTL_MATERIAL_TRANSACTIONS_TEMP for costing
7671: * purpose IF the user provide scrap account.

Line 7847: UPDATE wip_discrete_jobs wdj

7843:
7844:
7845: /** 3050846 **/
7846:
7847: UPDATE wip_discrete_jobs wdj
7848: SET (quantity_scrapped,
7849: last_updated_by,
7850: last_update_date,
7851: last_update_login,

Line 7870: FROM wip_discrete_jobs wdj1, wip_move_txn_interface wmti

7866: DECODE(p_gib.application_id,-1,NULL,p_gib.application_id),
7867: DECODE(p_gib.program_id,-1,NULL,p_gib.program_id),
7868: DECODE(p_gib.request_id,
7869: -1,NULL,SYSDATE)-- program_update_date
7870: FROM wip_discrete_jobs wdj1, wip_move_txn_interface wmti
7871: WHERE wdj1.rowid = wdj.rowid
7872: AND wmti.group_id = p_gib.group_id
7873: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
7874: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 7885: FROM wip_discrete_jobs wdj2,

7881: OR wmti.to_intraoperation_step_type = WIP_CONSTANTS.SCRAP)
7882: )
7883: WHERE wdj.rowid IN
7884: (SELECT wdj2.rowid
7885: FROM wip_discrete_jobs wdj2,
7886: wip_move_txn_interface wmti
7887: WHERE wmti.group_id = p_gib.group_id
7888: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
7889: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 7905: UPDATE wip_discrete_jobs wdj

7901: from Scrap will re-release a completed job. We will also update the
7902: date_completed IF necessary. See wiltct.ppc for a similar change.
7903: rkaiser, 7/15/98 */
7904:
7905: UPDATE wip_discrete_jobs wdj
7906: SET (status_type,
7907: date_completed
7908: ) =
7909: (SELECT WIP_CONSTANTS.COMP_CHRG, -- status_type

Line 7914: FROM wip_discrete_jobs wdj2,

7910: SYSDATE -- date_completed
7911: FROM DUAL)
7912: WHERE wdj.rowid IN
7913: (SELECT wdj2.rowid
7914: FROM wip_discrete_jobs wdj2,
7915: wip_move_txn_interface wmti
7916: WHERE wmti.group_id = p_gib.group_id
7917: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
7918: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 7929: UPDATE wip_discrete_jobs wdj

7925: OR wmti.to_intraoperation_step_type = WIP_CONSTANTS.SCRAP)
7926: AND (wdj2.start_quantity - wdj2.quantity_completed -
7927: wdj2.quantity_scrapped) <= 0);
7928:
7929: UPDATE wip_discrete_jobs wdj
7930: SET status_type = WIP_CONSTANTS.RELEASED,
7931: /*bug 3933240 -> nullify date_completed while changing the status of job to
7932: released */
7933: date_completed = null

Line 7936: FROM wip_discrete_jobs wdj2,

7932: released */
7933: date_completed = null
7934: WHERE wdj.rowid IN
7935: (SELECT wdj2.rowid
7936: FROM wip_discrete_jobs wdj2,
7937: wip_move_txn_interface wmti
7938: WHERE wmti.group_id = p_gib.group_id
7939: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
7940: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

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

7951: -- IF debug message level = 2, write statement below to log file
7952: IF (l_logLevel <= wip_constants.full_logging) THEN
7953: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7954: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7955: fnd_message.set_token('ENTITY2', 'WIP_DISCRETE_JOBS');
7956: l_msg := fnd_message.get;
7957: wip_logger.log(p_msg => l_msg,
7958: x_returnStatus => l_returnStatus);
7959: END IF;

Line 8137: wip_discrete_jobs wdj

8133: wmti.qa_collection_id, /*Added for Bug 7136450 (FP of 7126588 )*/
8134: WIP_CONSTANTS.ASSY_BATCH_SEQ -- transaction_batch_seq
8135: FROM wip_move_txn_interface wmti,
8136: mtl_system_items msi,
8137: wip_discrete_jobs wdj
8138: WHERE wmti.group_id = p_gib.group_id
8139: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
8140: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
8141: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 8636: wip_discrete_jobs wdj

8632: FROM wip_move_txn_interface wmti,
8633: mtl_item_locations mil,
8634: wip_operations wop,
8635: mtl_system_items msi,
8636: wip_discrete_jobs wdj
8637: WHERE wmti.group_id = p_gib.group_id
8638: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
8639: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
8640: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 8874: wip_discrete_jobs wdj

8870: WIP_CONSTANTS.DYN_RCV_SN,mtl_material_transactions_s.nextval,
8871: NULL)
8872: FROM mtl_transactions_interface mti,
8873: mtl_system_items msi,
8874: wip_discrete_jobs wdj
8875: WHERE mti.organization_id = msi.organization_id
8876: AND mti.inventory_item_id = msi.inventory_item_id
8877: AND mti.transaction_header_id = p_gib.assy_header_id
8878: AND mti.transaction_action_id = l_txn_action_id

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

9511: raise fnd_api.g_exc_unexpected_error;
9512: END IF; -- check return status
9513: END IF;
9514:
9515: -- Update scrap quantity in WIP_DISCRETE_JOBS and insert into MMTT IF
9516: -- scrap account provided
9517: scrap_txns(p_gib => p_gib,
9518: x_returnStatus => x_returnStatus);
9519: