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_COST_TXN_INTERFACE

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 1373: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br,

1369: p_operation_seq_num NUMBER,
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

Line 1408: FROM WIP_COST_TXN_INTERFACE wcti, bom_resources br,

1404: CURSOR c_get_pend_res_txns_res(p_wip_entity_id IN NUMBER,
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