AP Unclaimed Property Report- Not Supported: Reserved For Future Use
Description
Categories: BI Publisher
Imported from BI Publisher
Description: Unclaimed Property Report
Application: Payables
Source: Unclaimed Property Report (XML) - Not Supported: Reserved For Future Use
Short Name: APXUCPRP_XML
DB package: AP_APXUCPRP_XMLP_PKG
Description: Unclaimed Property Report
Application: Payables
Source: Unclaimed Property Report (XML) - Not Supported: Reserved For Future Use
Short Name: APXUCPRP_XML
DB package: AP_APXUCPRP_XMLP_PKG
Run
AP Unclaimed Property Report- Not Supported: Reserved For Future Use and other Oracle EBS reports with Blitz Report™ on our demo environment
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 | |
---|---|---|---|
Reporting Level |
|
LOV Oracle | |
Reporting Context |
|
LOV Oracle | |
Bank Account |
|
LOV Oracle | |
Payment Method |
|
LOV Oracle | |
Supplier Type |
|
LOV Oracle | |
State |
|
LOV Oracle | |
From Payment Date |
|
Date | |
To Payment Date |
|
Date |