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.AHL_PRD_UTIL_PKG dependencies on WIP_OPERATION_RESOURCES

Line 1243: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br, wip_operation_resources wor

1239: CURSOR c_get_pend_res_txns_emp(p_wip_entity_id NUMBER,
1240: p_operation_seq_num NUMBER,
1241: p_employee_id NUMBER ) IS
1242: SELECT NVL( SUM( transaction_quantity ), 0 )
1243: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br, wip_operation_resources wor
1244: WHERE wcti.wip_entity_id = wor.wip_entity_id
1245: AND wcti.operation_seq_num = wor.operation_seq_num
1246: AND wcti.resource_seq_num = wor.resource_seq_num
1247: AND wcti.organization_id = wor.organization_id

Line 1271: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br, wip_operation_resources wor

1267: p_operation_seq_num NUMBER) IS
1268: -- Here we cannot join with wcti.resource_id column
1269: -- since this col can be null.
1270: SELECT NVL( SUM( transaction_quantity ), 0 )
1271: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br, wip_operation_resources wor
1272: WHERE wcti.wip_entity_id = wor.wip_entity_id
1273: AND wcti.operation_seq_num = wor.operation_seq_num
1274: AND wcti.resource_seq_num = wor.resource_seq_num
1275: AND wcti.organization_id = wor.organization_id

Line 1374: wip_operation_resources wor

1370: p_resource_seq_num IN NUMBER,
1371: p_employee_id NUMBER ) IS
1372: SELECT NVL( SUM( transaction_quantity ), 0 )
1373: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br,
1374: wip_operation_resources wor
1375: WHERE wcti.wip_entity_id = wor.wip_entity_id
1376: AND wcti.operation_seq_num = wor.operation_seq_num
1377: AND wcti.resource_seq_num = wor.resource_seq_num
1378: AND wcti.organization_id = wor.organization_id

Line 1409: wip_operation_resources wor

1405: p_operation_seq_num IN NUMBER,
1406: p_resource_seq_num IN NUMBER) IS
1407: SELECT NVL( SUM( transaction_quantity ), 0 )
1408: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br,
1409: wip_operation_resources wor
1410: WHERE wcti.wip_entity_id = wor.wip_entity_id
1411: AND wcti.operation_seq_num = wor.operation_seq_num
1412: AND wcti.resource_seq_num = wor.resource_seq_num
1413: AND wcti.organization_id = wor.organization_id

Line 1518: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,

1514: CURSOR c_get_assigned_start_emp(p_employee_id IN NUMBER,
1515: p_workorder_id IN NUMBER,
1516: p_operation_seq_num IN NUMBER) IS
1517: SELECT MIN(AWAS.ASSIGN_START_DATE)
1518: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,
1519: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW
1520: WHERE WOR.resource_id = AOR.resource_id
1521: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1522: AND AOR.operation_resource_id = AWAS.operation_resource_id

Line 1601: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,

1597: CURSOR c_get_assigned_end_emp(p_employee_id IN NUMBER,
1598: p_workorder_id IN NUMBER,
1599: p_operation_seq_num IN NUMBER) IS
1600: SELECT MAX(AWAS.ASSIGN_END_DATE)
1601: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,
1602: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW
1603: WHERE WOR.resource_id = AOR.resource_id
1604: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1605: AND AOR.operation_resource_id = AWAS.operation_resource_id