VIEW: APPS.QPFV_PRICE_LISTS

Source

View Text - Preformatted

SELECT tl.NAME ,lh.ROUNDING_FACTOR ,lh.START_DATE_ACTIVE ,lh.END_DATE_ACTIVE ,lh.COMMENTS ,lh.ACTIVE_FLAG ,tl.DESCRIPTION ,lh.LIST_TYPE_CODE ,'_LA:lh.LIST_TYPE_CODE:QP_LOOKUPS:LIST_TYPE_CODE:MEANING' ,lh.CURRENCY_CODE ,cur.NAME ,lh.SOURCE_SYSTEM_CODE ,'_LA:lh.SOURCE_SYSTEM_CODE:QP_LOOKUPS:SOURCE_SYSTEM:MEANING' ,lh.SHIP_METHOD_CODE ,ship.MEANING ,lh.FREIGHT_TERMS_CODE ,freight.FREIGHT_TERMS ,lh.LIST_HEADER_ID ,lh.TERMS_ID ,ra.NAME ,lh.CREATION_DATE ,lh.CREATED_BY ,lh.LAST_UPDATE_DATE ,lh.LAST_UPDATED_BY , '_DF:QP:QP_LIST_HEADERS:lh' ,lh.ORIG_SYSTEM_HEADER_REF ,lh.CURRENCY_HEADER_ID ,ctl.NAME ,lh.PTE_CODE ,'_LA:lh.PTE_CODE:QP_LOOKUPS:QP_PTE_TYPE:MEANING' ,lh.LIST_SOURCE_CODE ,lh.ORIG_ORG_ID ,lh.GLOBAL_FLAG ,lh.SHAREABLE_FLAG ,lh.LOCKED_FROM_LIST_HEADER_ID ,tl2.NAME ,lh.SOLD_TO_ORG_ID ,party.PARTY_NAME ,cust_acct.ACCOUNT_NUMBER from qp_list_headers_b lh, qp_list_headers_tl tl, fnd_currencies_vl cur, oe_ship_methods_v ship, oe_frght_terms_active_v freight, ra_terms ra,qp_currency_lists_tl ctl,qp_list_headers_tl tl2,hz_cust_accounts cust_acct,hz_parties party WHERE lh.list_header_id = tl.list_header_id and tl.language = userenv('lang') and lh.list_type_code in ('PRL','AGR') and lh.currency_code = cur.currency_code and lh.ship_method_code = ship.lookup_code (+) and lh.freight_terms_code = freight.freight_terms_code (+) and lh.terms_id = ra.term_id (+) and lh.currency_header_id=ctl.currency_header_id(+) and (ctl.language is null or ctl.language=userenv('lang')) and lh.locked_from_list_header_id=tl2.list_header_id(+) and (tl2.language is null or tl2.language=userenv('lang')) and party.party_id(+)=cust_acct.party_id and cust_acct.cust_account_id(+)=lh.sold_to_org_id WITH READ ONLY

View Text - HTML Formatted

SELECT TL.NAME
, LH.ROUNDING_FACTOR
, LH.START_DATE_ACTIVE
, LH.END_DATE_ACTIVE
, LH.COMMENTS
, LH.ACTIVE_FLAG
, TL.DESCRIPTION
, LH.LIST_TYPE_CODE
, '_LA:LH.LIST_TYPE_CODE:QP_LOOKUPS:LIST_TYPE_CODE:MEANING'
, LH.CURRENCY_CODE
, CUR.NAME
, LH.SOURCE_SYSTEM_CODE
, '_LA:LH.SOURCE_SYSTEM_CODE:QP_LOOKUPS:SOURCE_SYSTEM:MEANING'
, LH.SHIP_METHOD_CODE
, SHIP.MEANING
, LH.FREIGHT_TERMS_CODE
, FREIGHT.FREIGHT_TERMS
, LH.LIST_HEADER_ID
, LH.TERMS_ID
, RA.NAME
, LH.CREATION_DATE
, LH.CREATED_BY
, LH.LAST_UPDATE_DATE
, LH.LAST_UPDATED_BY
, '_DF:QP:QP_LIST_HEADERS:LH'
, LH.ORIG_SYSTEM_HEADER_REF
, LH.CURRENCY_HEADER_ID
, CTL.NAME
, LH.PTE_CODE
, '_LA:LH.PTE_CODE:QP_LOOKUPS:QP_PTE_TYPE:MEANING'
, LH.LIST_SOURCE_CODE
, LH.ORIG_ORG_ID
, LH.GLOBAL_FLAG
, LH.SHAREABLE_FLAG
, LH.LOCKED_FROM_LIST_HEADER_ID
, TL2.NAME
, LH.SOLD_TO_ORG_ID
, PARTY.PARTY_NAME
, CUST_ACCT.ACCOUNT_NUMBER
FROM QP_LIST_HEADERS_B LH
, QP_LIST_HEADERS_TL TL
, FND_CURRENCIES_VL CUR
, OE_SHIP_METHODS_V SHIP
, OE_FRGHT_TERMS_ACTIVE_V FREIGHT
, RA_TERMS RA
, QP_CURRENCY_LISTS_TL CTL
, QP_LIST_HEADERS_TL TL2
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
WHERE LH.LIST_HEADER_ID = TL.LIST_HEADER_ID
AND TL.LANGUAGE = USERENV('LANG')
AND LH.LIST_TYPE_CODE IN ('PRL'
, 'AGR')
AND LH.CURRENCY_CODE = CUR.CURRENCY_CODE
AND LH.SHIP_METHOD_CODE = SHIP.LOOKUP_CODE (+)
AND LH.FREIGHT_TERMS_CODE = FREIGHT.FREIGHT_TERMS_CODE (+)
AND LH.TERMS_ID = RA.TERM_ID (+)
AND LH.CURRENCY_HEADER_ID=CTL.CURRENCY_HEADER_ID(+)
AND (CTL.LANGUAGE IS NULL OR CTL.LANGUAGE=USERENV('LANG'))
AND LH.LOCKED_FROM_LIST_HEADER_ID=TL2.LIST_HEADER_ID(+)
AND (TL2.LANGUAGE IS NULL OR TL2.LANGUAGE=USERENV('LANG'))
AND PARTY.PARTY_ID(+)=CUST_ACCT.PARTY_ID
AND CUST_ACCT.CUST_ACCOUNT_ID(+)=LH.SOLD_TO_ORG_ID WITH READ ONLY