APPS.AHL_PP_MATERIALS_PVT dependencies on AHL_WORKORDER_MTL_TXNS

Line 3929: SELECT SUM(QUANTITY) FROM AHL_WORKORDER_MTL_TXNS

3925: function GET_ISSUED_QTY(P_ORG_ID IN NUMBER, P_ITEM_ID IN NUMBER, P_WORKORDER_OP_ID IN NUMBER) RETURN NUMBER
3926: IS
3927: issued NUMBER;
3928: CURSOR Q1(p_org_id NUMBER, p_itme_Id NUMBER,p_wo_op_id in NUMBER) IS
3929: SELECT SUM(QUANTITY) FROM AHL_WORKORDER_MTL_TXNS
3930: WHERE ORGANIZATION_ID = p_org_id
3931: AND INVENTORY_ITEM_ID = p_item_id
3932: AND WORKORDER_OPERATION_ID = p_wo_op_id
3933: AND TRANSACTION_TYPE_ID = 35;

Line 3973: FROM AHL_WORKORDER_MTL_TXNS

3969: -- cursor for getting total issued quantity
3970: CURSOR c_get_issue_qty(c_org_id NUMBER, c_itme_Id NUMBER,c_wo_op_id in NUMBER)
3971: IS
3972: SELECT SUM(QUANTITY)
3973: FROM AHL_WORKORDER_MTL_TXNS
3974: WHERE ORGANIZATION_ID = c_org_id
3975: AND INVENTORY_ITEM_ID = c_itme_Id
3976: AND WORKORDER_OPERATION_ID = c_wo_op_id
3977: AND TRANSACTION_TYPE_ID = 35; -- Mtl Issue Txn

Line 3983: FROM AHL_WORKORDER_MTL_TXNS

3979: -- cursor for getting total returned quantity
3980: CURSOR c_get_rtn_qty(c_org_id NUMBER, c_itme_Id NUMBER,c_wo_op_id in NUMBER)
3981: IS
3982: SELECT SUM(QUANTITY)
3983: FROM AHL_WORKORDER_MTL_TXNS
3984: WHERE ORGANIZATION_ID = c_org_id
3985: AND INVENTORY_ITEM_ID = c_itme_Id
3986: AND WORKORDER_OPERATION_ID = c_wo_op_id
3987: AND TRANSACTION_TYPE_ID = 43; -- Mtl Rtn Txn