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.

[Home] [Help]

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 2938: FROM bom_standard_operations bso1,

2934: bso2.operation_code,
2935: wo2.department_id,
2936: bd2.department_code,
2937: WIP_CONSTANTS.MOVE_PROC
2938: FROM bom_standard_operations bso1,
2939: bom_standard_operations bso2,
2940: bom_departments bd1,
2941: bom_departments bd2,
2942: wip_operations wo1,

Line 2939: bom_standard_operations bso2,

2935: wo2.department_id,
2936: bd2.department_code,
2937: WIP_CONSTANTS.MOVE_PROC
2938: FROM bom_standard_operations bso1,
2939: bom_standard_operations bso2,
2940: bom_departments bd1,
2941: bom_departments bd2,
2942: wip_operations wo1,
2943: wip_operations wo2

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

2946: AND wo1.operation_seq_num = wmti.fm_operation_seq_num
2947: AND wo2.organization_id = wmti.organization_id
2948: AND wo2.wip_entity_id = wmti.wip_entity_id
2949: AND wo2.operation_seq_num = wmti.to_operation_seq_num
2950: /* Standard operation ID is optional, so we should use outer join */
2951: AND bso1.standard_operation_id(+) = wo1.standard_operation_id
2952: AND bso2.standard_operation_id(+) = wo2.standard_operation_id
2953: AND wo1.department_id = bd1.department_id
2954: AND wo2.department_id = bd2.department_id

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

2947: AND wo2.organization_id = wmti.organization_id
2948: AND wo2.wip_entity_id = wmti.wip_entity_id
2949: AND wo2.operation_seq_num = wmti.to_operation_seq_num
2950: /* Standard operation ID is optional, so we should use outer join */
2951: AND bso1.standard_operation_id(+) = wo1.standard_operation_id
2952: AND bso2.standard_operation_id(+) = wo2.standard_operation_id
2953: AND wo1.department_id = bd1.department_id
2954: AND wo2.department_id = bd2.department_id
2955: AND (wmti.entity_type IN (WIP_CONSTANTS.DISCRETE,

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

2948: AND wo2.wip_entity_id = wmti.wip_entity_id
2949: AND wo2.operation_seq_num = wmti.to_operation_seq_num
2950: /* Standard operation ID is optional, so we should use outer join */
2951: AND bso1.standard_operation_id(+) = wo1.standard_operation_id
2952: AND bso2.standard_operation_id(+) = wo2.standard_operation_id
2953: AND wo1.department_id = bd1.department_id
2954: AND wo2.department_id = bd2.department_id
2955: AND (wmti.entity_type IN (WIP_CONSTANTS.DISCRETE,
2956: WIP_CONSTANTS.LOTBASED)