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.CSD_HV_WIP_JOB_PVT dependencies on WIP_OPERATIONS

Line 1631: wip_operations wo

1627: SELECT
1628: wo.quantity_waiting_to_move,
1629: 'Y' allow_moves
1630: FROM
1631: wip_operations wo
1632: WHERE wo.operation_seq_num =
1633: (select max(operation_seq_num)
1634: from wip_operations wo1
1635: where wo1.organization_id = wo.organization_id

Line 1634: from wip_operations wo1

1630: FROM
1631: wip_operations wo
1632: WHERE wo.operation_seq_num =
1633: (select max(operation_seq_num)
1634: from wip_operations wo1
1635: where wo1.organization_id = wo.organization_id
1636: and wo1.wip_entity_id = wo.wip_entity_id
1637: and wo1.repetitive_schedule_id is NULL)
1638: AND wo.organization_id = c_org_id

Line 1659: wip_operations wo

1655: SELECT
1656: wo.quantity_waiting_to_move,
1657: 'N' allow_moves
1658: FROM
1659: wip_operations wo
1660: WHERE wo.operation_seq_num =
1661: (select max(operation_seq_num)
1662: from wip_operations wo1
1663: where wo1.organization_id = wo.organization_id

Line 1662: from wip_operations wo1

1658: FROM
1659: wip_operations wo
1660: WHERE wo.operation_seq_num =
1661: (select max(operation_seq_num)
1662: from wip_operations wo1
1663: where wo1.organization_id = wo.organization_id
1664: and wo1.wip_entity_id = wo.wip_entity_id
1665: and wo1.repetitive_schedule_id is NULL)
1666: AND wo.organization_id = c_org_id

Line 2190: from wip_operations

2186: from
2187: (select operation_seq_num,
2188: quantity_in_queue,
2189: quantity_waiting_to_move
2190: from wip_operations
2191: where wip_entity_id = c_wip_entity_id
2192: and operation_seq_num < c_op_seq_num
2193: and quantity_in_queue + quantity_waiting_to_move > 0
2194: order by operation_seq_num desc)

Line 4240: from wip_operations

4236: wip_entity_id = p_wip_entity_id ;
4237:
4238: CURSOR get_operation_exists(p_wip_entity_id NUMBER ) IS
4239: SELECT 'exists'
4240: from wip_operations
4241: where wip_entity_id = p_wip_entity_id
4242: and rownum = 1;
4243:
4244: BEGIN

Line 5496: -- select min(operation_seq_num) from wip_operations_v where wip_entity_id = p_wip_entity_id;

5492: where inventory_item_id = p_item_id and serial_number = p_serial_number and current_organization_id = p_org_id;
5493:
5494:
5495: -- Cursor c_get_min_operation_seq(p_wip_entity_id number) is
5496: -- select min(operation_seq_num) from wip_operations_v where wip_entity_id = p_wip_entity_id;
5497:
5498: l_inventory_item_id NUMBER;
5499: l_unit_of_measure VARCHAR2(3);
5500: l_quantity NUMBER;

Line 6169: select min(operation_seq_num) from wip_operations_v where wip_entity_id = p_wip_entity_id;

6165: where inventory_item_id = p_item_id and serial_number = p_serial_number and current_organization_id = p_org_id;
6166:
6167:
6168: Cursor c_get_min_operation_seq(p_wip_entity_id number) is
6169: select min(operation_seq_num) from wip_operations_v where wip_entity_id = p_wip_entity_id;
6170:
6171: l_inventory_item_id NUMBER;
6172: l_unit_of_measure VARCHAR2(3);
6173: l_quantity NUMBER;