APPS.AHL_PRD_UTIL_PKG dependencies on WIP_TRANSACTIONS

Line 1207: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS

1203: CURSOR c_get_res_txns_emp(p_wip_entity_id IN NUMBER,
1204: p_operation_seq_num IN NUMBER,
1205: p_employee_id IN NUMBER ) IS
1206: SELECT NVL( SUM( transaction_quantity ), 0 )
1207: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS
1208: WHERE WT.resource_id = BRS.resource_id
1209: AND BRS.resource_type = 2 -- person.
1210: AND wt.wip_entity_id = p_wip_entity_id
1211: AND wt.operation_seq_num = p_operation_seq_num

Line 1235: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS

1231: -- query to retrieve total hrs transacted by all employees.
1232: CURSOR c_get_res_txns_op(p_wip_entity_id IN NUMBER,
1233: p_operation_seq_num IN NUMBER) IS
1234: SELECT NVL( SUM( transaction_quantity ), 0 )
1235: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS
1236: WHERE WT.resource_id = BRS.resource_id
1237: AND BRS.resource_type = 2 -- person.
1238: AND WT.wip_entity_id = p_wip_entity_id
1239: AND WT.operation_seq_num = p_operation_seq_num;

Line 1334: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS

1330: p_operation_seq_num IN NUMBER,
1331: p_resource_seq_num IN NUMBER,
1332: p_employee_id IN NUMBER ) IS
1333: SELECT NVL( SUM( transaction_quantity ), 0 )
1334: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS
1335: WHERE WT.resource_id = BRS.resource_id
1336: AND BRS.resource_type = 2 -- person.
1337: AND WT.transaction_type = 1 -- resource txn.
1338: AND wt.wip_entity_id = p_wip_entity_id

Line 1369: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS

1365: CURSOR c_get_res_txns_res(p_wip_entity_id IN NUMBER,
1366: p_operation_seq_num IN NUMBER,
1367: p_resource_seq_num IN NUMBER) IS
1368: SELECT NVL( SUM( transaction_quantity ), 0 )
1369: FROM WIP_TRANSACTIONS WT, BOM_RESOURCES BRS
1370: WHERE WT.resource_id = BRS.resource_id
1371: AND BRS.resource_type = 2 -- person.
1372: AND WT.transaction_type = 1 -- resource txn.
1373: AND wt.wip_entity_id = p_wip_entity_id