VIEW: APPS.PO_CXML_PCARD_V

Source

View Text - Preformatted

SELECT aca.card_number , aca.cardmember_name , aca.card_expiration_date , acpa.card_brand_lookup_code , pha.type_lookup_code po_type_lookup_code , pha.po_header_id , to_number ( null ) po_release_id , pv.vendor_name , nvl ( aca.cardmember_name , pv.vendor_name ) card_name from ap_cards_all aca , ap_card_programs_all acpa , ap_card_suppliers_all acsa , po_vendors pv , po_headers_all pha WHERE pha.type_lookup_code = 'STANDARD' and pha.pcard_id = aca.card_id and aca.card_program_id = acpa.card_program_id and acsa.card_id ( + ) = pha.pcard_id and pv.vendor_id ( + ) = acsa.vendor_id union select aca.card_number , aca.cardmember_name , aca.card_expiration_date , acpa.card_brand_lookup_code , pha.type_lookup_code po_type_lookup_code , pra.po_header_id , pra.po_release_id , pv.vendor_name , nvl ( aca.cardmember_name , pv.vendor_name ) card_name from ap_cards_all aca , ap_card_programs_all acpa , ap_card_suppliers_all acsa , po_vendors pv , po_headers_all pha , po_releases_all pra where pha.type_lookup_code <> 'STANDARD' and pha.po_header_id = pra.po_header_id and pra.pcard_id = aca.card_id and aca.card_program_id = acpa.card_program_id and acsa.card_id ( + ) = pra.pcard_id and pv.vendor_id ( + ) = acsa.vendor_id

View Text - HTML Formatted

SELECT ACA.CARD_NUMBER
, ACA.CARDMEMBER_NAME
, ACA.CARD_EXPIRATION_DATE
, ACPA.CARD_BRAND_LOOKUP_CODE
, PHA.TYPE_LOOKUP_CODE PO_TYPE_LOOKUP_CODE
, PHA.PO_HEADER_ID
, TO_NUMBER ( NULL ) PO_RELEASE_ID
, PV.VENDOR_NAME
, NVL ( ACA.CARDMEMBER_NAME
, PV.VENDOR_NAME ) CARD_NAME
FROM AP_CARDS_ALL ACA
, AP_CARD_PROGRAMS_ALL ACPA
, AP_CARD_SUPPLIERS_ALL ACSA
, PO_VENDORS PV
, PO_HEADERS_ALL PHA
WHERE PHA.TYPE_LOOKUP_CODE = 'STANDARD'
AND PHA.PCARD_ID = ACA.CARD_ID
AND ACA.CARD_PROGRAM_ID = ACPA.CARD_PROGRAM_ID
AND ACSA.CARD_ID ( + ) = PHA.PCARD_ID
AND PV.VENDOR_ID ( + ) = ACSA.VENDOR_ID UNION SELECT ACA.CARD_NUMBER
, ACA.CARDMEMBER_NAME
, ACA.CARD_EXPIRATION_DATE
, ACPA.CARD_BRAND_LOOKUP_CODE
, PHA.TYPE_LOOKUP_CODE PO_TYPE_LOOKUP_CODE
, PRA.PO_HEADER_ID
, PRA.PO_RELEASE_ID
, PV.VENDOR_NAME
, NVL ( ACA.CARDMEMBER_NAME
, PV.VENDOR_NAME ) CARD_NAME
FROM AP_CARDS_ALL ACA
, AP_CARD_PROGRAMS_ALL ACPA
, AP_CARD_SUPPLIERS_ALL ACSA
, PO_VENDORS PV
, PO_HEADERS_ALL PHA
, PO_RELEASES_ALL PRA
WHERE PHA.TYPE_LOOKUP_CODE <> 'STANDARD'
AND PHA.PO_HEADER_ID = PRA.PO_HEADER_ID
AND PRA.PCARD_ID = ACA.CARD_ID
AND ACA.CARD_PROGRAM_ID = ACPA.CARD_PROGRAM_ID
AND ACSA.CARD_ID ( + ) = PRA.PCARD_ID
AND PV.VENDOR_ID ( + ) = ACSA.VENDOR_ID