APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_WORKORDER_MTL_TXNS

Line 5492: SELECT SUM(QUANTITY) FROM AHL_WORKORDER_MTL_TXNS

5488: function GET_ISSUED_QTY(P_ORG_ID IN NUMBER, P_ITEM_ID IN NUMBER, P_WORKORDER_OP_ID IN NUMBER) RETURN NUMBER
5489: IS
5490: issued NUMBER;
5491: CURSOR Q1(p_org_id NUMBER, p_itme_Id NUMBER,p_wo_op_id in NUMBER) IS
5492: SELECT SUM(QUANTITY) FROM AHL_WORKORDER_MTL_TXNS
5493: WHERE ORGANIZATION_ID = p_org_id
5494: AND INVENTORY_ITEM_ID = p_item_id
5495: AND WORKORDER_OPERATION_ID = p_wo_op_id
5496: AND TRANSACTION_TYPE_ID = 35;

Line 5529: FROM AHL_WORKORDER_MTL_TXNS

5525: -- cursor for getting total issued quantity
5526: CURSOR c_get_issue_qty(c_org_id NUMBER, c_itme_Id NUMBER,c_wo_op_id in NUMBER)
5527: IS
5528: SELECT SUM(QUANTITY)
5529: FROM AHL_WORKORDER_MTL_TXNS
5530: WHERE ORGANIZATION_ID = c_org_id
5531: AND INVENTORY_ITEM_ID = c_itme_Id
5532: AND WORKORDER_OPERATION_ID = c_wo_op_id
5533: AND TRANSACTION_TYPE_ID = 35; -- Mtl Issue Txn

Line 5538: FROM AHL_WORKORDER_MTL_TXNS

5534: -- cursor for getting total returned quantity
5535: CURSOR c_get_rtn_qty(c_org_id NUMBER, c_itme_Id NUMBER,c_wo_op_id in NUMBER)
5536: IS
5537: SELECT SUM(QUANTITY)
5538: FROM AHL_WORKORDER_MTL_TXNS
5539: WHERE ORGANIZATION_ID = c_org_id
5540: AND INVENTORY_ITEM_ID = c_itme_Id
5541: AND WORKORDER_OPERATION_ID = c_wo_op_id
5542: AND TRANSACTION_TYPE_ID = 43; -- Mtl Rtn Txn