[Home] [Help]
SELECT requisition_header_id req_header_id, ha.creation_date creation_date, itg_x_utils.sumReqLines (ha.requisition_header_id) sum_reqlines, sob.currency_code curreny_code, ha.segment1 requisitnid, DECODE ( UPPER (ha.authorization_status), 'APPROVED', 1, 0) approved, ha.description descriptn, DECODE ( UPPER (ha.closed_code), 'APPROVED', '1', 'CLOSED', '2', 'FINALLY CLOSED', '2', 'CLOSED FOR RECEIVING', '3', 'CANCELLED', '4', 'AWAITING PRINTING', '5', 'CLOSED FOR INVOICE', '5' ) hdrstatus, ha.org_id poentity, per.employee_number requester, ha.attribute1 header_ua_attribute1, ha.attribute2 header_ua_attribute2, ha.attribute3 header_ua_attribute3, ha.attribute4 header_ua_attribute4, ha.attribute5 header_ua_attribute5, ha.attribute6 header_ua_attribute6, ha.attribute7 header_ua_attribute7, ha.attribute8 header_ua_attribute8, ha.attribute9 header_ua_attribute9, ha.attribute10 header_ua_attribute10, ha.attribute11 header_ua_attribute11, ha.attribute12 header_ua_attribute12, ha.attribute13 header_ua_attribute13, ha.attribute14 header_ua_attribute14, ha.attribute15 header_ua_attribute15, NULL to_po_internal, NULL to_misc, NULL to_approver, NULL to_buyer, NULL to_payables, NULL to_receiver, NULL to_supplier FROM gl_sets_of_books sob, org_organization_definitions org, per_people_f per, po_requisition_headers_all ha WHERE sob.set_of_books_id (+) = org.set_of_books_id AND org.organization_id (+) = ha.org_id AND ha.creation_date BETWEEN per.EFFECTIVE_START_DATE AND per.EFFECTIVE_END_DATE AND per.person_id = ha.preparer_id
SELECT REQUISITION_HEADER_ID REQ_HEADER_ID
, HA.CREATION_DATE CREATION_DATE
, ITG_X_UTILS.SUMREQLINES (HA.REQUISITION_HEADER_ID) SUM_REQLINES
, SOB.CURRENCY_CODE CURRENY_CODE
, HA.SEGMENT1 REQUISITNID
, DECODE ( UPPER (HA.AUTHORIZATION_STATUS)
, 'APPROVED'
, 1
, 0) APPROVED
, HA.DESCRIPTION DESCRIPTN
, DECODE ( UPPER (HA.CLOSED_CODE)
, 'APPROVED'
, '1'
, 'CLOSED'
, '2'
, 'FINALLY CLOSED'
, '2'
, 'CLOSED FOR RECEIVING'
, '3'
, 'CANCELLED'
, '4'
, 'AWAITING PRINTING'
, '5'
, 'CLOSED FOR INVOICE'
, '5' ) HDRSTATUS
, HA.ORG_ID POENTITY
, PER.EMPLOYEE_NUMBER REQUESTER
, HA.ATTRIBUTE1 HEADER_UA_ATTRIBUTE1
, HA.ATTRIBUTE2 HEADER_UA_ATTRIBUTE2
, HA.ATTRIBUTE3 HEADER_UA_ATTRIBUTE3
, HA.ATTRIBUTE4 HEADER_UA_ATTRIBUTE4
, HA.ATTRIBUTE5 HEADER_UA_ATTRIBUTE5
, HA.ATTRIBUTE6 HEADER_UA_ATTRIBUTE6
, HA.ATTRIBUTE7 HEADER_UA_ATTRIBUTE7
, HA.ATTRIBUTE8 HEADER_UA_ATTRIBUTE8
, HA.ATTRIBUTE9 HEADER_UA_ATTRIBUTE9
, HA.ATTRIBUTE10 HEADER_UA_ATTRIBUTE10
, HA.ATTRIBUTE11 HEADER_UA_ATTRIBUTE11
, HA.ATTRIBUTE12 HEADER_UA_ATTRIBUTE12
, HA.ATTRIBUTE13 HEADER_UA_ATTRIBUTE13
, HA.ATTRIBUTE14 HEADER_UA_ATTRIBUTE14
, HA.ATTRIBUTE15 HEADER_UA_ATTRIBUTE15
, NULL TO_PO_INTERNAL
, NULL TO_MISC
, NULL TO_APPROVER
, NULL TO_BUYER
, NULL TO_PAYABLES
, NULL TO_RECEIVER
, NULL TO_SUPPLIER
FROM GL_SETS_OF_BOOKS SOB
, ORG_ORGANIZATION_DEFINITIONS ORG
, PER_PEOPLE_F PER
, PO_REQUISITION_HEADERS_ALL HA
WHERE SOB.SET_OF_BOOKS_ID (+) = ORG.SET_OF_BOOKS_ID
AND ORG.ORGANIZATION_ID (+) = HA.ORG_ID
AND HA.CREATION_DATE BETWEEN PER.EFFECTIVE_START_DATE
AND PER.EFFECTIVE_END_DATE
AND PER.PERSON_ID = HA.PREPARER_ID
|
|
|
|