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_MOVE_VALIDATOR dependencies on STANDARD

Line 234: -- If non-standard job and no assembly defined, error out

230: AND wmti.process_status = WIP_CONSTANTS.RUNNING;
231:
232: -- reset enums table
233: enums.delete;
234: -- If non-standard job and no assembly defined, error out
235: UPDATE wip_move_txn_interface wmti
236: SET wmti.process_status = WIP_CONSTANTS.ERROR
237: WHERE wmti.group_id = g_group_id
238: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL

Line 2870: FROM bom_standard_operations bso1,

2866: bso2.operation_code,
2867: wo2.department_id,
2868: bd2.department_code,
2869: WIP_CONSTANTS.MOVE_PROC
2870: FROM bom_standard_operations bso1,
2871: bom_standard_operations bso2,
2872: bom_departments bd1,
2873: bom_departments bd2,
2874: wip_operations wo1,

Line 2871: bom_standard_operations bso2,

2867: wo2.department_id,
2868: bd2.department_code,
2869: WIP_CONSTANTS.MOVE_PROC
2870: FROM bom_standard_operations bso1,
2871: bom_standard_operations bso2,
2872: bom_departments bd1,
2873: bom_departments bd2,
2874: wip_operations wo1,
2875: wip_operations wo2

Line 2882: /* Standard operation ID is optional, so we should use outer join */

2878: AND wo1.operation_seq_num = wmti.fm_operation_seq_num
2879: AND wo2.organization_id = wmti.organization_id
2880: AND wo2.wip_entity_id = wmti.wip_entity_id
2881: AND wo2.operation_seq_num = wmti.to_operation_seq_num
2882: /* Standard operation ID is optional, so we should use outer join */
2883: AND bso1.standard_operation_id(+) = wo1.standard_operation_id
2884: AND bso2.standard_operation_id(+) = wo2.standard_operation_id
2885: AND wo1.department_id = bd1.department_id
2886: AND wo2.department_id = bd2.department_id

Line 2883: AND bso1.standard_operation_id(+) = wo1.standard_operation_id

2879: AND wo2.organization_id = wmti.organization_id
2880: AND wo2.wip_entity_id = wmti.wip_entity_id
2881: AND wo2.operation_seq_num = wmti.to_operation_seq_num
2882: /* Standard operation ID is optional, so we should use outer join */
2883: AND bso1.standard_operation_id(+) = wo1.standard_operation_id
2884: AND bso2.standard_operation_id(+) = wo2.standard_operation_id
2885: AND wo1.department_id = bd1.department_id
2886: AND wo2.department_id = bd2.department_id
2887: AND (wmti.entity_type IN (WIP_CONSTANTS.DISCRETE,

Line 2884: AND bso2.standard_operation_id(+) = wo2.standard_operation_id

2880: AND wo2.wip_entity_id = wmti.wip_entity_id
2881: AND wo2.operation_seq_num = wmti.to_operation_seq_num
2882: /* Standard operation ID is optional, so we should use outer join */
2883: AND bso1.standard_operation_id(+) = wo1.standard_operation_id
2884: AND bso2.standard_operation_id(+) = wo2.standard_operation_id
2885: AND wo1.department_id = bd1.department_id
2886: AND wo2.department_id = bd2.department_id
2887: AND (wmti.entity_type IN (WIP_CONSTANTS.DISCRETE,
2888: WIP_CONSTANTS.LOTBASED)