APPS.AHL_PRD_MTLTXN_PVT dependencies on AHL_WORKORDER_OPERATIONS_V

Line 1900: AHL_WORKORDER_OPERATIONS_V B,

1896: )
1897: IS
1898: SELECT COUNT(A.workorder_mtl_txn_id)
1899: FROM AHL_WORKORDER_MTL_TXNS A,
1900: AHL_WORKORDER_OPERATIONS_V B,
1901: AHL_SCHEDULE_MATERIALS C
1902: WHERE B.WORKORDER_ID=C_WRK_ID
1903: AND B.WORKORDER_OPERATION_ID=A.WORKORDER_OPERATION_ID
1904: AND B.WORKORDER_OPERATION_ID=C.WORKORDER_OPERATION_ID

Line 2119: FROM AHL_WORKORDER_OPERATIONS_V A ,AHL_SCHEDULE_MATERIALS B

2115:
2116: /*
2117: CURSOR TRANSACTION_DATE_CUR(C_WORKORDER_OPERATION_ID NUMBER,C_WORKORDER_ID NUMBER,C_INV_ITEM_ID NUMBER) IS
2118: SELECT A.scheduled_start_date
2119: FROM AHL_WORKORDER_OPERATIONS_V A ,AHL_SCHEDULE_MATERIALS B
2120: WHERE A.WORKORDER_OPERATION_ID=C_WORKORDER_OPERATION_ID
2121: AND A.WORKORDER_ID=C_WORKORDER_ID
2122: AND A.WORKORDER_OPERATION_ID=B.WORKORDER_OPERATION_ID
2123: AND B.INVENTORY_ITEM_ID=C_INV_ITEM_ID

Line 4644: ,AHL_WORKORDER_OPERATIONS_V B

4640: issued NUMBER;
4641: CURSOR CUR_GET_WOID_LEVEL_QTY IS
4642: SELECT SUM(nvl(QUANTITY,0))
4643: FROM AHL_WORKORDER_MTL_TXNS A
4644: ,AHL_WORKORDER_OPERATIONS_V B
4645: WHERE A.ORGANIZATION_ID = p_org_id
4646: AND A.INVENTORY_ITEM_ID = p_item_id
4647: AND NVL(A.lot_number,'X')=NVL(p_lotnum,NVL(A.lot_number,'X'))
4648: AND NVL(A.revision,'X')=NVL(p_rev,NVL(A.REVISION,'X'))

Line 4693: -- AHL_WORKORDER_OPERATIONS_V B

4689: CURSOR CUR_GET_WO_ISSUE_QTY
4690: IS
4691: SELECT SUM(nvl(QUANTITY,0))
4692: FROM AHL_WORKORDER_MTL_TXNS A ,
4693: -- AHL_WORKORDER_OPERATIONS_V B
4694: -- JKJAIN BUG # 7587902
4695: AHL_WORKORDER_OPERATIONS B
4696: WHERE A.ORGANIZATION_ID = p_org_id
4697: AND A.INVENTORY_ITEM_ID = p_item_id

Line 4708: -- AHL_WORKORDER_OPERATIONS_V B

4704: CURSOR CUR_GET_WO_RET_QTY
4705: IS
4706: SELECT SUM(nvl(QUANTITY,0))
4707: FROM AHL_WORKORDER_MTL_TXNS A ,
4708: -- AHL_WORKORDER_OPERATIONS_V B
4709: -- JKJAIN BUG # 7587902
4710: AHL_WORKORDER_OPERATIONS B
4711: WHERE A.ORGANIZATION_ID = p_org_id
4712: AND A.INVENTORY_ITEM_ID = p_item_id