APPS.AHL_PRD_UTIL_PKG dependencies on WIP_TRANSACTIONS

Line 1231: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS

1227: CURSOR c_get_res_txns_emp(p_wip_entity_id IN NUMBER,
1228: p_operation_seq_num IN NUMBER,
1229: p_employee_id IN NUMBER ) IS
1230: SELECT NVL( SUM( transaction_quantity ), 0 )
1231: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS
1232: WHERE WT.resource_id = BRS.resource_id
1233: AND BRS.resource_type = 2 -- person.
1234: AND wt.wip_entity_id = p_wip_entity_id
1235: AND wt.operation_seq_num = p_operation_seq_num

Line 1259: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS

1255: -- query to retrieve total hrs transacted by all employees.
1256: CURSOR c_get_res_txns_op(p_wip_entity_id IN NUMBER,
1257: p_operation_seq_num IN NUMBER) IS
1258: SELECT NVL( SUM( transaction_quantity ), 0 )
1259: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS
1260: WHERE WT.resource_id = BRS.resource_id
1261: AND BRS.resource_type = 2 -- person.
1262: AND WT.wip_entity_id = p_wip_entity_id
1263: AND WT.operation_seq_num = p_operation_seq_num;

Line 1358: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS

1354: p_operation_seq_num IN NUMBER,
1355: p_resource_seq_num IN NUMBER,
1356: p_employee_id IN NUMBER ) IS
1357: SELECT NVL( SUM( transaction_quantity ), 0 )
1358: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS
1359: WHERE WT.resource_id = BRS.resource_id
1360: AND BRS.resource_type = 2 -- person.
1361: AND WT.transaction_type = 1 -- resource txn.
1362: AND wt.wip_entity_id = p_wip_entity_id

Line 1393: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS

1389: CURSOR c_get_res_txns_res(p_wip_entity_id IN NUMBER,
1390: p_operation_seq_num IN NUMBER,
1391: p_resource_seq_num IN NUMBER) IS
1392: SELECT NVL( SUM( transaction_quantity ), 0 )
1393: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS
1394: WHERE WT.resource_id = BRS.resource_id
1395: AND BRS.resource_type = 2 -- person.
1396: AND WT.transaction_type = 1 -- resource txn.
1397: AND wt.wip_entity_id = p_wip_entity_id