AP Unclaimed Property - draft

Description
Categories: BI Publisher, Financials, Procurement
Application: Payables
Source: Unclaimed Property Report (XML) - Not Supported: Reserved For Future Use
Short Name: APXUCPRP_XML
DB package: AP_APXUCPRP_XMLP_PKG
SELECT
AC.bank_account_name C_BANK_ACCOUNT_NAME,
ALC.displayed_field C_PMT_METHOD,
AC.currency_code C_PMT_CURRENCY,
AC.state C_STATE,
AC.check_date C_PMT_DATE,
AC.check_number C_CHECK_NUMBER,
AC.amount C_PMT_AMOUNT,
ALC1.displayed_field C_VNDR_TYPE,
AC.vendor_name C_VNDR_NAME,
AP_VENDOR_SITES_PKG.FORMAT_ADDRESS(AC.country,AC.address_line1,
					AC.address_line2,
					AC.address_line3,
					AC.address_line4,
					AC.city,
					AC.county,
					AC.state,
					AC.province,
					AC.zip,
					NULL) C_PMT_ADDRESS,
asp1.base_currency_code BASE_CURRENCY,
FC.PRECISION PRECISION,
&C_SELECT_LE  C_Legal_Entity,
&C_SELECT_OU C_Operating_Unit
FROM
ap_checks_all AC,
po_vendors POV,
ap_lookup_codes ALC,
po_lookup_codes ALC1,
ap_system_parameters_all ASP1,
fnd_currencies FC,
&C_ORG_FROM_TABLES
WHERE
AC.vendor_id = POV.vendor_id AND
nvl(AC.org_id,-99) = nvl(asp1.org_id,-99) AND
ALC.lookup_code = AC.payment_method_lookup_code AND
ALC.lookup_type = 'PAYMENT METHOD' AND
ALC1.lookup_code = POV.vendor_type_lookup_code AND
ALC1.lookup_type = 'VENDOR TYPE' AND
(((:P_BANK_ACCOUNT_ID is not NULL) AND (AC.bank_account_id = :P_BANK_ACCOUNT_ID)) OR (:P_BANK_ACCOUNT_ID is NULL)) AND
(((:P_PMT_METHOD is not NULL) AND (AC.payment_method_lookup_code = :P_PMT_METHOD)) OR (:P_PMT_METHOD is NULL)) AND
(((:P_VNDR_TYPE is not NULL) AND (POV.vendor_type_lookup_code = :P_VNDR_TYPE)) OR (:P_VNDR_TYPE is NULL)) AND
(((:P_STATE is not NULL) AND (AC.state = :P_STATE)) OR (:P_STATE is NULL)) AND
(((:p_from_check_date is not null) AND (:p_to_check_date is not null) AND (AC.check_date BETWEEN :p_From_Check_Date AND :p_To_Check_Date)) OR ((:p_from_check_date is null) and (:p_to_check_date is not null) and (AC.check_date <= :p_to_check_date))) AND
AC.status_lookup_code IN ('ISSUED', 'NEGOTIABLE', 'STOP INITIATED') AND
FC.currency_code = asp1.base_currency_code
&C_MULTI_ORG_WHERE
&P_ORG_WHERE_AC
&P_ORG_WHERE_ASP
ORDER BY C_OPERATING_UNIT, C_BANK_ACCOUNT_NAME, C_PMT_METHOD, C_PMT_CURRENCY, C_STATE, C_VNDR_NAME, C_PMT_DATE
Parameter Name SQL text Validation
Ledger Id
 
Number
To Payment Date
 
Date
From Payment Date
 
Date
State
 
LOV Oracle
Supplier Type
 
LOV Oracle
Payment Method
 
LOV Oracle
Bank Account
 
LOV Oracle
Reporting Context
 
LOV Oracle
Reporting Level
 
LOV Oracle