eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: APPS.POABV_EDW_CONTRACT_AGRMNTS_FCV

Source

View Text - Preformatted


SELECT inc.seq_id seq_id, 1 view_id, to_char(poh.po_header_id) || '-' || eli.instance_code contract_pk, eli.instance_code instance_fk, edw_hr_person_pkg.Regular_Employee_FK (poh.agent_id, eli.instance_code) buyer_fk, edw_hr_person_pkg.Regular_Employee_FK (nvl(POA_EDW_SPEND_PKG.APPROVED_BY (poh.po_header_id), poh.agent_id), eli.instance_code) approver_fk, edw_trd_partner_pkg.supplier_site_fk (poh.vendor_site_id, poh.org_id, eli.instance_code) supplier_site_fk, edw_organization_pkg.operating_unit_fk (poh.org_id, eli.instance_code) operating_unit_fk, edw_time_pkg.cal_day_fk( poh.creation_date, fsp.set_of_books_id, eli.instance_code) creation_date_fk, decode(NVL(POA_OLTP_GENERIC_PKG.get_approved_date_poh(poh.creation_date, poh.po_header_id), poh.approved_date), NULL, NULL, edw_time_pkg.cal_day_fk( NVL(POA_OLTP_GENERIC_PKG.get_approved_date_poh(poh.creation_date, poh.po_header_id), poh.approved_date), fsp.set_of_books_id, eli.instance_code)) approved_date_fk, decode(poh.revised_date, NULL, NULL, edw_time_pkg.cal_day_fk ( to_date(poh.revised_date, 'dd-MON-rr HH24:MI'), fsp.set_of_books_id, eli.instance_code)) revised_date_fk, decode(poh.acceptance_due_date, NULL, NULL, edw_time_pkg.cal_day_fk( poh.acceptance_due_date, fsp.set_of_books_id, eli.instance_code)) accpt_due_date_fk, decode(poh.start_date, NULL, NULL, edw_time_pkg.cal_day_fk( poh.start_date, fsp.set_of_books_id, eli.instance_code)) start_date_fk, decode(poh.end_date, NULL, NULL, edw_time_pkg.cal_day_fk( poh.end_date, fsp.set_of_books_id, eli.instance_code)) end_date_fk, decode(poh.printed_date, NULL, NULL, edw_time_pkg.cal_day_fk( poh.printed_date, fsp.set_of_books_id, eli.instance_code)) printed_date_fk, decode(poh.rate_date, NULL, NULL, edw_time_pkg.cal_day_fk( poh.rate_date, fsp.set_of_books_id, eli.instance_code)) txn_cur_date_fk, decode(poh.terms_id, NULL, NULL, poh.terms_id || '-' || 'AP' || '-' || eli.instance_code) ap_terms_fk, decode(poh.closed_code, NULL, NULL, upper(poh.closed_code) || '-' || 'DOCUMENT STATE' || '-' || 'PO') closed_fk, decode(poh.type_lookup_code, NULL, NULL, upper(poh.type_lookup_code) || '-' || 'AGREEMENT TYPE' || '-' || 'POD') po_type_fk, decode(poh.ship_via_lookup_code, NULL, NULL, upper(poh.ship_via_lookup_code) || '-' || 'SHIP VIA TYPE' || '-' || 'ORG') ship_via_fk, decode(poh.fob_lookup_code, NULL, NULL, upper(poh.fob_lookup_code) || '-' || 'FOB' || '-' || 'PO') fob_fk, decode(poh.freight_terms_lookup_code, NULL, NULL, upper(poh.freight_terms_lookup_code) || '-' || 'FREIGHT TERMS' || '-' || 'PO') freight_terms_fk, nvl(poh.acceptance_required_flag, 'N') || '-' || 'YES_NO' || '-' || 'FND' accpt_required_fk, nvl(poh.frozen_flag, 'N') || '-' || 'YES_NO' || '-' || 'FND' frozen_fk, nvl(poh.cancel_flag, 'N') || '-' || 'YES_NO' || '-' || 'FND' cancelled_fk, nvl(poh.user_hold_flag, 'N') || '-' || 'YES_NO' || '-' || 'FND' user_hold_fk, nvl(poh.confirming_order_flag, 'N') || '-' || 'YES_NO' || '-' || 'FND' confirm_order_fk, nvl(poh.approved_flag, 'N') || '-' || 'YES_NO' || '-' || 'FND' approved_fk, nvl(poh.edi_processed_flag, 'N') || '-' || 'YES_NO' || '-' || 'FND' edi_processed_fk, decode(poh.start_date, least(poh.start_date, sysdate), decode(poh.end_date, greatest(poh.end_date,sysdate), 'Y', decode(poh.end_date, NULL, 'Y', 'N')), decode(poh.start_date, NULL, decode(poh.end_date, greatest(poh.end_date,sysdate), 'Y', decode(poh.end_date, NULL, 'Y', 'N')), 'N')) || '-' || 'YES_NO' || '-' || 'FND' contract_effective_fk, decode(poh.vendor_site_id, NULL, 'NA_EDW', pvs.city || '-' || pvs.zip || '-' || decode(pvs.state, null, pvs.province, pvs.state) || '-' || pvs.country) sup_site_geog_fk, decode(poh.bill_to_location_id, NULL, 'NA_EDW', hrl2.town_or_city || '-' || hrl2.postal_code || '-' || hrl2.region_2 || '-' || hrl2.country) bill_location_fk, decode(poh.ship_to_location_id, NULL, 'NA_EDW', decode(hrl1.location_id, null, EDW_GEOGRAPHY_PKG.HZ_Postcode_City_fk(poh.ship_to_location_id), hrl1.town_or_city || '-' || hrl1.postal_code || '-' || hrl1.region_2 || '-' || hrl1.country)) ship_location_fk, poh.po_header_id || '-' || eli.instance_code contract_num_fk, nvl(poh.currency_code, gsob.currency_code) txn_cur_code_fk, poh.rate_type txn_cur_rate_type, /*** measures ***/ poh.blanket_total_amount amt_agreed_t, DECODE(poh.rate_type, 'User', edw_currency.convert_global_amount( poh.rate*poh.blanket_total_amount, to_number(NULL), gsob.currency_code, fsp.set_of_books_id, NVL(poh.rate_date, poh.creation_date), NULL), edw_currency.convert_global_amount( poh.blanket_total_amount, to_number(NULL), nvl(poh.currency_code, gsob.currency_code), fsp.set_of_books_id, NVL(poh.rate_date, poh.creation_date), poh.rate_type)) amt_agreed_g, poh.amount_limit amt_limit_t, DECODE(poh.rate_type, 'User', edw_currency.convert_global_amount( poh.rate*poh.amount_limit, to_number(NULL), gsob.currency_code, fsp.set_of_books_id, NVL(poh.rate_date, poh.creation_date), NULL), edw_currency.convert_global_amount( poh.amount_limit, to_number(NULL), nvl(poh.currency_code, gsob.currency_code), fsp.set_of_books_id, NVL(poh.rate_date, poh.creation_date), poh.rate_type)) amt_limit_g, poh.min_release_amount amt_min_release_t, DECODE(poh.rate_type, 'User', edw_currency.convert_global_amount( poh.rate*poh.min_release_amount, to_number(NULL), gsob.currency_code, fsp.set_of_books_id, NVL(poh.rate_date, poh.creation_date), NULL), edw_currency.convert_global_amount( poh.min_release_amount, to_number(NULL), nvl(poh.currency_code, gsob.currency_code), fsp.set_of_books_id, NVL(poh.rate_date, poh.creation_date), poh.rate_type)) amt_min_release_g, POA_EDW_SPEND_PKG.CONTRACT_AMT_RELEASED( poh.po_header_id, poh.org_id, poh.type_lookup_code) amt_released_t, DECODE(poh.rate_type, 'User', edw_currency.convert_global_amount( poh.rate*POA_EDW_SPEND_PKG.CONTRACT_AMT_RELEASED( poh.po_header_id, poh.org_id, poh.type_lookup_code), to_number(NULL), gsob.currency_code, fsp.set_of_books_id, NVL(poh.rate_date, poh.creation_date), NULL), edw_currency.convert_global_amount( POA_EDW_SPEND_PKG.CONTRACT_AMT_RELEASED( poh.po_header_id, poh.org_id, poh.type_lookup_code), to_number(NULL), nvl(poh.currency_code, gsob.currency_code), fsp.set_of_books_id, NVL(poh.rate_date, poh.creation_date), poh.rate_type)) amt_released_g, NVL(POA_OLTP_GENERIC_PKG.get_approved_date_poh(poh.creation_date, poh.po_header_id), poh.approved_date) - poh.creation_date num_days_create_to_app, nvl(poh.printed_date, poh.approved_date) - poh.approved_date num_days_app_to_send, poh.acceptance_due_date - nvl(poh.printed_date, poh.approved_date) num_days_app_send_to_accpt, /*** Attributes ***/ poh.po_header_id po_header_id, poh.note_to_vendor supplier_note, poh.comments comments, poh.note_to_receiver receiver_note, poh.revision_num revision_num, poh.segment1 contract_num, poh.rate txn_cur_rate, greatest(poh.last_update_date, fsp.last_update_date, gsob.last_update_date) last_update_date, poh.creation_date creation_date, NULL DUNS_FK, NULL SIC_CODE_FK, decode(edw_currency.get_rate( decode(poh.rate_type, 'User', gsob.currency_code, nvl(poh.currency_code, gsob.currency_code)), NVL(poh.rate_date, poh.creation_date), NULL), -1, 'RATE NOT AVAILABLE', -2, 'INVALID CURRENCY', 'LOCAL READY') collection_status, '_DF:PO:PO_HEADERS:poh' FROM poa_edw_contract_inc inc, po_headers_all poh, gl_sets_of_books gsob, financials_system_params_all fsp, edw_local_instance eli, po_vendor_sites_all pvs, hr_locations_all hrl1, hr_locations_all hrl2 WHERE inc.primary_key = poh.po_header_id AND nvl(poh.org_id, -999) = nvl(fsp.org_id, -999) AND gsob.set_of_books_id = fsp.set_of_books_id AND pvs.vendor_id (+)= poh.vendor_id AND pvs.vendor_site_id (+)= poh.vendor_site_id AND poh.ship_to_location_id = hrl1.location_id (+) AND poh.bill_to_location_id = hrl2.location_id (+)

View Text - HTML Formatted

SELECT INC.SEQ_ID SEQ_ID
, 1 VIEW_ID
, TO_CHAR(POH.PO_HEADER_ID) || '-' || ELI.INSTANCE_CODE CONTRACT_PK
, ELI.INSTANCE_CODE INSTANCE_FK
, EDW_HR_PERSON_PKG.REGULAR_EMPLOYEE_FK (POH.AGENT_ID
, ELI.INSTANCE_CODE) BUYER_FK
, EDW_HR_PERSON_PKG.REGULAR_EMPLOYEE_FK (NVL(POA_EDW_SPEND_PKG.APPROVED_BY (POH.PO_HEADER_ID)
, POH.AGENT_ID)
, ELI.INSTANCE_CODE) APPROVER_FK
, EDW_TRD_PARTNER_PKG.SUPPLIER_SITE_FK (POH.VENDOR_SITE_ID
, POH.ORG_ID
, ELI.INSTANCE_CODE) SUPPLIER_SITE_FK
, EDW_ORGANIZATION_PKG.OPERATING_UNIT_FK (POH.ORG_ID
, ELI.INSTANCE_CODE) OPERATING_UNIT_FK
, EDW_TIME_PKG.CAL_DAY_FK( POH.CREATION_DATE
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE) CREATION_DATE_FK
, DECODE(NVL(POA_OLTP_GENERIC_PKG.GET_APPROVED_DATE_POH(POH.CREATION_DATE
, POH.PO_HEADER_ID)
, POH.APPROVED_DATE)
, NULL
, NULL
, EDW_TIME_PKG.CAL_DAY_FK( NVL(POA_OLTP_GENERIC_PKG.GET_APPROVED_DATE_POH(POH.CREATION_DATE
, POH.PO_HEADER_ID)
, POH.APPROVED_DATE)
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE)) APPROVED_DATE_FK
, DECODE(POH.REVISED_DATE
, NULL
, NULL
, EDW_TIME_PKG.CAL_DAY_FK ( TO_DATE(POH.REVISED_DATE
, 'DD-MON-RR HH24:MI')
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE)) REVISED_DATE_FK
, DECODE(POH.ACCEPTANCE_DUE_DATE
, NULL
, NULL
, EDW_TIME_PKG.CAL_DAY_FK( POH.ACCEPTANCE_DUE_DATE
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE)) ACCPT_DUE_DATE_FK
, DECODE(POH.START_DATE
, NULL
, NULL
, EDW_TIME_PKG.CAL_DAY_FK( POH.START_DATE
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE)) START_DATE_FK
, DECODE(POH.END_DATE
, NULL
, NULL
, EDW_TIME_PKG.CAL_DAY_FK( POH.END_DATE
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE)) END_DATE_FK
, DECODE(POH.PRINTED_DATE
, NULL
, NULL
, EDW_TIME_PKG.CAL_DAY_FK( POH.PRINTED_DATE
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE)) PRINTED_DATE_FK
, DECODE(POH.RATE_DATE
, NULL
, NULL
, EDW_TIME_PKG.CAL_DAY_FK( POH.RATE_DATE
, FSP.SET_OF_BOOKS_ID
, ELI.INSTANCE_CODE)) TXN_CUR_DATE_FK
, DECODE(POH.TERMS_ID
, NULL
, NULL
, POH.TERMS_ID || '-' || 'AP' || '-' || ELI.INSTANCE_CODE) AP_TERMS_FK
, DECODE(POH.CLOSED_CODE
, NULL
, NULL
, UPPER(POH.CLOSED_CODE) || '-' || 'DOCUMENT STATE' || '-' || 'PO') CLOSED_FK
, DECODE(POH.TYPE_LOOKUP_CODE
, NULL
, NULL
, UPPER(POH.TYPE_LOOKUP_CODE) || '-' || 'AGREEMENT TYPE' || '-' || 'POD') PO_TYPE_FK
, DECODE(POH.SHIP_VIA_LOOKUP_CODE
, NULL
, NULL
, UPPER(POH.SHIP_VIA_LOOKUP_CODE) || '-' || 'SHIP VIA TYPE' || '-' || 'ORG') SHIP_VIA_FK
, DECODE(POH.FOB_LOOKUP_CODE
, NULL
, NULL
, UPPER(POH.FOB_LOOKUP_CODE) || '-' || 'FOB' || '-' || 'PO') FOB_FK
, DECODE(POH.FREIGHT_TERMS_LOOKUP_CODE
, NULL
, NULL
, UPPER(POH.FREIGHT_TERMS_LOOKUP_CODE) || '-' || 'FREIGHT TERMS' || '-' || 'PO') FREIGHT_TERMS_FK
, NVL(POH.ACCEPTANCE_REQUIRED_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND' ACCPT_REQUIRED_FK
, NVL(POH.FROZEN_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND' FROZEN_FK
, NVL(POH.CANCEL_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND' CANCELLED_FK
, NVL(POH.USER_HOLD_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND' USER_HOLD_FK
, NVL(POH.CONFIRMING_ORDER_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND' CONFIRM_ORDER_FK
, NVL(POH.APPROVED_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND' APPROVED_FK
, NVL(POH.EDI_PROCESSED_FLAG
, 'N') || '-' || 'YES_NO' || '-' || 'FND' EDI_PROCESSED_FK
, DECODE(POH.START_DATE
, LEAST(POH.START_DATE
, SYSDATE)
, DECODE(POH.END_DATE
, GREATEST(POH.END_DATE
, SYSDATE)
, 'Y'
, DECODE(POH.END_DATE
, NULL
, 'Y'
, 'N'))
, DECODE(POH.START_DATE
, NULL
, DECODE(POH.END_DATE
, GREATEST(POH.END_DATE
, SYSDATE)
, 'Y'
, DECODE(POH.END_DATE
, NULL
, 'Y'
, 'N'))
, 'N')) || '-' || 'YES_NO' || '-' || 'FND' CONTRACT_EFFECTIVE_FK
, DECODE(POH.VENDOR_SITE_ID
, NULL
, 'NA_EDW'
, PVS.CITY || '-' || PVS.ZIP || '-' || DECODE(PVS.STATE
, NULL
, PVS.PROVINCE
, PVS.STATE) || '-' || PVS.COUNTRY) SUP_SITE_GEOG_FK
, DECODE(POH.BILL_TO_LOCATION_ID
, NULL
, 'NA_EDW'
, HRL2.TOWN_OR_CITY || '-' || HRL2.POSTAL_CODE || '-' || HRL2.REGION_2 || '-' || HRL2.COUNTRY) BILL_LOCATION_FK
, DECODE(POH.SHIP_TO_LOCATION_ID
, NULL
, 'NA_EDW'
, DECODE(HRL1.LOCATION_ID
, NULL
, EDW_GEOGRAPHY_PKG.HZ_POSTCODE_CITY_FK(POH.SHIP_TO_LOCATION_ID)
, HRL1.TOWN_OR_CITY || '-' || HRL1.POSTAL_CODE || '-' || HRL1.REGION_2 || '-' || HRL1.COUNTRY)) SHIP_LOCATION_FK
, POH.PO_HEADER_ID || '-' || ELI.INSTANCE_CODE CONTRACT_NUM_FK
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE) TXN_CUR_CODE_FK
, POH.RATE_TYPE TXN_CUR_RATE_TYPE
, /*** MEASURES ***/ POH.BLANKET_TOTAL_AMOUNT AMT_AGREED_T
, DECODE(POH.RATE_TYPE
, 'USER'
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POH.RATE*POH.BLANKET_TOTAL_AMOUNT
, TO_NUMBER(NULL)
, GSOB.CURRENCY_CODE
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POH.CREATION_DATE)
, NULL)
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POH.BLANKET_TOTAL_AMOUNT
, TO_NUMBER(NULL)
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE)
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POH.CREATION_DATE)
, POH.RATE_TYPE)) AMT_AGREED_G
, POH.AMOUNT_LIMIT AMT_LIMIT_T
, DECODE(POH.RATE_TYPE
, 'USER'
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POH.RATE*POH.AMOUNT_LIMIT
, TO_NUMBER(NULL)
, GSOB.CURRENCY_CODE
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POH.CREATION_DATE)
, NULL)
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POH.AMOUNT_LIMIT
, TO_NUMBER(NULL)
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE)
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POH.CREATION_DATE)
, POH.RATE_TYPE)) AMT_LIMIT_G
, POH.MIN_RELEASE_AMOUNT AMT_MIN_RELEASE_T
, DECODE(POH.RATE_TYPE
, 'USER'
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POH.RATE*POH.MIN_RELEASE_AMOUNT
, TO_NUMBER(NULL)
, GSOB.CURRENCY_CODE
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POH.CREATION_DATE)
, NULL)
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POH.MIN_RELEASE_AMOUNT
, TO_NUMBER(NULL)
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE)
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POH.CREATION_DATE)
, POH.RATE_TYPE)) AMT_MIN_RELEASE_G
, POA_EDW_SPEND_PKG.CONTRACT_AMT_RELEASED( POH.PO_HEADER_ID
, POH.ORG_ID
, POH.TYPE_LOOKUP_CODE) AMT_RELEASED_T
, DECODE(POH.RATE_TYPE
, 'USER'
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POH.RATE*POA_EDW_SPEND_PKG.CONTRACT_AMT_RELEASED( POH.PO_HEADER_ID
, POH.ORG_ID
, POH.TYPE_LOOKUP_CODE)
, TO_NUMBER(NULL)
, GSOB.CURRENCY_CODE
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POH.CREATION_DATE)
, NULL)
, EDW_CURRENCY.CONVERT_GLOBAL_AMOUNT( POA_EDW_SPEND_PKG.CONTRACT_AMT_RELEASED( POH.PO_HEADER_ID
, POH.ORG_ID
, POH.TYPE_LOOKUP_CODE)
, TO_NUMBER(NULL)
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE)
, FSP.SET_OF_BOOKS_ID
, NVL(POH.RATE_DATE
, POH.CREATION_DATE)
, POH.RATE_TYPE)) AMT_RELEASED_G
, NVL(POA_OLTP_GENERIC_PKG.GET_APPROVED_DATE_POH(POH.CREATION_DATE
, POH.PO_HEADER_ID)
, POH.APPROVED_DATE) - POH.CREATION_DATE NUM_DAYS_CREATE_TO_APP
, NVL(POH.PRINTED_DATE
, POH.APPROVED_DATE) - POH.APPROVED_DATE NUM_DAYS_APP_TO_SEND
, POH.ACCEPTANCE_DUE_DATE - NVL(POH.PRINTED_DATE
, POH.APPROVED_DATE) NUM_DAYS_APP_SEND_TO_ACCPT
, /*** ATTRIBUTES ***/ POH.PO_HEADER_ID PO_HEADER_ID
, POH.NOTE_TO_VENDOR SUPPLIER_NOTE
, POH.COMMENTS COMMENTS
, POH.NOTE_TO_RECEIVER RECEIVER_NOTE
, POH.REVISION_NUM REVISION_NUM
, POH.SEGMENT1 CONTRACT_NUM
, POH.RATE TXN_CUR_RATE
, GREATEST(POH.LAST_UPDATE_DATE
, FSP.LAST_UPDATE_DATE
, GSOB.LAST_UPDATE_DATE) LAST_UPDATE_DATE
, POH.CREATION_DATE CREATION_DATE
, NULL DUNS_FK
, NULL SIC_CODE_FK
, DECODE(EDW_CURRENCY.GET_RATE( DECODE(POH.RATE_TYPE
, 'USER'
, GSOB.CURRENCY_CODE
, NVL(POH.CURRENCY_CODE
, GSOB.CURRENCY_CODE))
, NVL(POH.RATE_DATE
, POH.CREATION_DATE)
, NULL)
, -1
, 'RATE NOT AVAILABLE'
, -2
, 'INVALID CURRENCY'
, 'LOCAL READY') COLLECTION_STATUS
, '_DF:PO:PO_HEADERS:POH'
FROM POA_EDW_CONTRACT_INC INC
, PO_HEADERS_ALL POH
, GL_SETS_OF_BOOKS GSOB
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, EDW_LOCAL_INSTANCE ELI
, PO_VENDOR_SITES_ALL PVS
, HR_LOCATIONS_ALL HRL1
, HR_LOCATIONS_ALL HRL2
WHERE INC.PRIMARY_KEY = POH.PO_HEADER_ID
AND NVL(POH.ORG_ID
, -999) = NVL(FSP.ORG_ID
, -999)
AND GSOB.SET_OF_BOOKS_ID = FSP.SET_OF_BOOKS_ID
AND PVS.VENDOR_ID (+)= POH.VENDOR_ID
AND PVS.VENDOR_SITE_ID (+)= POH.VENDOR_SITE_ID
AND POH.SHIP_TO_LOCATION_ID = HRL1.LOCATION_ID (+)
AND POH.BILL_TO_LOCATION_ID = HRL2.LOCATION_ID (+)