select (AVAILABLE/:AMT_UNIT2) Qry_Available_Amount ,
COMPANY Qry_Company ,
COUNTRY Qry_Country ,
CURRENCY Qry_Currency ,
EFFECTIVE_DATE Qry_Effective_Date ,
(LIMIT_AMT/:AMT_UNIT2) Qry_Limit_Amount,
LIMIT_CODE Qry_Limit_Code ,
LIMIT_GROUP Qry_Limit_Group ,
LIMIT_PARTY Qry_Limit_Party ,
LIMIT_TYPE Qry_Limit_Type ,
(UTILISED/:AMT_UNIT2) Qry_Utilized_Amount,
XTR_XTRLIUTL_XMLP_PKG.fc_get_limit_type_descformula(LIMIT_TYPE) Fc_Get_Limit_Type_Desc
from XTR_LIMIT_OVERVIEW_V
where LIMIT_GROUP like upper(nvl(:LIMIT_TYPE2, LIMIT_GROUP))
and AVAILABLE >= nvl(:P_AVAILABLE_LOW, -9999999999999999999)
and AVAILABLE <= nvl(:P_AVAILABLE_HIGH, 9999999999999999999)
and LIMIT_CODE like upper(nvl(:P_LIMIT_CODE,LIMIT_CODE))
and EFFECTIVE_DATE between nvl(:P_EFFECTIVE_DATE_FROM_1,EFFECTIVE_DATE) and nvl(:P_EFFECTIVE_DATE_TO_1,EFFECTIVE_DATE)
and company in (select party_code from xtr_parties_v where party_code = nvl(:p_company_code,party_code) )
ORDER BY 2 ASC,4 ASC,10 ASC,7 ASC , LIMIT_TYPE , EFFECTIVE_DATE , LIMIT_PARTY |
