DBA Data[Home] [Help]

APPS.AHL_COMPLETIONS_PVT dependencies on WIP_TRANSACTIONS

Line 2624: WIP_TRANSACTIONS WIPT

2620: SELECT
2621: MIN(WIPT.TRANSACTION_DATE),
2622: MAX(WIPT.TRANSACTION_DATE + (WIPT.TRANSACTION_QUANTITY/24))
2623: FROM
2624: WIP_TRANSACTIONS WIPT
2625: WHERE
2626: WIPT.wip_entity_id = p_wip_entity_id
2627: AND WIPT.operation_seq_num = p_operation_seq_num
2628: AND WIPT.organization_id = p_organization_id;

Line 5883: FROM WIP_TRANSACTIONS

5879: CURSOR get_resource_txns( c_wip_entity_id NUMBER,
5880: c_operation_seq_num NUMBER,
5881: c_resource_seq_num NUMBER ) IS
5882: SELECT NVL( SUM( transaction_quantity ), 0 )
5883: FROM WIP_TRANSACTIONS
5884: WHERE wip_entity_id = c_wip_entity_id
5885: AND operation_seq_num = c_operation_seq_num
5886: AND resource_seq_num = c_resource_seq_num;
5887:

Line 7990: FROM WIP_TRANSACTIONS

7986: CURSOR get_resource_txns( c_wip_entity_id NUMBER,
7987: c_operation_seq_num NUMBER,
7988: c_resource_seq_num NUMBER ) IS
7989: SELECT NVL( SUM( transaction_quantity ), 0 )
7990: FROM WIP_TRANSACTIONS
7991: WHERE wip_entity_id = c_wip_entity_id
7992: AND operation_seq_num = c_operation_seq_num
7993: AND resource_seq_num = c_resource_seq_num;
7994:

Line 9929: FROM WIP_TRANSACTIONS WIPT,

9925: SELECT MIN(WIPT.TRANSACTION_DATE),
9926: MAX(WIPT.TRANSACTION_DATE + (WIPT.TRANSACTION_QUANTITY/24))
9927: -- Using the transaction quantity above since we know the
9928: -- transaction uom is in hours
9929: FROM WIP_TRANSACTIONS WIPT,
9930: BOM_RESOURCES BOMR
9931: WHERE WIPT.RESOURCE_ID = BOMR.RESOURCE_ID
9932: AND WIPT.WIP_ENTITY_ID = x_wip_entity_id
9933: AND WIPT.OPERATION_SEQ_NUM = x_operation_seq_num

Line 9980: -- WIP_TRANSACTIONS and WIP_COST_TXN_INTERFACE tables for the

9976: --RAISE FND_API.G_RET_STS_ERROR;
9977: END IF;
9978: CLOSE c_get_wo_details;
9979: -- Get the minimum and maximum transaction dates from the
9980: -- WIP_TRANSACTIONS and WIP_COST_TXN_INTERFACE tables for the
9981: -- resource transactions and pending resource transactions
9982: OPEN c_get_txn_dates(l_wip_entity_id, p_x_operation_tbl(i).operation_sequence_num);
9983: FETCH c_get_txn_dates INTO l_min_txn_date, l_max_txn_date;
9984: OPEN c_get_pending_txn_dates(l_wip_entity_id, p_x_operation_tbl(i).operation_sequence_num);