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 WIP_LINES

Line 160: -- Also validate line_id against wip_lines table. The caller have an option to

156: -- both value must be consistent to each other. Moreover, the wip_entity_id
157: -- provided must have status that allow move transaction(3,4)
158: -- The wip_entity_id provided also need to have assembly associated with it.
159:
160: -- Also validate line_id against wip_lines table. The caller have an option to
161: -- provide either line_id or line_code. If the caller pass line_id, the id
162: -- need to be valid. If the caller pass line_code, we will derive the
163: -- line_id. If the caller pass both, both value must be consistent to
164: -- each other. Only validate these values if the transaction type is

Line 255: FROM wip_lines wl

251: -- Derive LINE_ID if user provided only LINE_CODE.
252: UPDATE wip_move_txn_interface wmti
253: SET wmti.line_id =
254: (SELECT wl.line_id
255: FROM wip_lines wl
256: WHERE wl.line_code = wmti.line_code
257: AND wl.organization_id = wmti.organization_id
258: AND NVL(wl.disable_date, SYSDATE) >= SYSDATE)
259: WHERE wmti.group_id = g_group_id

Line 280: FROM wip_lines wl

276: AND ((wmti.line_id IS NULL)
277: OR
278: (NOT EXISTS
279: (SELECT 'X'
280: FROM wip_lines wl
281: WHERE wl.line_code = NVL(wmti.line_code, wl.line_code)
282: AND wl.line_id = wmti.line_id
283: AND wl.organization_id = wmti.organization_id
284: AND NVL(wl.disable_date, SYSDATE) >= SYSDATE