APPS.AHL_COMPLETIONS_PVT dependencies on WIP_COST_TXN_INTERFACE

Line 2751: WIP_COST_TXN_INTERFACE WIPT

2747: IS
2748: SELECT MIN(WIPT.TRANSACTION_DATE),
2749: MAX(WIPT.TRANSACTION_DATE + (WIPT.TRANSACTION_QUANTITY/24))
2750: FROM
2751: WIP_COST_TXN_INTERFACE WIPT
2752: WHERE
2753: WIPT.wip_entity_id = p_wip_entity_id
2754: AND WIPT.operation_seq_num = p_operation_seq_num
2755: AND WIPT.organization_id = p_organization_id;

Line 6176: FROM WIP_COST_TXN_INTERFACE

6172: CURSOR get_pending_resource_txns( c_wip_entity_id NUMBER,
6173: c_operation_seq_num NUMBER,
6174: c_resource_seq_num NUMBER ) IS
6175: SELECT NVL( SUM( transaction_quantity ), 0 )
6176: FROM WIP_COST_TXN_INTERFACE
6177: WHERE wip_entity_id = c_wip_entity_id
6178: AND operation_seq_num = c_operation_seq_num
6179: AND resource_seq_num = c_resource_seq_num
6180: AND process_status = 1;

Line 8416: FROM WIP_COST_TXN_INTERFACE

8412: CURSOR get_pending_resource_txns( c_wip_entity_id NUMBER,
8413: c_operation_seq_num NUMBER,
8414: c_resource_seq_num NUMBER ) IS
8415: SELECT NVL( SUM( transaction_quantity ), 0 )
8416: FROM WIP_COST_TXN_INTERFACE
8417: WHERE wip_entity_id = c_wip_entity_id
8418: AND operation_seq_num = c_operation_seq_num
8419: AND resource_seq_num = c_resource_seq_num
8420: AND process_status = 1;

Line 10729: FROM WIP_COST_TXN_INTERFACE WIPT

10725: x_operation_seq_num NUMBER)
10726: IS
10727: SELECT MIN(WIPT.TRANSACTION_DATE),
10728: MAX(WIPT.TRANSACTION_DATE + (WIPT.TRANSACTION_QUANTITY/24))
10729: FROM WIP_COST_TXN_INTERFACE WIPT
10730: WHERE WIPT.WIP_ENTITY_ID = x_wip_entity_id
10731: AND WIPT.OPERATION_SEQ_NUM = x_operation_seq_num
10732: AND WIPT.RESOURCE_TYPE = 2 -- Person
10733: AND WIPT.PROCESS_STATUS = 1; -- Pending*/

Line 10741: FROM WIP_COST_TXN_INTERFACE WIPT,BOM_RESOURCES BOMR, wip_operation_resources WOR

10737: x_operation_seq_num NUMBER)
10738: IS
10739: SELECT MIN(WIPT.TRANSACTION_DATE),
10740: MAX(WIPT.TRANSACTION_DATE + (WIPT.TRANSACTION_QUANTITY/24))
10741: FROM WIP_COST_TXN_INTERFACE WIPT,BOM_RESOURCES BOMR, wip_operation_resources WOR
10742: WHERE WOR.RESOURCE_ID = BOMR.RESOURCE_ID
10743: AND WOR.RESOURCE_SEQ_NUM = WIPT.RESOURCE_SEQ_NUM
10744: AND WIPT.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID
10745: AND WIPT.OPERATION_SEQ_NUM = WOR.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);