APPS.AHL_COMPLETIONS_PVT dependencies on WIP_TRANSACTIONS

Line 2737: WIP_TRANSACTIONS WIPT

2733: SELECT
2734: MIN(WIPT.TRANSACTION_DATE),
2735: MAX(WIPT.TRANSACTION_DATE + (WIPT.TRANSACTION_QUANTITY/24))
2736: FROM
2737: WIP_TRANSACTIONS WIPT
2738: WHERE
2739: WIPT.wip_entity_id = p_wip_entity_id
2740: AND WIPT.operation_seq_num = p_operation_seq_num
2741: AND WIPT.organization_id = p_organization_id;

Line 6165: FROM WIP_TRANSACTIONS

6161: CURSOR get_resource_txns( c_wip_entity_id NUMBER,
6162: c_operation_seq_num NUMBER,
6163: c_resource_seq_num NUMBER ) IS
6164: SELECT NVL( SUM( transaction_quantity ), 0 )
6165: FROM WIP_TRANSACTIONS
6166: WHERE wip_entity_id = c_wip_entity_id
6167: AND operation_seq_num = c_operation_seq_num
6168: AND resource_seq_num = c_resource_seq_num;
6169:

Line 8405: FROM WIP_TRANSACTIONS

8401: CURSOR get_resource_txns( c_wip_entity_id NUMBER,
8402: c_operation_seq_num NUMBER,
8403: c_resource_seq_num NUMBER ) IS
8404: SELECT NVL( SUM( transaction_quantity ), 0 )
8405: FROM WIP_TRANSACTIONS
8406: WHERE wip_entity_id = c_wip_entity_id
8407: AND operation_seq_num = c_operation_seq_num
8408: AND resource_seq_num = c_resource_seq_num;
8409:

Line 10714: FROM WIP_TRANSACTIONS WIPT,

10710: SELECT MIN(WIPT.TRANSACTION_DATE),
10711: MAX(WIPT.TRANSACTION_DATE + (WIPT.TRANSACTION_QUANTITY/24))
10712: -- Using the transaction quantity above since we know the
10713: -- transaction uom is in hours
10714: FROM WIP_TRANSACTIONS WIPT,
10715: BOM_RESOURCES BOMR
10716: WHERE WIPT.RESOURCE_ID = BOMR.RESOURCE_ID
10717: AND WIPT.WIP_ENTITY_ID = x_wip_entity_id
10718: AND WIPT.OPERATION_SEQ_NUM = x_operation_seq_num

Line 10781: -- WIP_TRANSACTIONS and WIP_COST_TXN_INTERFACE tables for the

10777: --RAISE FND_API.G_RET_STS_ERROR;
10778: END IF;
10779: CLOSE c_get_wo_details;
10780: -- Get the minimum and maximum transaction dates from the
10781: -- WIP_TRANSACTIONS and WIP_COST_TXN_INTERFACE tables for the
10782: -- resource transactions and pending resource transactions
10783: OPEN c_get_txn_dates(l_wip_entity_id, p_x_operation_tbl(i).operation_sequence_num);
10784: FETCH c_get_txn_dates INTO l_min_txn_date, l_max_txn_date;
10785: OPEN c_get_pending_txn_dates(l_wip_entity_id, p_x_operation_tbl(i).operation_sequence_num);