APPS.AHL_PRD_MTLTXN_PVT dependencies on AHL_WORKORDER_OPERATIONS_V

Line 1611: AHL_WORKORDER_OPERATIONS_V B,

1607: )
1608: IS
1609: SELECT COUNT(A.workorder_mtl_txn_id)
1610: FROM AHL_WORKORDER_MTL_TXNS A,
1611: AHL_WORKORDER_OPERATIONS_V B,
1612: AHL_SCHEDULE_MATERIALS C
1613: WHERE B.WORKORDER_ID=C_WRK_ID
1614: AND B.WORKORDER_OPERATION_ID=A.WORKORDER_OPERATION_ID
1615: AND B.WORKORDER_OPERATION_ID=C.WORKORDER_OPERATION_ID

Line 1830: FROM AHL_WORKORDER_OPERATIONS_V A ,AHL_SCHEDULE_MATERIALS B

1826:
1827: /*
1828: CURSOR TRANSACTION_DATE_CUR(C_WORKORDER_OPERATION_ID NUMBER,C_WORKORDER_ID NUMBER,C_INV_ITEM_ID NUMBER) IS
1829: SELECT A.scheduled_start_date
1830: FROM AHL_WORKORDER_OPERATIONS_V A ,AHL_SCHEDULE_MATERIALS B
1831: WHERE A.WORKORDER_OPERATION_ID=C_WORKORDER_OPERATION_ID
1832: AND A.WORKORDER_ID=C_WORKORDER_ID
1833: AND A.WORKORDER_OPERATION_ID=B.WORKORDER_OPERATION_ID
1834: AND B.INVENTORY_ITEM_ID=C_INV_ITEM_ID

Line 3928: ,AHL_WORKORDER_OPERATIONS_V B

3924: issued NUMBER;
3925: CURSOR CUR_GET_WOID_LEVEL_QTY IS
3926: SELECT SUM(nvl(QUANTITY,0))
3927: FROM AHL_WORKORDER_MTL_TXNS A
3928: ,AHL_WORKORDER_OPERATIONS_V B
3929: WHERE A.ORGANIZATION_ID = p_org_id
3930: AND A.INVENTORY_ITEM_ID = p_item_id
3931: AND NVL(A.lot_number,'X')=NVL(p_lotnum,NVL(A.lot_number,'X'))
3932: AND NVL(A.revision,'X')=NVL(p_rev,NVL(A.REVISION,'X'))

Line 3977: -- AHL_WORKORDER_OPERATIONS_V B

3973: CURSOR CUR_GET_WO_ISSUE_QTY
3974: IS
3975: SELECT SUM(nvl(QUANTITY,0))
3976: FROM AHL_WORKORDER_MTL_TXNS A ,
3977: -- AHL_WORKORDER_OPERATIONS_V B
3978: -- JKJAIN BUG # 7587902
3979: AHL_WORKORDER_OPERATIONS B
3980: WHERE A.ORGANIZATION_ID = p_org_id
3981: AND A.INVENTORY_ITEM_ID = p_item_id

Line 3992: -- AHL_WORKORDER_OPERATIONS_V B

3988: CURSOR CUR_GET_WO_RET_QTY
3989: IS
3990: SELECT SUM(nvl(QUANTITY,0))
3991: FROM AHL_WORKORDER_MTL_TXNS A ,
3992: -- AHL_WORKORDER_OPERATIONS_V B
3993: -- JKJAIN BUG # 7587902
3994: AHL_WORKORDER_OPERATIONS B
3995: WHERE A.ORGANIZATION_ID = p_org_id
3996: AND A.INVENTORY_ITEM_ID = p_item_id