DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.PO_VENDOR_SITES

Object Details
Object Name: PO_VENDOR_SITES
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.PO_VENDOR_SITES
ViewSQLAP.PO_VENDOR_SITES
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


PO_VENDOR_SITES is a single-organization view created to support
multiple organizations in Release 10.7. The PO_VENDOR_SITES view
replaces Release 10.6 PO_VENDOR_SITES partitioned tables.
.
For more information, see Multiple Organizations in Oracle
Applications and any Multiple Organizations release notes.
Not In Use


[View Source]

Columns
Name Datatype Length Mandatory Comments
ADDRESS_STYLE VARCHAR2 (30)

LANGUAGE VARCHAR2 (30)

PROVINCE VARCHAR2 (60)

COUNTRY VARCHAR2 (25)

AREA_CODE VARCHAR2 (10)

PHONE VARCHAR2 (15)

CUSTOMER_NUM VARCHAR2 (25)

SHIP_TO_LOCATION_ID NUMBER


BILL_TO_LOCATION_ID NUMBER


SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)

FREIGHT_TERMS_LOOKUP_CODE VARCHAR2 (25)

FOB_LOOKUP_CODE VARCHAR2 (25)

INACTIVE_DATE DATE


FAX VARCHAR2 (15)

FAX_AREA_CODE VARCHAR2 (10)

TELEX VARCHAR2 (15)

TERMS_DATE_BASIS VARCHAR2 (25)

DISTRIBUTION_SET_ID NUMBER


ACCTS_PAY_CODE_COMBINATION_ID NUMBER


PREPAY_CODE_COMBINATION_ID NUMBER


PAY_GROUP_LOOKUP_CODE VARCHAR2 (25)

PAYMENT_PRIORITY NUMBER


TERMS_ID NUMBER


INVOICE_AMOUNT_LIMIT NUMBER


PAY_DATE_BASIS_LOOKUP_CODE VARCHAR2 (25)

ALWAYS_TAKE_DISC_FLAG VARCHAR2 (1)

INVOICE_CURRENCY_CODE VARCHAR2 (15)

PAYMENT_CURRENCY_CODE VARCHAR2 (15)

COUNTY VARCHAR2 (60)

VENDOR_SITE_ID NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER
Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
VENDOR_ID NUMBER
Yes
VENDOR_SITE_CODE VARCHAR2 (15)

VENDOR_SITE_CODE_ALT VARCHAR2 (320)
LAST_UPDATE_LOGIN NUMBER

Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
CREATED_BY NUMBER
Yes Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
PURCHASING_SITE_FLAG VARCHAR2 (1)

RFQ_ONLY_SITE_FLAG VARCHAR2 (1)

PAY_SITE_FLAG VARCHAR2 (1)

ATTENTION_AR_FLAG VARCHAR2 (1)

ADDRESS_LINE1 VARCHAR2 (240)

ADDRESS_LINE2 VARCHAR2 (240)

ADDRESS_LINE3 VARCHAR2 (240)

ADDRESS_LINES_ALT VARCHAR2 (560)
CITY VARCHAR2 (60)

STATE VARCHAR2 (60)

ZIP VARCHAR2 (20)

HOLD_ALL_PAYMENTS_FLAG VARCHAR2 (1)

HOLD_FUTURE_PAYMENTS_FLAG VARCHAR2 (1)

HOLD_REASON VARCHAR2 (240)

HOLD_UNMATCHED_INVOICES_FLAG VARCHAR2 (1)

TAX_REPORTING_SITE_FLAG VARCHAR2 (1)

ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
REQUEST_ID NUMBER

Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID NUMBER

Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID NUMBER

Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE DATE

Concurrent Program who column - date when a program last updated this row).
VALIDATION_NUMBER NUMBER


EXCLUDE_FREIGHT_FROM_DISCOUNT VARCHAR2 (1)

BANK_CHARGE_BEARER VARCHAR2 (1)
ORG_ID NUMBER

Organization identifier
CHECK_DIGITS VARCHAR2 (30)

ADDRESS_LINE4 VARCHAR2 (240)

ALLOW_AWT_FLAG VARCHAR2 (1)
AWT_GROUP_ID NUMBER (15)
PAY_AWT_GROUP_ID NUMBER (15)
DEFAULT_PAY_SITE_ID NUMBER (15)
PAY_ON_CODE VARCHAR2 (25)
PAY_ON_RECEIPT_SUMMARY_CODE VARCHAR2 (25)
GLOBAL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
GLOBAL_ATTRIBUTE1 VARCHAR2 (150)
GLOBAL_ATTRIBUTE2 VARCHAR2 (150)
GLOBAL_ATTRIBUTE3 VARCHAR2 (150)
GLOBAL_ATTRIBUTE4 VARCHAR2 (150)
GLOBAL_ATTRIBUTE5 VARCHAR2 (150)
GLOBAL_ATTRIBUTE6 VARCHAR2 (150)
GLOBAL_ATTRIBUTE7 VARCHAR2 (150)
GLOBAL_ATTRIBUTE8 VARCHAR2 (150)
GLOBAL_ATTRIBUTE9 VARCHAR2 (150)
GLOBAL_ATTRIBUTE10 VARCHAR2 (150)
GLOBAL_ATTRIBUTE11 VARCHAR2 (150)
GLOBAL_ATTRIBUTE12 VARCHAR2 (150)
GLOBAL_ATTRIBUTE13 VARCHAR2 (150)
GLOBAL_ATTRIBUTE14 VARCHAR2 (150)
GLOBAL_ATTRIBUTE15 VARCHAR2 (150)
GLOBAL_ATTRIBUTE16 VARCHAR2 (150)
GLOBAL_ATTRIBUTE17 VARCHAR2 (150)
GLOBAL_ATTRIBUTE18 VARCHAR2 (150)
GLOBAL_ATTRIBUTE19 VARCHAR2 (150)
GLOBAL_ATTRIBUTE20 VARCHAR2 (150)
TP_HEADER_ID NUMBER

EDI Transaction Header Unique Identifier
ECE_TP_LOCATION_CODE VARCHAR2 (60)
Training partner location code for EDI Gateway
PCARD_SITE_FLAG VARCHAR2 (1)
Indicates if a site allows use of procurement cards
MATCH_OPTION VARCHAR2 (25)
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
Country of origin code
FUTURE_DATED_PAYMENT_CCID NUMBER (15)
CREATE_DEBIT_MEMO_FLAG VARCHAR2 (25)
SUPPLIER_NOTIF_METHOD VARCHAR2 (25)
EMAIL_ADDRESS VARCHAR2 (2000)
PRIMARY_PAY_SITE_FLAG VARCHAR2 (1)
A value of Y indicates that this is the default pay site for the supplier
SHIPPING_CONTROL VARCHAR2 (30)
Indicator of who is responsible for arranging transportation
SELLING_COMPANY_IDENTIFIER VARCHAR2 (10)
GAPLESS_INV_NUM_FLAG VARCHAR2 (1)
DUNS_NUMBER VARCHAR2 (30)
DUNS Number
LOCATION_ID NUMBER (15)
PARTY_SITE_ID NUMBER (15)
TOLERANCE_ID NUMBER (15)
SERVICES_TOLERANCE_ID NUMBER (15)
PAYMENT_METHOD_LOOKUP_CODE VARCHAR2 (25)

BANK_ACCOUNT_NAME VARCHAR2 (80)

BANK_ACCOUNT_NUM VARCHAR2 (30)

BANK_NUM VARCHAR2 (25)

BANK_ACCOUNT_TYPE VARCHAR2 (25)

CURRENT_CATALOG_NUM VARCHAR2 (20)

VAT_CODE VARCHAR2 (30)

AP_TAX_ROUNDING_RULE VARCHAR2 (1)
AUTO_TAX_CALC_FLAG VARCHAR2 (1)
AUTO_TAX_CALC_OVERRIDE VARCHAR2 (1)
AMOUNT_INCLUDES_TAX_FLAG VARCHAR2 (1)
OFFSET_VAT_CODE VARCHAR2 (20)

BANK_NUMBER VARCHAR2 (30)

BANK_BRANCH_TYPE VARCHAR2 (25)
OFFSET_TAX_FLAG VARCHAR2 (1)
REMITTANCE_EMAIL VARCHAR2 (2000)
REMITTANCE EMAIL ID
EDI_TRANSACTION_HANDLING VARCHAR2 (25)
EDI_ID_NUMBER VARCHAR2 (30)
EDI_PAYMENT_METHOD VARCHAR2 (25)
EDI_PAYMENT_FORMAT VARCHAR2 (25)
EDI_REMITTANCE_METHOD VARCHAR2 (25)
EDI_REMITTANCE_INSTRUCTION VARCHAR2 (256)
EXCLUSIVE_PAYMENT_FLAG VARCHAR2 (1)

RETAINAGE_RATE NUMBER

VAT_REGISTRATION_NUM VARCHAR2 (20)

LANGUAGE_CODE VARCHAR2 (4)
CAGE_CODE VARCHAR2 (5)
LEGAL_BUSINESS_NAME VARCHAR2 (240)
DOING_BUS_AS_NAME VARCHAR2 (240)
DIVISION_NAME VARCHAR2 (60)
SMALL_BUSINESS_CODE VARCHAR2 (10)
CCR_COMMENTS VARCHAR2 (240)
DEBARMENT_START_DATE DATE

DEBARMENT_END_DATE DATE

STATUS VARCHAR2 (1)
END_DATE_ACTIVE DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ADDRESS_STYLE
,      LANGUAGE
,      PROVINCE
,      COUNTRY
,      AREA_CODE
,      PHONE
,      CUSTOMER_NUM
,      SHIP_TO_LOCATION_ID
,      BILL_TO_LOCATION_ID
,      SHIP_VIA_LOOKUP_CODE
,      FREIGHT_TERMS_LOOKUP_CODE
,      FOB_LOOKUP_CODE
,      INACTIVE_DATE
,      FAX
,      FAX_AREA_CODE
,      TELEX
,      TERMS_DATE_BASIS
,      DISTRIBUTION_SET_ID
,      ACCTS_PAY_CODE_COMBINATION_ID
,      PREPAY_CODE_COMBINATION_ID
,      PAY_GROUP_LOOKUP_CODE
,      PAYMENT_PRIORITY
,      TERMS_ID
,      INVOICE_AMOUNT_LIMIT
,      PAY_DATE_BASIS_LOOKUP_CODE
,      ALWAYS_TAKE_DISC_FLAG
,      INVOICE_CURRENCY_CODE
,      PAYMENT_CURRENCY_CODE
,      COUNTY
,      VENDOR_SITE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      VENDOR_ID
,      VENDOR_SITE_CODE
,      VENDOR_SITE_CODE_ALT
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      PURCHASING_SITE_FLAG
,      RFQ_ONLY_SITE_FLAG
,      PAY_SITE_FLAG
,      ATTENTION_AR_FLAG
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINES_ALT
,      CITY
,      STATE
,      ZIP
,      HOLD_ALL_PAYMENTS_FLAG
,      HOLD_FUTURE_PAYMENTS_FLAG
,      HOLD_REASON
,      HOLD_UNMATCHED_INVOICES_FLAG
,      TAX_REPORTING_SITE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      VALIDATION_NUMBER
,      EXCLUDE_FREIGHT_FROM_DISCOUNT
,      BANK_CHARGE_BEARER
,      ORG_ID
,      CHECK_DIGITS
,      ADDRESS_LINE4
,      ALLOW_AWT_FLAG
,      AWT_GROUP_ID
,      PAY_AWT_GROUP_ID
,      DEFAULT_PAY_SITE_ID
,      PAY_ON_CODE
,      PAY_ON_RECEIPT_SUMMARY_CODE
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      TP_HEADER_ID
,      ECE_TP_LOCATION_CODE
,      PCARD_SITE_FLAG
,      MATCH_OPTION
,      COUNTRY_OF_ORIGIN_CODE
,      FUTURE_DATED_PAYMENT_CCID
,      CREATE_DEBIT_MEMO_FLAG
,      SUPPLIER_NOTIF_METHOD
,      EMAIL_ADDRESS
,      PRIMARY_PAY_SITE_FLAG
,      SHIPPING_CONTROL
,      SELLING_COMPANY_IDENTIFIER
,      GAPLESS_INV_NUM_FLAG
,      DUNS_NUMBER
,      LOCATION_ID
,      PARTY_SITE_ID
,      TOLERANCE_ID
,      SERVICES_TOLERANCE_ID
,      PAYMENT_METHOD_LOOKUP_CODE
,      BANK_ACCOUNT_NAME
,      BANK_ACCOUNT_NUM
,      BANK_NUM
,      BANK_ACCOUNT_TYPE
,      CURRENT_CATALOG_NUM
,      VAT_CODE
,      AP_TAX_ROUNDING_RULE
,      AUTO_TAX_CALC_FLAG
,      AUTO_TAX_CALC_OVERRIDE
,      AMOUNT_INCLUDES_TAX_FLAG
,      OFFSET_VAT_CODE
,      BANK_NUMBER
,      BANK_BRANCH_TYPE
,      OFFSET_TAX_FLAG
,      REMITTANCE_EMAIL
,      EDI_TRANSACTION_HANDLING
,      EDI_ID_NUMBER
,      EDI_PAYMENT_METHOD
,      EDI_PAYMENT_FORMAT
,      EDI_REMITTANCE_METHOD
,      EDI_REMITTANCE_INSTRUCTION
,      EXCLUSIVE_PAYMENT_FLAG
,      RETAINAGE_RATE
,      VAT_REGISTRATION_NUM
,      LANGUAGE_CODE
,      CAGE_CODE
,      LEGAL_BUSINESS_NAME
,      DOING_BUS_AS_NAME
,      DIVISION_NAME
,      SMALL_BUSINESS_CODE
,      CCR_COMMENTS
,      DEBARMENT_START_DATE
,      DEBARMENT_END_DATE
,      STATUS
,      END_DATE_ACTIVE
FROM APPS.PO_VENDOR_SITES;

Dependencies

[top of page]

APPS.PO_VENDOR_SITES references the following:

SchemaAPPS
ViewAP_LOOKUP_CODES
SynonymAP_SUPPLIER_SITES
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymHZ_LOCATIONS
SynonymHZ_PARTY_SITES
APPS.PO_VENDOR_SITES is referenced by following:

SchemaAPPS
Package BodyAHL_OSP_ORDERS_PVT - show dependent code
Package BodyAHL_OSP_PO_PVT - show dependent code
Package BodyAHL_OSP_PO_REQ_PVT - show dependent code
ViewAHL_VENDOR_CUSTOMER_RELS_V
Package BodyAP_1099_UTILITIES_PKG - show dependent code
Package BodyAP_APXFPMDR_XMLP_PKG - show dependent code
Package BodyAP_APXKIRKI_XMLP_PKG - show dependent code
Package BodyAP_APXT7UTT_XMLP_PKG - show dependent code
Package BodyAP_AUTO_DM_CREATION_PKG - show dependent code
Package BodyAP_CREATE_PAY_SCHEDS_PKG - show dependent code
Package BodyAP_CUSTOM_INT_INV_PKG - show dependent code
ViewAP_DUPLICATE_VENDORS_V
Package BodyAP_IMPORT_UTILITIES_PKG - show dependent code
Package BodyAP_IMPORT_VALIDATION_PKG - show dependent code
Package BodyAP_INTEREST_INVOICE_PKG - show dependent code
ViewAP_INVOICES_INTERFACE_V
Package BodyAP_INVOICES_POST_PROCESS_PKG - show dependent code
ViewAP_INVOICES_UNION_PREPAYS_V
ViewAP_INVOICES_WWW_V
Package BodyAP_INVOICE_CORRECTIONS_PKG - show dependent code
ViewAP_INVOICE_DISTS_INQUIRY_V
Package BodyAP_INVOICE_LINES_PKG - show dependent code
ViewAP_INVOICE_PREPAYS_V
Package BodyAP_MATCHING_PKG - show dependent code
Package BodyAP_PO_AMT_MATCH_PKG - show dependent code
Package BodyAP_PO_GAPLESS_SBI_PKG - show dependent code
Package BodyAP_RCT_AMT_MATCH_PKG - show dependent code
Package BodyAP_RECT_MATCH_PKG - show dependent code
Package BodyAP_RECURRING_INVOICES_PKG - show dependent code
Package BodyAP_REPORTS_MLS_LANG - show dependent code
Package BodyAP_UPDATE_1099_AWT_DISTS_PKG - show dependent code
Package BodyAP_UTILITIES_PKG - show dependent code
Package BodyAP_VENDORS_PKG - show dependent code
ViewAP_VENDOR_DISP_V
Package BodyAP_VENDOR_PUB_PKG - show dependent code
Package BodyAP_VENDOR_SITES_PKG - show dependent code
ViewAP_VENDOR_SITES_V
Package BodyAP_WEB_DB_PO_INT_PKG - show dependent code
Package BodyAP_WFAPPROVAL_PKG - show dependent code
Package BodyAP_WITHHOLDING_PKG - show dependent code
Package BodyCHV_BUILD_SCHEDULES - show dependent code
ViewCHV_CUM_ITEMS_HISTORY_V
ViewCHV_CUM_ITEMS_V
Package BodyCHV_LOAD_ORDERS - show dependent code
ViewCHV_SCHEDULE_HEADERS_ALL_V
ViewCHV_SCHEDULE_HEADERS_V
ViewCHV_SCHEDULE_HEADERS_VAL_V
Package BodyCN_PAYRUN_PVT - show dependent code
ViewECE_MVSTO_LOCATIONS_V
ViewECE_POCO_HEADERS_V
ViewECE_POO_HEADERS_V
ViewECE_SPSO_HEADERS_V
Package BodyECE_SPSO_TRANS1 - show dependent code
Package BodyECE_SPSO_TRANS2 - show dependent code
ViewECE_SSSO_HEADERS_V
Package BodyECE_TRADING_PARTNERS_PUB - show dependent code
ViewECX_TP_HEADERS_V
Package BodyEC_INBOUND_STAGE - show dependent code
Package BodyEC_TRADING_PARTNER_PVT - show dependent code
Package BodyFV_CROSS_DOC_REF - show dependent code
PL/SQL PackageFV_CROSS_DOC_REF - show dependent code
Package BodyFV_IPAC_DISBURSEMENT_PKG - show dependent code
Package BodyFV_THIRD_PARTY_REMIT_PKG - show dependent code
Package BodyGHG_PO_EMISSIONS_PKG - show dependent code
ViewGHG_SOURCE_COMB_MEANING_V
Package BodyGHG_TRANSACTIONS_API_PKG - show dependent code
ViewGHG_TRANSACTION_BATCHES_V
ViewICX_AP_EXPENSE_REPORTS_V
ViewICX_AP_INVOICES_V
ViewICX_PLAN_SCHEDULE_HEADERS_V
ViewICX_POR_SEARCH_ASLS_V
ViewICX_POR_SEARCH_CONTRACTS_V
ViewICX_POS_QA_SHIPMENTS_V
ViewICX_PO_HDR_ARCHIVE_OPEN_V
ViewICX_PO_HEADERS_ARCHIVE_V
ViewICX_PO_LATE_RECEIPTS_V
ViewICX_PO_REQUISITION_TEMPLATES_V
ViewICX_PO_REQ_TEMPLATE_ITEMS_V
ViewICX_PO_RFQ_HEADERS_V
ViewICX_PO_SUPPLIER_AGREEMENTS_V
ViewICX_PO_SUPPLIER_CATALOGS_V
ViewICX_PO_SUPPLIER_INFO_V
ViewICX_PO_SUPPLIER_ORDERS_V
ViewICX_PO_SUPPL_CATALOG_ITEMS_V
ViewICX_PO_SUPPL_CAT_ITEMS_V
ViewICX_PO_SUPPL_SEARCH_ITEMS_V
ViewICX_PO_SUP_ORDER_INVOICES_V
ViewICX_RCV_ACCEPTED_ITEMS_V
ViewICX_RCV_EARLY_LATE_RECEIPTS_V
ViewICX_RCV_REJECTED_ITEMS_V
ViewICX_RCV_RETURNS_V
ViewICX_RCV_TRANSACTIONS_V
ViewICX_RECEIPT_HEADERS_V
Package BodyICX_REQ_TEMPLATES - show dependent code
ViewICX_SHIP_SCHEDULE_HEADERS_V
Package BodyIGC_ETAX_UTIL_PKG - show dependent code
PL/SQL PackageIGC_ETAX_UTIL_PKG - show dependent code
ViewIGI_CIS_CERT_INV_PMT_VCH_V
Package BodyIGI_CIS_CI36_DATA_PKG - show dependent code
Package BodyIGI_CIS_UPDC - show dependent code
ViewIGI_EXP_AP_INV_V
Package BodyINL_INTEGRATION_GRP - show dependent code
ViewINL_SHIP_PO_OVERALL_V
Package BodyINL_TAX_PVT - show dependent code
Package BodyINV_KANBAN_PKG - show dependent code
Package BodyINV_LABEL_PVT1 - show dependent code
Package BodyINV_LABEL_PVT4 - show dependent code
Package BodyINV_LABEL_PVT5 - show dependent code
ViewJL_BR_AP_COLLECTION_DOCS_V
ViewJL_BR_AP_CONSOLID_INVOICES_V
Package BodyJL_BR_AP_VALIDATE_COLLECTION - show dependent code
Package BodyJL_ZZ_AP_LIBRARY_1_PKG - show dependent code
ViewMRPBV_PLAN_ITEM_SOURCES
ViewMRPFV_PLAN_ITEM_SOURCES
ViewMRP_ITEM_SOURCING_V
ViewOKL_CURE_REFUNDS_HDRS_UV
ViewOKL_CURE_RFND_DTLS_UV
Package BodyOKL_INVESTOR_INVOICE_DISB_PVT - show dependent code
ViewOKL_LESSEE_AS_VENDORS_UV
ViewOKL_LINE_VENDORS_SITES_UV
ViewOKL_PARTY_PAYMENT_DTLS_UV
Package BodyOKL_PAY_CURE_REFUNDS_PVT - show dependent code
Package BodyOKL_PAY_INVOICES_DISB_PVT - show dependent code
Package BodyOKL_PROCESS_SALES_TAX_PVT - show dependent code
ViewOKL_VENDOR_SITES_UV
ViewOKX_RESOURCES_V
Package BodyOZF_AP_INTERFACE_PVT - show dependent code
Package BodyOZF_AR_SETTLEMENT_PVT - show dependent code
Package BodyOZF_AUTOPAY_PVT - show dependent code
Package BodyOZF_CLAIM_ACCRUAL_PVT - show dependent code
Package BodyOZF_CLAIM_PVT - show dependent code
Package BodyOZF_CLAIM_SETTLEMENT_VAL_PVT - show dependent code
Package BodyOZF_CLAIM_TAX_PVT - show dependent code
Package BodyOZF_TRADE_PROFILE_PVT - show dependent code
Package BodyPER_QH_FIND_QUERY - show dependent code
Package BodyPNRX_RENT_INCREASE_DETAIL - show dependent code
Package BodyPNRX_RENT_LES - show dependent code
Package BodyPN_EXP_TO_AP - show dependent code
Package BodyPOR_CONTRACTOR_NOTIFY - show dependent code
Package BodyPOR_HISTORY_FEED_PKG - show dependent code
ViewPOR_LINES_V
ViewPOR_RCV_MY_PURCHASE_ITEMS_V
ViewPOR_RCV_ORD_REQUESTER_V
ViewPOR_RCV_PURCHASE_ITEMS_V
ViewPOR_RCV_SHIPMENTS_V
Package BodyPOR_RCV_TRANSACTION_SV - show dependent code
ViewPOR_RECEIVE_ORDERS_V
ViewPOR_SUPPLIER_LOV_V
ViewPOR_VIEW_LINES_V
Package BodyPOS_ACK_SEARCH - show dependent code
ViewPOS_ACK_SELECT_V
ViewPOS_ACK_SITE_LOV_V
ViewPOS_ASN_HEADERS_V
ViewPOS_ASN_PO_SHIPMENTS_V
ViewPOS_ASN_REVIEW_HEADERS_V
Package BodyPOS_ASN_SEARCH_PKG - show dependent code
ViewPOS_ASN_SHIPMENT_DETAILS_V
ViewPOS_ASN_SITE_LOV_V
Package BodyPOS_HEADER_INFO_S - show dependent code
ViewPOS_UPD_DATE_PO_SHIP_V
Package BodyPO_APPROVAL_REMINDER_SV - show dependent code
ViewPO_APPROVED_SUPPLIER_LIST_V
Package BodyPO_AP_MERGE_GRP - show dependent code
Package BodyPO_AP_PURGE_PVT - show dependent code
ViewPO_ASL_SUPPLIERS_V
Package BodyPO_AUTOCREATE_DOC - show dependent code
Package BodyPO_AUTOSOURCE_SV - show dependent code
Package BodyPO_COMMUNICATION_PVT - show dependent code
Package BodyPO_COPYDOC_S1 - show dependent code
Package BodyPO_COPYDOC_S4 - show dependent code
Package BodyPO_COPYDOC_SUB - show dependent code
Package BodyPO_CREATE_ASBN_INVOICE - show dependent code
Package BodyPO_DIFF_SUMMARY_PKG - show dependent code
Package BodyPO_DOCUMENT_CHECKS_PVT - show dependent code
Package BodyPO_DOCUMENT_UPDATE_PVT - show dependent code
Package BodyPO_EMAIL_GENERATE - show dependent code
ViewPO_HEADERS_CHANGE_PRINT
Package BodyPO_INTERFACE_S - show dependent code
Package BodyPO_INVOICES_SV1 - show dependent code
PL/SQL PackagePO_INVOICES_SV2 - show dependent code
Package BodyPO_INVOICES_SV2 - show dependent code
Package BodyPO_NEGOTIATIONS4_PVT - show dependent code
Package BodyPO_PDOI_HEADER_PROCESS_PVT - show dependent code
Package BodyPO_PDOI_LINE_LOC_PROCESS_PVT - show dependent code
Package BodyPO_RELGEN_PKG - show dependent code
Package BodyPO_REQAPPROVAL_INIT1 - show dependent code
Package BodyPO_REQIMP_PKG - show dependent code
Package BodyPO_REQ_TEMPLATE_SV2 - show dependent code
Package BodyPO_REQ_TEMPLATE_SV3 - show dependent code
Package BodyPO_RETROACTIVE_PRICING_PVT - show dependent code
ViewPO_RFQ_VENDORS_V
Package BodyPO_SHIPMENTS_SV8 - show dependent code
Package BodyPO_SOURCING_PVT - show dependent code
ViewPO_SUPPLIER_PO_SITES_VAL_V
ViewPO_SUPPLIER_SITES_ALL_V
ViewPO_SUPPLIER_SITES_VAL_V
Package BodyPO_THIRD_PARTY_STOCK_GRP - show dependent code
Package BodyPO_VENDORMERGE_GRP - show dependent code
ViewPO_VENDOR_LIST_ENTRIES_V
ViewPO_VENDOR_SITES_ALL_V
Package BodyPO_VENDOR_SITES_SV - show dependent code
Package BodyPO_VMI_GRP - show dependent code
Package BodyPSA_AP_BC_PVT - show dependent code
Package BodyPSA_BC_XML_REPORT_PUB - show dependent code
Package BodyQLTDACTB - show dependent code
Package BodyRCV_824_SV - show dependent code
ViewRCV_AEL_SL_MRC_V
ViewRCV_AEL_SL_V
Package BodyRCV_DEFAULT_PKG - show dependent code
ViewRCV_MSH_V
ViewRCV_MSL_V
Package BodyRCV_ROI_TRANSACTION - show dependent code
PL/SQL PackageRCV_SHIPMENT_HEADER_SV - show dependent code
Package BodyRCV_TRANSACTIONS_INTERFACE_SV - show dependent code
ViewRCV_VRC_TXS_INT_V
ViewRCV_VRC_TXS_V
ViewRCV_VRC_TXS_VENDINT_V
Package BodyWSH_VENDOR_PARTY_MERGE_PKG - show dependent code
Package BodyZX_AP_TAX_CLASSIFICATN_DEF_PKG - show dependent code
PL/SQL PackageZX_AP_TAX_CLASSIFICATN_DEF_PKG - show dependent code
Package BodyZX_TEST_API - show dependent code