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 1219: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br, wip_operation_resources wor

1215: CURSOR c_get_pend_res_txns_emp(p_wip_entity_id NUMBER,
1216: p_operation_seq_num NUMBER,
1217: p_employee_id NUMBER ) IS
1218: SELECT NVL( SUM( transaction_quantity ), 0 )
1219: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br, wip_operation_resources wor
1220: WHERE wcti.wip_entity_id = wor.wip_entity_id
1221: AND wcti.operation_seq_num = wor.operation_seq_num
1222: AND wcti.resource_seq_num = wor.resource_seq_num
1223: AND wcti.organization_id = wor.organization_id

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

1243: p_operation_seq_num NUMBER) IS
1244: -- Here we cannot join with wcti.resource_id column
1245: -- since this col can be null.
1246: SELECT NVL( SUM( transaction_quantity ), 0 )
1247: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br, wip_operation_resources wor
1248: WHERE wcti.wip_entity_id = wor.wip_entity_id
1249: AND wcti.operation_seq_num = wor.operation_seq_num
1250: AND wcti.resource_seq_num = wor.resource_seq_num
1251: AND wcti.organization_id = wor.organization_id

Line 1350: wip_operation_resources wor

1346: p_resource_seq_num IN NUMBER,
1347: p_employee_id NUMBER ) IS
1348: SELECT NVL( SUM( transaction_quantity ), 0 )
1349: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br,
1350: wip_operation_resources wor
1351: WHERE wcti.wip_entity_id = wor.wip_entity_id
1352: AND wcti.operation_seq_num = wor.operation_seq_num
1353: AND wcti.resource_seq_num = wor.resource_seq_num
1354: AND wcti.organization_id = wor.organization_id

Line 1385: wip_operation_resources wor

1381: p_operation_seq_num IN NUMBER,
1382: p_resource_seq_num IN NUMBER) IS
1383: SELECT NVL( SUM( transaction_quantity ), 0 )
1384: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br,
1385: wip_operation_resources wor
1386: WHERE wcti.wip_entity_id = wor.wip_entity_id
1387: AND wcti.operation_seq_num = wor.operation_seq_num
1388: AND wcti.resource_seq_num = wor.resource_seq_num
1389: AND wcti.organization_id = wor.organization_id

Line 1494: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,

1490: CURSOR c_get_assigned_start_emp(p_employee_id IN NUMBER,
1491: p_workorder_id IN NUMBER,
1492: p_operation_seq_num IN NUMBER) IS
1493: SELECT MIN(AWAS.ASSIGN_START_DATE)
1494: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,
1495: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW
1496: WHERE WOR.resource_id = AOR.resource_id
1497: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1498: AND AOR.operation_resource_id = AWAS.operation_resource_id

Line 1577: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,

1573: CURSOR c_get_assigned_end_emp(p_employee_id IN NUMBER,
1574: p_workorder_id IN NUMBER,
1575: p_operation_seq_num IN NUMBER) IS
1576: SELECT MAX(AWAS.ASSIGN_END_DATE)
1577: FROM WIP_Operation_Resources WOR, AHL_OPERATION_RESOURCES AOR,
1578: AHL_WORK_ASSIGNMENTS AWAS, AHL_WORKORDERS AW
1579: WHERE WOR.resource_id = AOR.resource_id
1580: AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
1581: AND AOR.operation_resource_id = AWAS.operation_resource_id