View: PO_HEADERS_ARCHIVE_XML

Product:	PO - Purchasing
Description:
Implementation/DBA Data:	APPS.PO_HEADERS_ARCHIVE_XML

View Text

SELECT PHA.TYPE_LOOKUP_CODE
, PHA.SEGMENT1
, PHA.REVISION_NUM
, PHA.PRINT_COUNT
, TO_CHAR(PHA.CREATION_DATE
, 'DD-MON-YYYY HH24:MI:SS') CREATION_DATE
, TO_CHAR(PHA.PRINTED_DATE
, 'DD-MON-YYYY HH24:MI:SS') PRINTED_DATE
, TO_CHAR(PHA.REVISED_DATE
, 'DD-MON-YYYY HH24:MI:SS') REVISED_DATE
, TO_CHAR(PHA.START_DATE
, 'DD-MON-YYYY HH24:MI:SS') START_DATE
, TO_CHAR(PHA.END_DATE
, 'DD-MON-YYYY HH24:MI:SS') END_DATE
, PHA.NOTE_TO_VENDOR
, HRE.FIRST_NAME DOCUMENT_BUYER_FIRST_NAME
, HRE.LAST_NAME DOCUMENT_BUYER_LAST_NAME
, HRE.TITLE DOCUMENT_BUYER_TITLE
, PHA.AGENT_ID DOCUMENT_BUYER_AGENT_ID
, DECODE(NVL(PHA.REVISION_NUM
, 0)
, 0
, NULL
, PO_COMMUNICATION_PVT.GETARCBUYERAGENTID(PHA.PO_HEADER_ID)) ARCHIVE_BUYER_AGENT_ID
, DECODE(NVL(PHA.REVISION_NUM
, 0)
, 0
, NULL
, PO_COMMUNICATION_PVT.GETARCBUYERFNAME()) ARCHIVE_BUYER_FIRST_NAME
, DECODE(NVL(PHA.REVISION_NUM
, 0)
, 0
, NULL
, PO_COMMUNICATION_PVT.GETARCBUYERLNAME()) ARCHIVE_BUYER_LAST_NAME
, DECODE(NVL(PHA.REVISION_NUM
, 0)
, 0
, NULL
, PO_COMMUNICATION_PVT.GETARCBUYERTITLE()) ARCHIVE_BUYER_TITLE
, TO_CHAR(PHA.BLANKET_TOTAL_AMOUNT
, PO_COMMUNICATION_PVT.GETFORMATMASK) AMOUNT_AGREED
, PHA.CANCEL_FLAG
, PHA.CONFIRMING_ORDER_FLAG
, NVL(PHA.ACCEPTANCE_REQUIRED_FLAG
, 'N')
, TO_CHAR(PHA.ACCEPTANCE_DUE_DATE
, 'DD-MON-YYYY HH24:MI:SS') ACCEPTANCE_DUE_DATE
, FCC.CURRENCY_CODE
, FCC.NAME CURRENCY_NAME
, TO_CHAR(PHA.RATE
, PO_COMMUNICATION_PVT.GETFORMATMASK) RATE
, NVL(OFC.FREIGHT_CODE_TL
, PHA.SHIP_VIA_LOOKUP_CODE) SHIP_VIA
, PLC1.MEANING FOB
, PLC2.MEANING FREIGHT_TERMS
, T.NAME PAYMENT_TERMS
, NVL(PVS.CUSTOMER_NUM
, VN.CUSTOMER_NUM) CUSTOMER_NUM
, VN.SEGMENT1 VENDOR_NUM
, VN.VENDOR_NAME
, PVS.ADDRESS_LINE1 VENDOR_ADDRESS_LINE1
, PVS.ADDRESS_LINE2 VENDOR_ADDRESS_LINE2
, PVS.ADDRESS_LINE3 VENDOR_ADDRESS_LINE3
, PVS.CITY VENDOR_CITY
, DECODE(PVS.STATE
, NULL
, DECODE(PVS.PROVINCE
, NULL
, PVS.COUNTY
, PVS.PROVINCE)
, PVS.STATE) VENDOR_STATE
, PVS.ZIP VENDOR_POSTAL_CODE
, FTE3.TERRITORY_SHORT_NAME VENDOR_COUNTRY
, PVS.PHONE VENDOR_PHONE
, PVC.FIRST_NAME VENDOR_CONTACT_FIRST_NAME
, PVC.LAST_NAME VENDOR_CONTACT_LAST_NAME
, PVC.TITLE VENDOR_CONTACT_TITLE
, PVC.PHONE VENDOR_CONTACT_PHONE
, DECODE(NVL(PHA.SHIP_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETLOCATIONINFO(PHA.SHIP_TO_LOCATION_ID)) SHIP_TO_LOCATION_ID
, DECODE(NVL(PHA.SHIP_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETLOCATIONNAME()) SHIP_TO_LOCATION_NAME
, DECODE(NVL(PHA.SHIP_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETADDRESSLINE1()) SHIP_TO_ADDRESS_LINE1
, DECODE(NVL(PHA.SHIP_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETADDRESSLINE2()) SHIP_TO_ADDRESS_LINE2
, DECODE(NVL(PHA.SHIP_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETADDRESSLINE3()) SHIP_TO_ADDRESS_LINE3
, DECODE(NVL(PHA.SHIP_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETADDRESSLINE4()) SHIP_TO_ADDRESS_LINE4
, DECODE(NVL(PHA.SHIP_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETADDRESSINFO()) SHIP_TO_ADDRESS_INFO
, DECODE(NVL(PHA.SHIP_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETTERRITORYSHORTNAME() )SHIP_TO_COUNTRY
, DECODE(NVL(PHA.BILL_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETLOCATIONINFO(PHA.BILL_TO_LOCATION_ID)) BILL_TO_LOCATION_ID
, DECODE(NVL(PHA.SHIP_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETLOCATIONNAME()) BILL_TO_LOCATION_NAME
, DECODE(NVL(PHA.BILL_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETADDRESSLINE1() ) BILL_TO_ADDRESS_LINE1
, DECODE(NVL(PHA.BILL_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETADDRESSLINE2() ) BILL_TO_ADDRESS_LINE2
, DECODE(NVL(PHA.BILL_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETADDRESSLINE3() ) BILL_TO_ADDRESS_LINE3
, DECODE(NVL(PHA.BILL_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETADDRESSLINE4() ) BILL_TO_ADDRESS_LINE4
, DECODE(NVL(PHA.BILL_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETADDRESSINFO()) BILL_TO_ADDRESS_INFO
, DECODE(NVL(PHA.BILL_TO_LOCATION_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETTERRITORYSHORTNAME()) BILL_TO_COUNTRY
, PHA.ATTRIBUTE1
, PHA.ATTRIBUTE2
, PHA.ATTRIBUTE3
, PHA.ATTRIBUTE4
, PHA.ATTRIBUTE5
, PHA.ATTRIBUTE6
, PHA.ATTRIBUTE7
, PHA.ATTRIBUTE8
, PHA.ATTRIBUTE9
, PHA.ATTRIBUTE10
, PHA.ATTRIBUTE11
, PHA.ATTRIBUTE12
, PHA.ATTRIBUTE13
, PHA.ATTRIBUTE14
, PHA.ATTRIBUTE15
, PHA.VENDOR_SITE_ID
, PHA.PO_HEADER_ID
, DECODE(PHA.APPROVED_FLAG
, 'Y'
, 'Y'
, 'N') APPROVED_FLAG
, PVS.LANGUAGE
, PHA.VENDOR_ID
, PHA.CLOSED_CODE
, PHA.USSGL_TRANSACTION_CODE
, PHA.GOVERNMENT_CONTEXT
, PHA.REQUEST_ID
, PHA.PROGRAM_APPLICATION_ID
, PHA.PROGRAM_ID
, TO_CHAR(PHA.PROGRAM_UPDATE_DATE
, 'DD-MON-YYYY HH24:MI:SS') PROGRAM_UPDATE_DATE
, PHA.ORG_ID
, PHA.COMMENTS
, TO_CHAR(PHA.REPLY_DATE
, 'DD-MON-YYYY HH24:MI:SS') REPLY_DATE
, PHA.REPLY_METHOD_LOOKUP_CODE
, TO_CHAR(PHA.RFQ_CLOSE_DATE
, 'DD-MON-YYYY HH24:MI:SS') RFQ_CLOSE_DATE
, PHA.QUOTE_TYPE_LOOKUP_CODE
, PHA.QUOTATION_CLASS_CODE
, PHA.QUOTE_WARNING_DELAY_UNIT
, PHA.QUOTE_WARNING_DELAY
, PHA.QUOTE_VENDOR_QUOTE_NUMBER
, TO_CHAR(PHA.CLOSED_DATE
, 'DD-MON-YYYY HH24:MI:SS') CLOSED_DATE
, PHA.USER_HOLD_FLAG
, PHA.APPROVAL_REQUIRED_FLAG
, PHA.FIRM_STATUS_LOOKUP_CODE
, TO_CHAR(PHA.FIRM_DATE
, 'DD-MON-YYYY HH24:MI:SS') FIRM_DATE
, PHA.FROZEN_FLAG
, PHA.EDI_PROCESSED_FLAG
, PHA.EDI_PROCESSED_STATUS
, PHA.ATTRIBUTE_CATEGORY
, PHA.CREATED_BY
, PHA.VENDOR_CONTACT_ID
, PHA.TERMS_ID
, PHA.FOB_LOOKUP_CODE
, PHA.FREIGHT_TERMS_LOOKUP_CODE
, PHA.STATUS_LOOKUP_CODE
, PHA.RATE_TYPE
, TO_CHAR(PHA.RATE_DATE
, 'DD-MON-YYYY HH24:MI:SS') RATE_DATE
, PHA.FROM_HEADER_ID
, PHA.FROM_TYPE_LOOKUP_CODE
, PHA.AUTHORIZATION_STATUS
, TO_CHAR(PHA.APPROVED_DATE
, 'DD-MON-YYYY HH24:MI:SS') APPROVED_DATE
, TO_CHAR(PHA.AMOUNT_LIMIT
, PO_COMMUNICATION_PVT.GETFORMATMASK) AMOUNT_LIMIT
, TO_CHAR(PHA.MIN_RELEASE_AMOUNT
, PO_COMMUNICATION_PVT.GETFORMATMASK) MIN_RELEASE_AMOUNT
, PHA.NOTE_TO_AUTHORIZER
, PHA.NOTE_TO_RECEIVER
, PHA.VENDOR_ORDER_NUM
, TO_CHAR(PHA.LAST_UPDATE_DATE
, 'DD-MON-YYYY HH24:MI:SS') LAST_UPDATE_DATE
, PHA.LAST_UPDATED_BY
, PHA.SUMMARY_FLAG
, PHA.ENABLED_FLAG
, PHA.SEGMENT2
, PHA.SEGMENT3
, PHA.SEGMENT4
, PHA.SEGMENT5
, TO_CHAR(PHA.START_DATE_ACTIVE
, 'DD-MON-YYYY HH24:MI:SS') START_DATE_ACTIVE
, TO_CHAR(PHA.END_DATE_ACTIVE
, 'DD-MON-YYYY HH24:MI:SS') END_DATE_ACTIVE
, PHA.LAST_UPDATE_LOGIN
, PHA.SUPPLY_AGREEMENT_FLAG
, PHA.GLOBAL_ATTRIBUTE_CATEGORY
, PHA.GLOBAL_ATTRIBUTE1
, PHA.GLOBAL_ATTRIBUTE2
, PHA.GLOBAL_ATTRIBUTE3
, PHA.GLOBAL_ATTRIBUTE4
, PHA.GLOBAL_ATTRIBUTE5
, PHA.GLOBAL_ATTRIBUTE6
, PHA.GLOBAL_ATTRIBUTE7
, PHA.GLOBAL_ATTRIBUTE8
, PHA.GLOBAL_ATTRIBUTE9
, PHA.GLOBAL_ATTRIBUTE10
, PHA.GLOBAL_ATTRIBUTE11
, PHA.GLOBAL_ATTRIBUTE12
, PHA.GLOBAL_ATTRIBUTE13
, PHA.GLOBAL_ATTRIBUTE14
, PHA.GLOBAL_ATTRIBUTE15
, PHA.GLOBAL_ATTRIBUTE16
, PHA.GLOBAL_ATTRIBUTE17
, PHA.GLOBAL_ATTRIBUTE18
, PHA.GLOBAL_ATTRIBUTE19
, PHA.GLOBAL_ATTRIBUTE20
, PHA.INTERFACE_SOURCE_CODE
, PHA.REFERENCE_NUM
, PHA.WF_ITEM_TYPE
, PHA.WF_ITEM_KEY
, PHA.PCARD_ID
, TO_CHAR( PHA.PRICE_UPDATE_TOLERANCE
, PO_COMMUNICATION_PVT.GETFORMATMASK) PRICE_UPDATE_TOLERANCE
, PHA.MRC_RATE_TYPE
, TO_CHAR(PHA.MRC_RATE_DATE
, 'DD-MON-YYYY HH24:MI:SS') MRC_RATE_DATE
, TO_CHAR(PHA.MRC_RATE
, PO_COMMUNICATION_PVT.GETFORMATMASK) MRC_RATE
, PHA.PAY_ON_CODE
, PHA.XML_FLAG
, TO_CHAR(PHA.XML_SEND_DATE
, 'DD-MON-YYYY HH24:MI:SS') XML_SEND_DATE
, TO_CHAR(PHA.XML_CHANGE_SEND_DATE
, 'DD-MON-YYYY HH24:MI:SS') XML_CHANGE_SEND_DATE
, PHA.GLOBAL_AGREEMENT_FLAG
, PHA.CONSIGNED_CONSUMPTION_FLAG
, TO_CHAR(PHA.CBC_ACCOUNTING_DATE
, 'DD-MON-YYYY HH24:MI:SS') CBC_ACCOUNTING_DATE
, PHA.CONSUME_REQ_DEMAND_FLAG
, PHA.CHANGE_REQUESTED_BY
, PLC3.MEANING SHIPPING_CONTROL
, PHA.CONTERMS_EXIST_FLAG
, TO_CHAR(PHA.CONTERMS_ARTICLES_UPD_DATE
, 'DD-MON-YYYY HH24:MI:SS') CONTERMS_ARTICLES_UPD_DATE
, TO_CHAR(PHA.CONTERMS_DELIV_UPD_DATE
, 'DD-MON-YYYY HH24:MI:SS') CONTERMS_DELIV_UPD_DATE
, NVL(PHA.PENDING_SIGNATURE_FLAG
, 'N')
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETOPERATIONINFO(PHA.ORG_ID)) OU_NAME
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETOUADDRESSLINE1()) OU_ADDR1
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETOUADDRESSLINE2()) OU_ADDR2
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETOUADDRESSLINE3()) OU_ADDR3
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETOUTOWNCITY()) OU_TOWN_CITY
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETOUREGION2()) OU_REGION2
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETOUPOSTALCODE()) OU_POSTALCODE
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETOUCOUNTRY()) OU_COUNTRY
, PO_COMMUNICATION_PVT.GETLOCATIONINFO(PA.LOCATION_ID) BUYER_LOCATION_ID
, PO_COMMUNICATION_PVT.GETADDRESSLINE1() BUYER_ADDRESS_LINE1
, PO_COMMUNICATION_PVT.GETADDRESSLINE2() BUYER_ADDRESS_LINE2
, PO_COMMUNICATION_PVT.GETADDRESSLINE3() BUYER_ADDRESS_LINE3
, PO_COMMUNICATION_PVT.GETADDRESSLINE4() BUYER_ADDRESS_LINE4
, PO_COMMUNICATION_PVT.GETADDRESSINFO() BUYER_CITY_STATE_ZIP
, PO_COMMUNICATION_PVT.GETPHONE() BUYER_CONTACT_PHONE
, PO_COMMUNICATION_PVT.GETFAX() BUYER_CONTACT_FAX
, PVS.FAX VENDOR_FAX
, TO_CHAR(DECODE(PHA.TYPE_LOOKUP_CODE
, 'STANDARD'
, PO_CORE_S.GET_ARCHIVE_TOTAL_FOR_ANY_REV (PHA.PO_HEADER_ID
, 'H'
, 'PO'
, 'STANDARD'
, PHA.REVISION_NUM
, NULL)
, NULL)
, PO_COMMUNICATION_PVT.GETFORMATMASK) TOTAL_AMOUNT
, PO_COMMUNICATION_PVT.GETTERRITORYSHORTNAME() BUYER_COUNTRY
, PVS.ADDRESS_LINE4 VENDOR_ADDRESS_LINE4
, PVS.AREA_CODE VENDOR_AREA_CODE
, PVC.AREA_CODE VENDOR_CONTACT_AREA_CODE
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETLEGALENTITYDETAILS(PHA.ORG_ID)) LE_NAME
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETLEADDRESSLINE1()) LE_ADDR1
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETLEADDRESSLINE2()) LE_ADDR2
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETLEADDRESSLINE3()) LE_ADDR3
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETLETOWNORCITY()) LE_TOWN_CITY
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETLESTATEORPROVINCE()) LE_STAE_PROVINCE
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETLEPOSTALCODE()) LE_POSTALCODE
, DECODE(NVL(PHA.ORG_ID
, -1)
, -1
, NULL
, PO_COMMUNICATION_PVT.GETLECOUNTRY()) LE_COUNTRY
, DECODE(PHA.CANCEL_FLAG
, 'Y'
, PO_COMMUNICATION_PVT.GETPOCANCELDATE(PHA.PO_HEADER_ID)
, NULL) CANCEL_DATE
, PHA.CHANGE_SUMMARY
, PHA.DOCUMENT_CREATION_METHOD
, PHA.ENCUMBRANCE_REQUIRED_FLAG
, PHA.LATEST_EXTERNAL_FLAG
FROM FND_LOOKUP_VALUES PLC1
, FND_LOOKUP_VALUES PLC2
, FND_CURRENCIES_TL FCC
, PO_VENDORS VN
, PO_VENDOR_SITES_ALL PVS
, PO_VENDOR_CONTACTS PVC
, PER_ALL_PEOPLE_F HRE
, AP_TERMS T
, PO_HEADERS_ARCHIVE_ALL PHA
, FND_TERRITORIES_TL FTE3
, ORG_FREIGHT_TL OFC
, PO_AGENTS PA
, FND_LOOKUP_VALUES PLC3
WHERE NVL(PHA.USER_HOLD_FLAG
, 'N') = 'N'
AND VN.VENDOR_ID = PHA.VENDOR_ID
AND PVS.VENDOR_SITE_ID = PHA.VENDOR_SITE_ID
AND PHA.VENDOR_CONTACT_ID = PVC.VENDOR_CONTACT_ID(+)
AND HRE.PERSON_ID = PHA.AGENT_ID
AND HRE.EMPLOYEE_NUMBER IS NOT NULL
AND TRUNC(SYSDATE) BETWEEN HRE.EFFECTIVE_START_DATE
AND HRE.EFFECTIVE_END_DATE
AND PHA.TERMS_ID = T.TERM_ID (+)
AND PHA.TYPE_LOOKUP_CODE IN ('STANDARD'
, 'BLANKET'
, 'CONTRACT')
AND FCC.CURRENCY_CODE = PHA.CURRENCY_CODE
AND PLC1.LOOKUP_CODE (+) = PHA.FOB_LOOKUP_CODE
AND PLC1.LOOKUP_TYPE (+) = 'FOB'
AND PLC1.LANGUAGE(+) = USERENV('LANG')
AND PLC1.VIEW_APPLICATION_ID(+) = 201
AND DECODE(PLC1.LOOKUP_CODE
, NULL
, 1
, PLC1.SECURITY_GROUP_ID) = DECODE(PLC1.LOOKUP_CODE
, NULL
, 1
, FND_GLOBAL.LOOKUP_SECURITY_GROUP(PLC1.LOOKUP_TYPE
, PLC1.VIEW_APPLICATION_ID) )
AND PLC2.LOOKUP_CODE (+) = PHA.FREIGHT_TERMS_LOOKUP_CODE
AND PLC2.LOOKUP_TYPE (+) = 'FREIGHT TERMS'
AND PLC2.LANGUAGE(+) = USERENV('LANG')
AND PLC2.VIEW_APPLICATION_ID(+) = 201
AND DECODE(PLC2.LOOKUP_CODE
, NULL
, 1
, PLC2.SECURITY_GROUP_ID) = DECODE(PLC2.LOOKUP_CODE
, NULL
, 1
, FND_GLOBAL.LOOKUP_SECURITY_GROUP(PLC2.LOOKUP_TYPE
, PLC2.VIEW_APPLICATION_ID))
AND PVS.COUNTRY = FTE3.TERRITORY_CODE (+)
AND DECODE(FTE3.TERRITORY_CODE
, NULL
, '1'
, FTE3.LANGUAGE) = DECODE(FTE3.TERRITORY_CODE
, NULL
, '1'
, USERENV('LANG'))
AND OFC.FREIGHT_CODE (+) = PHA.SHIP_VIA_LOOKUP_CODE
AND OFC.ORGANIZATION_ID (+) = PHA.ORG_ID
AND PA.AGENT_ID = PHA.AGENT_ID
AND PLC3.LOOKUP_CODE (+) = PHA.SHIPPING_CONTROL
AND PLC3.LOOKUP_TYPE (+) = 'SHIPPING CONTROL'
AND PLC3.LANGUAGE(+) = USERENV('LANG')
AND PLC3.VIEW_APPLICATION_ID(+) = 201
AND DECODE(PLC3.LOOKUP_CODE
, NULL
, 1
, PLC3.SECURITY_GROUP_ID) = DECODE(PLC3.LOOKUP_CODE
, NULL
, 1
, FND_GLOBAL.LOOKUP_SECURITY_GROUP(PLC3.LOOKUP_TYPE
, PLC3.VIEW_APPLICATION_ID))
AND FCC.LANGUAGE = USERENV('LANG')
AND OFC.LANGUAGE(+) = USERENV('LANG')

Columns