APPS.AHL_COMPLETIONS_PVT dependencies on WIP_COST_TXN_INTERFACE

Line 2638: WIP_COST_TXN_INTERFACE WIPT

2634: IS
2635: SELECT MIN(WIPT.TRANSACTION_DATE),
2636: MAX(WIPT.TRANSACTION_DATE + (WIPT.TRANSACTION_QUANTITY/24))
2637: FROM
2638: WIP_COST_TXN_INTERFACE WIPT
2639: WHERE
2640: WIPT.wip_entity_id = p_wip_entity_id
2641: AND WIPT.operation_seq_num = p_operation_seq_num
2642: AND WIPT.organization_id = p_organization_id;

Line 5894: FROM WIP_COST_TXN_INTERFACE

5890: CURSOR get_pending_resource_txns( c_wip_entity_id NUMBER,
5891: c_operation_seq_num NUMBER,
5892: c_resource_seq_num NUMBER ) IS
5893: SELECT NVL( SUM( transaction_quantity ), 0 )
5894: FROM WIP_COST_TXN_INTERFACE
5895: WHERE wip_entity_id = c_wip_entity_id
5896: AND operation_seq_num = c_operation_seq_num
5897: AND resource_seq_num = c_resource_seq_num
5898: AND process_status = 1;

Line 8001: FROM WIP_COST_TXN_INTERFACE

7997: CURSOR get_pending_resource_txns( c_wip_entity_id NUMBER,
7998: c_operation_seq_num NUMBER,
7999: c_resource_seq_num NUMBER ) IS
8000: SELECT NVL( SUM( transaction_quantity ), 0 )
8001: FROM WIP_COST_TXN_INTERFACE
8002: WHERE wip_entity_id = c_wip_entity_id
8003: AND operation_seq_num = c_operation_seq_num
8004: AND resource_seq_num = c_resource_seq_num
8005: AND process_status = 1;

Line 9944: FROM WIP_COST_TXN_INTERFACE WIPT

9940: x_operation_seq_num NUMBER)
9941: IS
9942: SELECT MIN(WIPT.TRANSACTION_DATE),
9943: MAX(WIPT.TRANSACTION_DATE + (WIPT.TRANSACTION_QUANTITY/24))
9944: FROM WIP_COST_TXN_INTERFACE WIPT
9945: WHERE WIPT.WIP_ENTITY_ID = x_wip_entity_id
9946: AND WIPT.OPERATION_SEQ_NUM = x_operation_seq_num
9947: AND WIPT.RESOURCE_TYPE = 2 -- Person
9948: AND WIPT.PROCESS_STATUS = 1; -- Pending

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);