FLA_XLA_PAYMENTS_REF

Details

Schema: FUSION
Object owner: FUN
Object type: VIEW

Columns

Name
LINES_PAYMENT_NUMBER PAYMENT_LEASE_DETAIL_ID PAYMENT_HEADER_ID ASSET_NUMBER OPTION_FLAG PO_HEADER_ID PO_NUMBER PAYMENT_PURPOSE_CODE PAYMENT_TERM_ID PAYMENT_TYPE_CODE OPTION_TYPE_CODE ROU_ASSET_FLAG LIABILITY_FLAG ARREARS_FLAG PAYMENT_FREQUENCY_CODE SUPPLIER_ID SUPPLIER_NAME SUPPLIER_SITE_NAME SUPPLIER_SITE_ID PARTY_TYPE_CODE PAYMENT_ATTRIBUTE_CATEGORY PAYMENT_ATTRIBUTE_CHAR1 PAYMENT_ATTRIBUTE_CHAR10 PAYMENT_ATTRIBUTE_CHAR11 PAYMENT_ATTRIBUTE_CHAR12 PAYMENT_ATTRIBUTE_CHAR13 PAYMENT_ATTRIBUTE_CHAR14 PAYMENT_ATTRIBUTE_CHAR15 PAYMENT_ATTRIBUTE_CHAR2 PAYMENT_ATTRIBUTE_CHAR3 PAYMENT_ATTRIBUTE_CHAR4 PAYMENT_ATTRIBUTE_CHAR5 PAYMENT_ATTRIBUTE_CHAR6 PAYMENT_ATTRIBUTE_CHAR7 PAYMENT_ATTRIBUTE_CHAR8 PAYMENT_ATTRIBUTE_CHAR9 PAYMENT_ATTRIBUTE_NUMBER1 PAYMENT_ATTRIBUTE_NUMBER2 PAYMENT_ATTRIBUTE_NUMBER3 PAYMENT_ATTRIBUTE_NUMBER4 PAYMENT_ATTRIBUTE_NUMBER5 PAYMENT_ATTRIBUTE_DATE1 PAYMENT_ATTRIBUTE_DATE2 PAYMENT_ATTRIBUTE_DATE3 PAYMENT_ATTRIBUTE_DATE4 PAYMENT_ATTRIBUTE_DATE5 REVENUE_METHOD_CODE CUSTOMER_ID CUSTOMER_ACCT_NUMBER CUSTOMER_NAME BILL_TO_SITE_ID BILL_TO_SITE_NAME SHIP_TO_SITE_ID SHIP_TO_SITE_NAME AMORTIZE_EXEMPT_PAYMENT_FLAG GENERATE_PAYABLES_INVOICE_FLAG

Name

LINES_PAYMENT_NUMBER

PAYMENT_LEASE_DETAIL_ID

PAYMENT_HEADER_ID

ASSET_NUMBER

OPTION_FLAG

PO_HEADER_ID

PO_NUMBER

PAYMENT_PURPOSE_CODE

PAYMENT_TERM_ID

PAYMENT_TYPE_CODE

OPTION_TYPE_CODE

ROU_ASSET_FLAG

LIABILITY_FLAG

ARREARS_FLAG

PAYMENT_FREQUENCY_CODE

SUPPLIER_ID

SUPPLIER_NAME

SUPPLIER_SITE_NAME

SUPPLIER_SITE_ID

PARTY_TYPE_CODE

PAYMENT_ATTRIBUTE_CATEGORY

PAYMENT_ATTRIBUTE_CHAR1

PAYMENT_ATTRIBUTE_CHAR10

PAYMENT_ATTRIBUTE_CHAR11

PAYMENT_ATTRIBUTE_CHAR12

PAYMENT_ATTRIBUTE_CHAR13

PAYMENT_ATTRIBUTE_CHAR14

PAYMENT_ATTRIBUTE_CHAR15

PAYMENT_ATTRIBUTE_CHAR2

PAYMENT_ATTRIBUTE_CHAR3

PAYMENT_ATTRIBUTE_CHAR4

PAYMENT_ATTRIBUTE_CHAR5

PAYMENT_ATTRIBUTE_CHAR6

PAYMENT_ATTRIBUTE_CHAR7

PAYMENT_ATTRIBUTE_CHAR8

PAYMENT_ATTRIBUTE_CHAR9

PAYMENT_ATTRIBUTE_NUMBER1

PAYMENT_ATTRIBUTE_NUMBER2

PAYMENT_ATTRIBUTE_NUMBER3

PAYMENT_ATTRIBUTE_NUMBER4

PAYMENT_ATTRIBUTE_NUMBER5

PAYMENT_ATTRIBUTE_DATE1

PAYMENT_ATTRIBUTE_DATE2

PAYMENT_ATTRIBUTE_DATE3

PAYMENT_ATTRIBUTE_DATE4

PAYMENT_ATTRIBUTE_DATE5

REVENUE_METHOD_CODE

CUSTOMER_ID

CUSTOMER_ACCT_NUMBER

CUSTOMER_NAME

BILL_TO_SITE_ID

BILL_TO_SITE_NAME

SHIP_TO_SITE_ID

SHIP_TO_SITE_NAME

AMORTIZE_EXEMPT_PAYMENT_FLAG

GENERATE_PAYABLES_INVOICE_FLAG

Query

SQL_Statement
SELECT flaph.payment_number lines_payment_number, flaph.lease_detail_id payment_lease_detail_id, flaph.payment_header_id payment_header_id, flaph.asset_number asset_number, flaph.option_flag option_flag, flaph.po_header_id po_header_id, poh.segment1 po_number, flaph.payment_purpose_code payment_purpose_code, flaph.payment_term_id payment_term_id, flaph.payment_type_code payment_type_code, flaph.option_type_code option_type_code, flaph.rou_asset_flag rou_asset_flag, flaph.liability_flag liability_flag, flaph.arrears_flag arrears_flag, flaph.payment_frequency_code payment_frequency_code, flaph.vendor_id supplier_id, pos.vendor_name supplier_name, poss.vendor_site_code supplier_site_name, flaph.vendor_site_id supplier_site_id, decode(flaph.vendor_id,NULL,'C','S') party_type_code, flaph.attribute_category payment_attribute_category, flaph.attribute_char1 payment_attribute_char1, flaph.attribute_char10 payment_attribute_char10, flaph.attribute_char11 payment_attribute_char11, flaph.attribute_char12 payment_attribute_char12, flaph.attribute_char13 payment_attribute_char13, flaph.attribute_char14 payment_attribute_char14, flaph.attribute_char15 payment_attribute_char15, flaph.attribute_char2 payment_attribute_char2, flaph.attribute_char3 payment_attribute_char3, flaph.attribute_char4 payment_attribute_char4, flaph.attribute_char5 payment_attribute_char5, flaph.attribute_char6 payment_attribute_char6, flaph.attribute_char7 payment_attribute_char7, flaph.attribute_char8 payment_attribute_char8, flaph.attribute_char9 payment_attribute_char9, flaph.attribute_number1 payment_attribute_number1, flaph.attribute_number2 payment_attribute_number2, flaph.attribute_number3 payment_attribute_number3, flaph.attribute_number4 payment_attribute_number4, flaph.attribute_number5 payment_attribute_number5, flaph.attribute_date1 payment_attribute_date1, flaph.attribute_date2 payment_attribute_date2, flaph.attribute_date3 payment_attribute_date3, flaph.attribute_date4 payment_attribute_date4, flaph.attribute_date5 payment_attribute_date5, flaph.revenue_method_code revenue_method_code, flaph.bill_to_customer_id customer_id, hca.account_number customer_acct_number, hp.party_name customer_name, flaph.bill_to_site_use_id bill_to_site_id, hpsbillto.party_site_number bill_to_site_name, flaph.ship_to_site_use_id ship_to_site_id, NVL2(hcsuashipto.site_use_id, hpsshipto.party_site_number, NULL) ship_to_site_name, flaph.amortize_exempt_payment_flag amortize_exempt_payment_flag, flaph.generate_invoice_flag generate_payables_invoice_flag FROM fla_lease_payment_headers flaph, po_headers_all poh, poz_suppliers_v pos, poz_supplier_sites_v poss, hz_cust_accounts hca, hz_parties hp, hz_cust_acct_sites_all hcasabillto, hz_cust_site_uses_all hcsuabillto, hz_party_sites hpsbillto, hz_cust_acct_sites_all hcasashipto, hz_cust_site_uses_all hcsuashipto, hz_party_sites hpsshipto, hz_locations shiptositeloc WHERE flaph.vendor_id = pos.vendor_id(+) AND flaph.vendor_site_id = poss.vendor_site_id(+) AND flaph.po_header_id = poh.po_header_id (+) AND flaph.bill_to_customer_id = hca.cust_account_id(+) AND hca.party_id = hp.party_id(+) AND hca.status(+) = 'A' AND flaph.bill_to_site_use_id = hcsuabillto.site_use_id (+) AND hca.cust_account_id = hcasabillto.cust_account_id (+) AND hcasabillto.cust_acct_site_id(+) = hcsuabillto.cust_acct_site_id AND hcsuabillto.status (+) = 'A' AND hcasabillto.party_site_id = hpsbillto.party_site_id (+) AND hcsuabillto.site_use_code(+) = 'BILL_TO' AND flaph.ship_to_site_use_id = hcsuashipto.site_use_id (+) AND hca.cust_account_id = hcasashipto.cust_account_id (+) AND hcasashipto.cust_acct_site_id(+) = hcsuashipto.cust_acct_site_id AND hcsuashipto.status (+) = 'A' AND hcasashipto.party_site_id = hpsshipto.party_site_id (+) AND hcsuashipto.site_use_code(+) = 'SHIP_TO' AND hpsshipto.location_id = shiptositeloc.location_id (+)

SQL_Statement

SELECT

flaph.payment_number lines_payment_number,

flaph.lease_detail_id payment_lease_detail_id,

flaph.payment_header_id payment_header_id,

flaph.asset_number asset_number,

flaph.option_flag option_flag,

flaph.po_header_id po_header_id,

poh.segment1 po_number,

flaph.payment_purpose_code payment_purpose_code,

flaph.payment_term_id payment_term_id,

flaph.payment_type_code payment_type_code,

flaph.option_type_code option_type_code,

flaph.rou_asset_flag rou_asset_flag,

flaph.liability_flag liability_flag,

flaph.arrears_flag arrears_flag,

flaph.payment_frequency_code payment_frequency_code,

flaph.vendor_id supplier_id,

pos.vendor_name supplier_name,

poss.vendor_site_code supplier_site_name,

flaph.vendor_site_id supplier_site_id,

decode(flaph.vendor_id,NULL,'C','S') party_type_code,

flaph.attribute_category payment_attribute_category,

flaph.attribute_char1 payment_attribute_char1,

flaph.attribute_char10 payment_attribute_char10,

flaph.attribute_char11 payment_attribute_char11,

flaph.attribute_char12 payment_attribute_char12,

flaph.attribute_char13 payment_attribute_char13,

flaph.attribute_char14 payment_attribute_char14,

flaph.attribute_char15 payment_attribute_char15,

flaph.attribute_char2 payment_attribute_char2,

flaph.attribute_char3 payment_attribute_char3,

flaph.attribute_char4 payment_attribute_char4,

flaph.attribute_char5 payment_attribute_char5,

flaph.attribute_char6 payment_attribute_char6,

flaph.attribute_char7 payment_attribute_char7,

flaph.attribute_char8 payment_attribute_char8,

flaph.attribute_char9 payment_attribute_char9,

flaph.attribute_number1 payment_attribute_number1,

flaph.attribute_number2 payment_attribute_number2,

flaph.attribute_number3 payment_attribute_number3,

flaph.attribute_number4 payment_attribute_number4,

flaph.attribute_number5 payment_attribute_number5,

flaph.attribute_date1 payment_attribute_date1,

flaph.attribute_date2 payment_attribute_date2,

flaph.attribute_date3 payment_attribute_date3,

flaph.attribute_date4 payment_attribute_date4,

flaph.attribute_date5 payment_attribute_date5,

flaph.revenue_method_code revenue_method_code,

flaph.bill_to_customer_id customer_id,

hca.account_number customer_acct_number,

hp.party_name customer_name,

flaph.bill_to_site_use_id bill_to_site_id,

hpsbillto.party_site_number bill_to_site_name,

flaph.ship_to_site_use_id ship_to_site_id,

NVL2(hcsuashipto.site_use_id, hpsshipto.party_site_number, NULL) ship_to_site_name,

flaph.amortize_exempt_payment_flag amortize_exempt_payment_flag,

flaph.generate_invoice_flag generate_payables_invoice_flag

FROM

fla_lease_payment_headers flaph,

po_headers_all poh,

poz_suppliers_v pos,

poz_supplier_sites_v poss,

hz_cust_accounts hca,

hz_parties hp,

hz_cust_acct_sites_all hcasabillto,

hz_cust_site_uses_all hcsuabillto,

hz_party_sites hpsbillto,

hz_cust_acct_sites_all hcasashipto,

hz_cust_site_uses_all hcsuashipto,

hz_party_sites hpsshipto,

hz_locations shiptositeloc

WHERE

flaph.vendor_id = pos.vendor_id(+)

AND flaph.vendor_site_id = poss.vendor_site_id(+)

AND flaph.po_header_id = poh.po_header_id (+)

AND flaph.bill_to_customer_id = hca.cust_account_id(+)

AND hca.party_id = hp.party_id(+)

AND hca.status(+) = 'A'

AND flaph.bill_to_site_use_id = hcsuabillto.site_use_id (+)

AND hca.cust_account_id = hcasabillto.cust_account_id (+)

AND hcasabillto.cust_acct_site_id(+) = hcsuabillto.cust_acct_site_id

AND hcsuabillto.status (+) = 'A'

AND hcasabillto.party_site_id = hpsbillto.party_site_id (+)

AND hcsuabillto.site_use_code(+) = 'BILL_TO'

AND flaph.ship_to_site_use_id = hcsuashipto.site_use_id (+)

AND hca.cust_account_id = hcasashipto.cust_account_id (+)

AND hcasashipto.cust_acct_site_id(+) = hcsuashipto.cust_acct_site_id

AND hcsuashipto.status (+) = 'A'

AND hcasashipto.party_site_id = hpsshipto.party_site_id (+)

AND hcsuashipto.site_use_code(+) = 'SHIP_TO'

AND hpsshipto.location_id = shiptositeloc.location_id (+)