VIEW: APPS.AHL_OSP_ORDERS_V

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.OSP_ORDER_ID, B.OBJECT_VERSION_NUMBER, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_LOGIN, B.OSP_ORDER_NUMBER, B.ORDER_TYPE_CODE, FND1.MEANING ORDER_TYPE, B.SINGLE_INSTANCE_FLAG, FND2.MEANING SINGLE_INSTANCE_MEANING, B.PO_HEADER_ID, PO.SEGMENT1 PO_NUMBER, B.OE_HEADER_ID, OE.ORDER_NUMBER SHIPMENT_NUMBER, B.VENDOR_ID, VEND.VENDOR_NAME VENDOR, B.VENDOR_SITE_ID, VENS.VENDOR_SITE_CODE VENDOR_LOCATION, B.vendor_contact_id, rtrim(decode(con.prefix,null,'', con.prefix|| ' ') || decode(con.first_name ,null,'', con.first_name || ' ') || decode(con.middle_name ,null,'', con.middle_name || ' ') || con.last_name) vendor_contact, B.CUSTOMER_ID, CUST.PARTY_NAME CUSTOMER, B.ORDER_DATE, B.CONTRACT_ID, CTRCT.CONTRACT_NUMBER CONTRACT_NUMBER, B.CONTRACT_TERMS, B.OPERATING_UNIT_ID, B.PO_SYNCH_FLAG, B.STATUS_CODE, FND.MEANING STATUS, B.PO_BATCH_ID, B.PO_REQUEST_ID, B.PO_AGENT_ID, BUYERS.FULL_NAME BUYER, B.PO_REQ_HEADER_ID, PORH.SEGMENT1 PO_REQ_NUMBER, B.SECURITY_GROUP_ID, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6, B.ATTRIBUTE7, B.ATTRIBUTE8, B.ATTRIBUTE9, B.ATTRIBUTE10, B.ATTRIBUTE11, B.ATTRIBUTE12, B.ATTRIBUTE13, B.ATTRIBUTE14, B.ATTRIBUTE15, T.DESCRIPTION, B.PO_INTERFACE_HEADER_ID from AHL_OSP_ORDERS_TL T, AHL_OSP_ORDERS_B B, PO_HEADERS PO, OE_ORDER_HEADERS_ALL OE, PO_AGENTS_NAME_V BUYERS, HZ_PARTIES CUST, PO_VENDORS VEND, PO_VENDOR_SITES_ALL VENS, PO_VENDOR_CONTACTS CON, OKC_K_HEADERS_B CTRCT, FND_LOOKUP_VALUES FND, FND_LOOKUP_VALUES FND1, FND_LOOKUP_VALUES FND2, PO_REQUISITION_HEADERS_ALL PORH WHERE B.OSP_ORDER_ID = T.OSP_ORDER_ID AND T.LANGUAGE = userenv('LANG') AND B.OPERATING_UNIT_ID = mo_global.get_current_org_id() AND B.PO_HEADER_ID = PO.PO_HEADER_ID(+) AND B.OE_HEADER_ID = OE.HEADER_ID(+) AND B.PO_AGENT_ID = BUYERS.BUYER_ID(+) AND B.CUSTOMER_ID = CUST.PARTY_ID(+) AND B.VENDOR_ID = VEND.VENDOR_ID(+) AND B.VENDOR_SITE_ID = VENS.VENDOR_SITE_ID(+) AND B.vendor_contact_id = con.vendor_contact_id (+) AND B.CONTRACT_ID = CTRCT.ID(+) AND B.STATUS_CODE = FND.LOOKUP_CODE AND FND.LOOKUP_TYPE = 'AHL_OSP_STATUS_TYPE' AND B.ORDER_TYPE_CODE = FND1.LOOKUP_CODE AND FND1.LOOKUP_TYPE = 'AHL_OSP_ORDER_TYPE' AND B.SINGLE_INSTANCE_FLAG = FND2.LOOKUP_CODE(+) AND FND2. LOOKUP_TYPE = 'AHL_YES_NO_TYPE' AND FND.LANGUAGE = userenv('LANG') AND FND1.LANGUAGE = userenv('LANG') AND FND2.LANGUAGE = userenv('LANG') AND b.po_req_header_id = porh.requisition_header_id(+)

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.OSP_ORDER_ID
, B.OBJECT_VERSION_NUMBER
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OSP_ORDER_NUMBER
, B.ORDER_TYPE_CODE
, FND1.MEANING ORDER_TYPE
, B.SINGLE_INSTANCE_FLAG
, FND2.MEANING SINGLE_INSTANCE_MEANING
, B.PO_HEADER_ID
, PO.SEGMENT1 PO_NUMBER
, B.OE_HEADER_ID
, OE.ORDER_NUMBER SHIPMENT_NUMBER
, B.VENDOR_ID
, VEND.VENDOR_NAME VENDOR
, B.VENDOR_SITE_ID
, VENS.VENDOR_SITE_CODE VENDOR_LOCATION
, B.VENDOR_CONTACT_ID
, RTRIM(DECODE(CON.PREFIX
, NULL
, ''
, CON.PREFIX|| ' ') || DECODE(CON.FIRST_NAME
, NULL
, ''
, CON.FIRST_NAME || ' ') || DECODE(CON.MIDDLE_NAME
, NULL
, ''
, CON.MIDDLE_NAME || ' ') || CON.LAST_NAME) VENDOR_CONTACT
, B.CUSTOMER_ID
, CUST.PARTY_NAME CUSTOMER
, B.ORDER_DATE
, B.CONTRACT_ID
, CTRCT.CONTRACT_NUMBER CONTRACT_NUMBER
, B.CONTRACT_TERMS
, B.OPERATING_UNIT_ID
, B.PO_SYNCH_FLAG
, B.STATUS_CODE
, FND.MEANING STATUS
, B.PO_BATCH_ID
, B.PO_REQUEST_ID
, B.PO_AGENT_ID
, BUYERS.FULL_NAME BUYER
, B.PO_REQ_HEADER_ID
, PORH.SEGMENT1 PO_REQ_NUMBER
, B.SECURITY_GROUP_ID
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, T.DESCRIPTION
, B.PO_INTERFACE_HEADER_ID
FROM AHL_OSP_ORDERS_TL T
, AHL_OSP_ORDERS_B B
, PO_HEADERS PO
, OE_ORDER_HEADERS_ALL OE
, PO_AGENTS_NAME_V BUYERS
, HZ_PARTIES CUST
, PO_VENDORS VEND
, PO_VENDOR_SITES_ALL VENS
, PO_VENDOR_CONTACTS CON
, OKC_K_HEADERS_B CTRCT
, FND_LOOKUP_VALUES FND
, FND_LOOKUP_VALUES FND1
, FND_LOOKUP_VALUES FND2
, PO_REQUISITION_HEADERS_ALL PORH
WHERE B.OSP_ORDER_ID = T.OSP_ORDER_ID
AND T.LANGUAGE = USERENV('LANG')
AND B.OPERATING_UNIT_ID = MO_GLOBAL.GET_CURRENT_ORG_ID()
AND B.PO_HEADER_ID = PO.PO_HEADER_ID(+)
AND B.OE_HEADER_ID = OE.HEADER_ID(+)
AND B.PO_AGENT_ID = BUYERS.BUYER_ID(+)
AND B.CUSTOMER_ID = CUST.PARTY_ID(+)
AND B.VENDOR_ID = VEND.VENDOR_ID(+)
AND B.VENDOR_SITE_ID = VENS.VENDOR_SITE_ID(+)
AND B.VENDOR_CONTACT_ID = CON.VENDOR_CONTACT_ID (+)
AND B.CONTRACT_ID = CTRCT.ID(+)
AND B.STATUS_CODE = FND.LOOKUP_CODE
AND FND.LOOKUP_TYPE = 'AHL_OSP_STATUS_TYPE'
AND B.ORDER_TYPE_CODE = FND1.LOOKUP_CODE
AND FND1.LOOKUP_TYPE = 'AHL_OSP_ORDER_TYPE'
AND B.SINGLE_INSTANCE_FLAG = FND2.LOOKUP_CODE(+)
AND FND2. LOOKUP_TYPE = 'AHL_YES_NO_TYPE'
AND FND.LANGUAGE = USERENV('LANG')
AND FND1.LANGUAGE = USERENV('LANG')
AND FND2.LANGUAGE = USERENV('LANG')
AND B.PO_REQ_HEADER_ID = PORH.REQUISITION_HEADER_ID(+)