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 1460: FROM wip_operations wo

1456: quantity_completed,
1457: p_interface_id,
1458: p_wip_entity_id,
1459: quantity_completed
1460: FROM wip_operations wo
1461: WHERE wo.wip_entity_id = p_wip_entity_id;
1462:
1463: END insert_cst_interface;
1464:

Line 1836: wip_operations wo

1832: SELECT
1833: wo.quantity_waiting_to_move,
1834: 'Y' allow_moves
1835: FROM
1836: wip_operations wo
1837: WHERE wo.operation_seq_num =
1838: (select max(operation_seq_num)
1839: from wip_operations wo1
1840: where wo1.organization_id = wo.organization_id

Line 1839: from wip_operations wo1

1835: FROM
1836: wip_operations wo
1837: WHERE wo.operation_seq_num =
1838: (select max(operation_seq_num)
1839: from wip_operations wo1
1840: where wo1.organization_id = wo.organization_id
1841: and wo1.wip_entity_id = wo.wip_entity_id
1842: and wo1.repetitive_schedule_id is NULL)
1843: AND wo.organization_id = c_org_id

Line 1864: wip_operations wo

1860: SELECT
1861: wo.quantity_waiting_to_move,
1862: 'N' allow_moves
1863: FROM
1864: wip_operations wo
1865: WHERE wo.operation_seq_num =
1866: (select max(operation_seq_num)
1867: from wip_operations wo1
1868: where wo1.organization_id = wo.organization_id

Line 1867: from wip_operations wo1

1863: FROM
1864: wip_operations wo
1865: WHERE wo.operation_seq_num =
1866: (select max(operation_seq_num)
1867: from wip_operations wo1
1868: where wo1.organization_id = wo.organization_id
1869: and wo1.wip_entity_id = wo.wip_entity_id
1870: and wo1.repetitive_schedule_id is NULL)
1871: AND wo.organization_id = c_org_id

Line 2527: from wip_operations

2523: from
2524: (select operation_seq_num,
2525: quantity_in_queue,
2526: quantity_waiting_to_move
2527: from wip_operations
2528: where wip_entity_id = c_wip_entity_id
2529: and operation_seq_num < c_op_seq_num
2530: and quantity_in_queue + quantity_waiting_to_move > 0
2531: order by operation_seq_num desc)

Line 4701: from wip_operations

4697: wip_entity_id = p_wip_entity_id ;
4698:
4699: CURSOR get_operation_exists(p_wip_entity_id NUMBER ) IS
4700: SELECT 'exists'
4701: from wip_operations
4702: where wip_entity_id = p_wip_entity_id
4703: and rownum = 1;
4704:
4705: --bug#8465719 begin

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

6383: where inventory_item_id = p_item_id and serial_number = p_serial_number and current_organization_id = p_org_id;
6384:
6385:
6386: -- Cursor c_get_min_operation_seq(p_wip_entity_id number) is
6387: -- select min(operation_seq_num) from wip_operations_v where wip_entity_id = p_wip_entity_id;
6388:
6389: l_inventory_item_id NUMBER;
6390: l_unit_of_measure VARCHAR2(3);
6391: l_quantity NUMBER;

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

7193: where inventory_item_id = p_item_id and serial_number = p_serial_number and current_organization_id = p_org_id;
7194:
7195:
7196: Cursor c_get_min_operation_seq(p_wip_entity_id number) is
7197: select min(operation_seq_num) from wip_operations_v where wip_entity_id = p_wip_entity_id;
7198:
7199: l_inventory_item_id NUMBER;
7200: l_unit_of_measure VARCHAR2(3);
7201: l_quantity NUMBER;

Line 8063: WIP_OPERATIONS WO,

8059: MTL_SYSTEM_ITEMS_KFV MSIK,
8060: WIP_ENTITIES WE,
8061: CSD_WIP_TRANSACTION_DETAILS CWTD,
8062: WIP_DISCRETE_JOBS WDJ,
8063: WIP_OPERATIONS WO,
8064: MTL_SERIAL_NUMBERS MSN,
8065: MTL_TRANSACTION_REASONS MTR
8066: WHERE
8067: CRJX.wip_entity_id = p_wip_entity_id

Line 8282: wip_operations wo,

8278: WIP_OPERATION_RESOURCES WOR,
8279: WIP_ENTITIES WE,
8280: CSD_WIP_TRANSACTION_DETAILS WTD,
8281: BOM_RESOURCES BR,
8282: wip_operations wo,
8283: WIP_DISCRETE_JOBS wdj,
8284: per_all_people_f papf,
8285: MTL_PARAMETERS MP
8286: WHERE CRJX.wip_entity_id = p_wip_entity_id

Line 8455: WIP_OPERATIONS WO,

8451: wo.quantity_in_queue, -- transaction_quantity
8452: msik.primary_uom_code, -- transaction_uom
8453: crjx.wip_entity_id
8454: FROM CSD_REPAIR_JOB_XREF CRJX,
8455: WIP_OPERATIONS WO,
8456: BOM_DEPARTMENTS BD,
8457: wip_discrete_jobs wdj,
8458: wip_entities we,
8459: mfg_lookups ml,

Line 8649: wip_operations wo

8645: bom_resources res,
8646: bom_department_resources bdr,
8647: bom_departments bd,
8648: mfg_lookups lup ,
8649: wip_operations wo
8650: WHERE nvl(res.disable_date, sysdate + 2) > sysdate
8651: and res.resource_id = bdr.resource_id
8652: and res.default_activity_id = cst.activity_id (+)
8653: and nvl(cst.organization_id(+), res.organization_id) = res.organization_id

Line 8718: wip_operations wo,

8714: WIP_OPERATION_RESOURCES WOR,
8715: WIP_ENTITIES WE,
8716: CSD_WIP_TRANSACTION_DETAILS WTD,
8717: BOM_RESOURCES BR,
8718: wip_operations wo,
8719: WIP_DISCRETE_JOBS wdj,
8720: per_all_people_f papf,
8721: MTL_PARAMETERS MP
8722: WHERE CRJX.wip_entity_id = p_wip_entity_id

Line 9485: WIP_OPERATIONS_PKG.Valid_Op_Delete(p_organization_id => p_organization_id,

9481: lc_mod_name||'.begin',
9482: 'Entering procedure is_delete_wip_op_valid' );
9483: END IF;
9484:
9485: WIP_OPERATIONS_PKG.Valid_Op_Delete(p_organization_id => p_organization_id,
9486: p_wip_entity_id => p_wip_entity_id,
9487: p_operation_seq_num => p_operation_seq_num,
9488: x_return_status => l_return_status,
9489: x_error_message => l_error_message);

Line 9495: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned success.' );

9491: IF (l_return_status = FND_API.G_RET_STS_SUCCESS ) THEN
9492: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9493: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
9494: lc_mod_name,
9495: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned success.' );
9496: END IF;
9497:
9498: open c_time_clock_entries_exist;
9499: fetch c_time_clock_entries_exist

Line 9539: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned non-success value: ' || l_return_status );

9535:
9536: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9537: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
9538: lc_mod_name,
9539: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned non-success value: ' || l_return_status );
9540: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
9541: lc_mod_name,
9542: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned error message: ' || l_error_message );
9543: END IF;

Line 9542: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned error message: ' || l_error_message );

9538: lc_mod_name,
9539: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned non-success value: ' || l_return_status );
9540: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
9541: lc_mod_name,
9542: 'WIP_OPERATIONS_PKG.Valid_Op_Delete returned error message: ' || l_error_message );
9543: END IF;
9544: return lc_not_valid;
9545:
9546: EXCEPTION

Line 9551: 'WIP_OPERATIONS_PKG.Valid_Op_Delete threw exception');

9547: WHEN OTHERS THEN
9548: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
9549: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE,
9550: lc_mod_name,
9551: 'WIP_OPERATIONS_PKG.Valid_Op_Delete threw exception');
9552: END IF;
9553:
9554: return lc_not_valid;
9555:

Line 9615: from wip_operations

9611: and wip.inventory_item_id = csd.inventory_item_id;
9612:
9613: cursor c_get_first_operation is
9614: select min(operation_seq_num)
9615: from wip_operations
9616: where wip_entity_id = p_op_dtls.wip_entity_id;
9617:
9618: BEGIN
9619:

Line 9650: 'Just before calling WIP_OPERATIONS_PKG.Delete_Operation');

9646:
9647: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
9648: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
9649: lc_mod_name||'beforecallinsertjobdtls',
9650: 'Just before calling WIP_OPERATIONS_PKG.Delete_Operation');
9651: END IF;
9652:
9653:
9654: WIP_OPERATIONS_PKG.Delete_Operation(p_organization_id => p_op_dtls.organization_id,

Line 9654: WIP_OPERATIONS_PKG.Delete_Operation(p_organization_id => p_op_dtls.organization_id,

9650: 'Just before calling WIP_OPERATIONS_PKG.Delete_Operation');
9651: END IF;
9652:
9653:
9654: WIP_OPERATIONS_PKG.Delete_Operation(p_organization_id => p_op_dtls.organization_id,
9655: p_wip_entity_id => p_op_dtls.wip_entity_id,
9656: p_operation_seq_num => p_op_dtls.operation_seq_num,
9657: x_return_status => l_return_status,
9658: x_error_message => l_error_message);

Line 9664: 'Error during WIP_OPERATIONS_PKG.Delete_Operation: ' || l_error_message);

9660: If (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
9661: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
9662: FND_LOG.STRING( FND_LOG.LEVEL_EVENT,
9663: lc_mod_name,
9664: 'Error during WIP_OPERATIONS_PKG.Delete_Operation: ' || l_error_message);
9665: END IF;
9666:
9667: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9668: fnd_message.set_token('MESSAGE', l_error_message);