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


VIEW: APPS.PO_VENDOR_SITES_ALL

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

[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
LAST_UPDATED_BY NUMBER
Yes
VENDOR_ID NUMBER
Yes
VENDOR_SITE_CODE VARCHAR2 (15)
VENDOR_SITE_CODE_ALT VARCHAR2 (320)
LAST_UPDATE_LOGIN NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
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)
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
REQUEST_ID NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

VALIDATION_NUMBER NUMBER

EXCLUDE_FREIGHT_FROM_DISCOUNT VARCHAR2 (1)
BANK_CHARGE_BEARER VARCHAR2 (1)
ORG_ID NUMBER

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

ECE_TP_LOCATION_CODE VARCHAR2 (60)
PCARD_SITE_FLAG VARCHAR2 (1)
MATCH_OPTION VARCHAR2 (25)
COUNTRY_OF_ORIGIN_CODE VARCHAR2 (2)
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)
SHIPPING_CONTROL VARCHAR2 (30)
SELLING_COMPANY_IDENTIFIER VARCHAR2 (10)
GAPLESS_INV_NUM_FLAG VARCHAR2 (1)
DUNS_NUMBER VARCHAR2 (30)
LOCATION_ID NUMBER (15)
PARTY_SITE_ID NUMBER (15)
TOLERANCE_ID NUMBER (15)
SERVICES_TOLERANCE_ID NUMBER (15)
RETAINAGE_RATE NUMBER

EDI_ID_NUMBER VARCHAR2 (30)
VAT_REGISTRATION_NUM VARCHAR2 (20)
LANGUAGE_CODE VARCHAR2 (4)
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)
EDI_TRANSACTION_HANDLING VARCHAR2 (25)
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)
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
,      RETAINAGE_RATE
,      EDI_ID_NUMBER
,      VAT_REGISTRATION_NUM
,      LANGUAGE_CODE
,      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_PAYMENT_METHOD
,      EDI_PAYMENT_FORMAT
,      EDI_REMITTANCE_METHOD
,      EDI_REMITTANCE_INSTRUCTION
,      EXCLUSIVE_PAYMENT_FLAG
,      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_ALL;

Dependencies

[top of page]

APPS.PO_VENDOR_SITES_ALL references the following:

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

SchemaAPPS
ViewAHL_OSP_ORDERS_V
Package BodyAHL_OSP_SHIPMENT_PUB - show dependent code
ViewAHL_OWNER_LOCATIONS_V
Package BodyAHL_UTIL_UC_PKG - show dependent code
ViewAHL_VENDOR_CERTIFICATIONS_V
ViewAP_APPLY_PREPAYS_FR_PREPAY_V
ViewAP_APPLY_PREPAYS_V
Package BodyAP_AUTOSELECT_PKG - show dependent code
Package BodyAP_ETAX_SERVICES_PKG - show dependent code
Package BodyAP_GET_SUPPLIER_BALANCE_PKG - show dependent code
Package BodyAP_IAW_PKG - show dependent code
Package BodyAP_IMPORT_UTILITIES_PKG - show dependent code
Package BodyAP_IMPORT_VALIDATION_PKG - show dependent code
Package BodyAP_INVOICES_UTILITY_PKG - show dependent code
ViewAP_INVOICES_V
Package BodyAP_ISP_UTILITIES_PKG - show dependent code
Package BodyAP_PAYMENT_EVENT_WF_PKG - show dependent code
Package BodyAP_PO_GAPLESS_SBI_PKG - show dependent code
ViewAP_PO_SHIPMENTS_V
Package BodyAP_PURGE_PKG - show dependent code
ViewAP_RECEIPT_CORRECTIONS_V
Package BodyAP_RETRO_PRICING_PKG - show dependent code
Package BodyAP_TAX_ENGINE_PKG - show dependent code
PL/SQL PackageAP_TAX_ENGINE_PKG - show dependent code
ViewAP_UNAPPLY_PREPAYS_FR_PREPAY_V
ViewAP_UNAPPLY_PREPAYS_V
Package BodyAP_VENDOR_PUB_PKG - show dependent code
ViewAP_VENDOR_SITES_V
ViewAP_VIEW_PREPAYS_V
Package BodyAP_WITHHOLDING_PKG - show dependent code
Package BodyAP_WORKFLOW_PKG - show dependent code
Package BodyAP_XML_INVOICE_INBOUND_PKG - show dependent code
ViewCE_AP_FC_DISC_INVOICES_V
ViewCE_AP_FC_PAYMENTS_V
ViewCE_PO_FC_NO_TERMS_TEMP_V
ViewCE_PO_FC_ORDERS_NO_TERMS_V
ViewCE_PO_FC_ORDERS_TEMP_V
ViewCE_PO_FC_ORDERS_TERMS_TEMP_V
ViewCE_PO_FC_ORDERS_TERMS_V
Package BodyCHV_BUILD_SCHEDULES - show dependent code
Package BodyCHV_LOAD_ORDERS - show dependent code
Package BodyCLN_NTFYINVC_PKG - show dependent code
Package BodyCLN_PO_SYNC_CAT_PKG - show dependent code
Package BodyCLN_RN_UTILS - show dependent code
ViewCLN_RN_UTIL_TO_ROLE_SUPPLIER_V
Package BodyCLN_SYNC_ITEM_PKG - show dependent code
ViewCSI_INSTALLED_BASE_V
ViewCSI_INST_CURRENT_LOCATION_V
ViewCSI_INST_INSTALL_LOCATION_V
Package BodyCSI_ITEM_INSTANCE_PVT - show dependent code
Package BodyCSI_ITEM_INSTANCE_VLD_PVT - show dependent code
ViewCSI_PARTY_CONTACT_DETAILS_V
Package BodyCSI_PARTY_RELATIONSHIPS_PVT - show dependent code
ViewCSI_T_PARTY_CONTACTS_V
Package BodyCSI_UTILITY_GRP - show dependent code
ViewCST_MTL_RCV_TXN_V
ViewCST_PAC_AEL_GL_RCV_V
ViewCST_PAC_AEL_SL_RCV_V
ViewCST_RCV_RAE_V
Package BodyCTO_AUTO_PROCURE_PK - show dependent code
Package BodyCTO_MSUTIL_PUB - show dependent code
Package BodyCTO_OSS_SOURCE_PK - show dependent code
Package BodyEAM_ASSET_LOG_PVT - show dependent code
ViewEAM_WORK_ORDER_DIRECT_ITEMS_V
ViewEAM_WORK_ORDER_REQ_PO_V
Package BodyECE_RULES_PKG - show dependent code
Package BodyECE_TRADING_PARTNERS_PUB - show dependent code
Package BodyECX_TP_API - show dependent code
Package BodyECX_TP_SYNCH - show dependent code
ViewFA_INS_MST_POLS_V
ViewFA_INS_POLICIES_V
ViewFA_LEASES_V
ViewFA_LEASE_PAYMENT_ITEMS_V
PL/SQL PackageFA_LEASE_PVT - show dependent code
Package BodyFA_LEASE_PVT - show dependent code
Package BodyFA_LPITEMS_EXPT_PKG - show dependent code
Package BodyFTE_FPA_UTIL - show dependent code
Package BodyFTE_MLS_UTIL - show dependent code
Package BodyFUN_NET_ARAP_PKG - show dependent code
Package BodyFUN_NET_EXTRACT_PKG - show dependent code
Package BodyFUN_TRADING_RELATION - show dependent code
PL/SQL PackageFUN_VENDOR_PVT_PKG - show dependent code
Package BodyFUN_XML_REPORT_PKG - show dependent code
Package BodyFV_CCR_UTIL_PVT - show dependent code
ViewGHG_ASSETS_V
ViewGHG_TRANSACTIONS_HISTORY_V
ViewGHG_TRANSACTIONS_V
Package BodyGMD_OUTBOUND_APIS_PUB - show dependent code
Package BodyGMD_QC_ERES_UTILS - show dependent code
ViewGMD_QC_E_SUPP_SAMPLE_DTLS_V
ViewGMD_QC_E_SUPP_SMPEVT_DTLS_V
Package BodyGMD_QC_LABELS_UTIL - show dependent code
Package BodyGMD_QC_MIG12 - show dependent code
Package BodyGMD_SAMPLES_GRP - show dependent code
Package BodyGMD_SAMPLES_PUB - show dependent code
Package BodyGMD_SPEC_VRS_GRP - show dependent code
Package BodyGMF_SYNC_VENDOR - show dependent code
ViewGMF_XLA_RCV_VENDOR_V
ViewGMF_XLA_VENDOR_V
Package BodyGMI_GMILTGEN_XMLP_PKG - show dependent code
Package BodyGML_PO_INTERFACE - show dependent code
Package BodyHR_ASSIGNMENT - show dependent code
PL/SQL PackageHR_ASSIGNMENT - show dependent code
Package BodyHR_ASSIGNMENT_API - show dependent code
Package BodyHR_PROCESS_ASSIGNMENT_SS - show dependent code
Package BodyHZ_PURGE_GEN - show dependent code
Package BodyIBU_DYN_USER_GROUPS_PKG - show dependent code
Package BodyIBY_EXTRACTGEN_PVT - show dependent code
ViewIBY_EXT_FD_PAYEE_1_0_V
Package BodyICX_CAT_FPI_UPGRADE - show dependent code
Package BodyICX_CAT_R12_UPGRADE_PVT - show dependent code
ViewICX_EDM_PO_BLANKET_REL_V
ViewICX_EDM_PURCHASE_ORDER_V
ViewICX_POR_EXT_CONTRACTS
Package BodyICX_POR_JOB_TRACK_VALIDATION_S - show dependent code
ViewICX_POR_REQ_ASLS
ViewICX_POR_REQ_TEMPLATES
ViewICX_SUPPLIER_ACCOUNT_V
ViewICX_SUPPLIER_CONTACT_LOV
ViewICX_SUPPLIER_SAV_DEFAULTS_V
ViewICX_SUPPLIER_SITE_LOV_V
Package BodyICX_SUPP_CUSTOM - show dependent code
Package BodyIEX_OPI_PVT - show dependent code
Package BodyIEX_REP_PVT - show dependent code
ViewIGCFV_CC_CONTRACT_COMMITMENTS
ViewIGCFV_CC_RELEASES
Package BodyIGC_CC_COMMON_UTILS_PVT - show dependent code
ViewIGC_CC_HEADERS_V
Package BodyIGC_CC_OPEN_INTERFACE_PKG - show dependent code
Package BodyIGC_CC_OPN_UPD_GET_LNK_PUB - show dependent code
Package BodyINL_INTEGRATION_GRP - show dependent code
ViewINL_PO_SOURCE_LINES_V
Package BodyINL_SHIPMENT_PVT - show dependent code
Package BodyINL_TCAMERGE_GRP - show dependent code
ViewINVFV_KANBAN_CARDS
ViewINVFV_KANBAN_CARD_ACTIVITIES
ViewINVFV_KANBAN_LOCATION_ITEMS
Package BodyINV_CONSIGNED_DIAGNOSTICS_PROC - show dependent code
Package BodyINV_CONSUMPTION_ADVICE_PROC - 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
Package BodyINV_MGD_MVT_UTILS_PKG - show dependent code
Package BodyINV_MWB_QUERY_MANAGER - show dependent code
Package BodyINV_PO_THIRD_PARTY_STOCK_MDTR - show dependent code
Package BodyINV_THIRD_PARTY_STOCK_PVT - show dependent code
Package BodyINV_THIRD_PARTY_STOCK_UTIL - show dependent code
Package BodyINV_TRANSACTION_FLOW_PUB - show dependent code
Package BodyINV_UTILITIES - show dependent code
Package BodyINV_VIEW_MTL_TXN - show dependent code
ViewITG_LPI_HEADERS_V
ViewITG_PO_HEADER_ARCH_V
ViewITG_REQ_VENDOR_SITES_V
ViewITG_SP_PO_PART_SUPPL_V
ViewITG_SP_REL_PART_SUPPL_V
ViewITG_UPDEL_HEADERS_V
ViewJAI_AP_BOE_AEL_V
Package BodyJAI_AP_DTC_DEFAULTATION_PKG - show dependent code
Package BodyJAI_AP_DTC_GENERATION_PKG - show dependent code
Package BodyJAI_AP_DVA_TRIGGER_PKG - show dependent code
Package BodyJAI_AP_ILA_TRIGGER_PKG - show dependent code
ViewJAI_AP_MANUAL_AEL_V
Package BodyJAI_AP_MATCH_TAX_PKG - show dependent code
Package BodyJAI_AP_MATCH_TAX_PROC_PKG - show dependent code
Package BodyJAI_AP_RPT_APCR_PKG - show dependent code
ViewJAI_AP_SET_AEL_V
ViewJAI_AP_STREVIEW_AEL_V
Package BodyJAI_AP_ST_REVERSE_PROCESS - show dependent code
Package BodyJAI_AP_TDS_ETDS_PKG - show dependent code
Package BodyJAI_AP_TDS_GENERATION_PKG - show dependent code
Package BodyJAI_AP_TDS_POP_RPST_PKG - show dependent code
Package BodyJAI_AP_TDS_TAX_DEFAULTATION - show dependent code
ViewJAI_AP_TDS_TH_VSITE_V
Package BodyJAI_AP_UTILS_PKG - show dependent code
ViewJAI_BOE_HEADERS_V
ViewJAI_CMN_CESS_TRXS_V
Package BodyJAI_CMN_MTAX_PKG - show dependent code
Package BodyJAI_CMN_RGM_SETTLEMENT_PKG - show dependent code
ViewJAI_CMN_VENDOR_ADDRESS_V
Package BodyJAI_FBT_PAYMENT_P - show dependent code
Package BodyJAI_FBT_SETTLEMENT_P - show dependent code
ViewJAI_PLA_ENTRY_AEL_V
Package BodyJAI_PO_HOOK_PKG - show dependent code
Package BodyJAI_PO_OSP_PKG - show dependent code
PL/SQL PackageJAI_PO_OSP_PKG - show dependent code
Package BodyJAI_PO_PROC_PKG - show dependent code
ViewJAI_PO_REC_AEL_V
ViewJAI_PO_REC_CENVAT_AEL_V
ViewJAI_PO_REC_MTL_AEL_V
ViewJAI_PO_REC_VAT_AEL_V
ViewJAI_PO_REC_VENDOR_AEL_V
Package BodyJAI_PO_RLA_TRIGGER_PKG - show dependent code
ViewJAI_PO_SUMMARY_V
PL/SQL PackageJAI_RCV_RGM_CLAIMS_PKG - show dependent code
Package BodyJAI_RCV_RGM_CLAIMS_PKG - show dependent code
Package BodyJAI_RCV_THIRD_PARTY_PKG - show dependent code
Package BodyJA_CN_COA_EXP_PKG - show dependent code
Package BodyJA_JAIN23D_XMLP_PKG - show dependent code
Package BodyJA_JAINCTRB_XMLP_PKG - show dependent code
Package BodyJA_JAINER1_XMLP_PKG - show dependent code
Package BodyJA_JAINITCL_XMLP_PKG - show dependent code
Package BodyJA_JAINITCP_XMLP_PKG - show dependent code
Package BodyJA_JAINOTDS_XMLP_PKG - show dependent code
Package BodyJA_JAINPROS_XMLP_PKG - show dependent code
Package BodyJA_JAINPRRG_XMLP_PKG - show dependent code
Package BodyJA_JAINST3_XMLP_PKG - show dependent code
Package BodyJERX_TO - show dependent code
Package BodyJE_ES_WHTAX - show dependent code
Package BodyJE_IL_TAX_PKG - show dependent code
Package BodyJE_IT_INVOICES_ABOVE_THRESHOLD - show dependent code
ViewJG_ZZ_AP_IR_REP_ITF_V
Package BodyJL_AR_APPLICABLE_TAXES - show dependent code
Package BodyJMF_SHIKYU_AUTO_RCV_PROC - show dependent code
Package BodyJMF_SHIKYU_RPT_CFR_PVT - show dependent code
Package BodyJMF_SHIKYU_RPT_CUR_PVT - show dependent code
Package BodyJMF_SHIKYU_RPT_SPR_PVT - show dependent code
Package BodyJTF_RS_CONC_RES_PUB - show dependent code
ViewJTF_RS_SUPPLIERS_VL
ViewMRPBV_PLAN_ITEM_CAPACITIES
ViewMRPBV_PLAN_ITEM_FLEX_FENCES
ViewMRPBV_PLAN_ITEM_SUPPLIERS
ViewMRPFV_PLAN_ITEM_CAPACITIES
ViewMRPFV_PLAN_ITEM_FLEX_FENCES
ViewMRPFV_PLAN_ITEM_SUPPLIERS
ViewMRPFV_PLAN_SUPPLIES
ViewMRPFV_REPLENISHMENT_SOURCES
Package BodyMRP_AP_REL_PLAN_PUB - show dependent code
Package BodyMRP_CL_FUNCTION - show dependent code
ViewMRP_CUST_SUP_ORG_V
Package BodyMRP_EXCEPTION_SC - show dependent code
Package BodyMRP_EXP_WF - show dependent code
Package BodyMRP_GET_PROJECT - show dependent code
ViewMRP_KANBAN_DETAILS_V
Package BodyMRP_MAP_REG_SITE - show dependent code
Package BodyMRP_REL_PLAN_PUB - show dependent code
ViewMRP_SCATP_SUPPLY_SOURCES_V
ViewMRP_SC_BILL_SF_V
ViewMRP_SC_BILL_WU_V
Package BodyMRP_SOURCING_API_PK - show dependent code
Package BodyMRP_SOURCING_GRP - show dependent code
ViewMRP_SR_SOURCE_ORG_V
Package BodyMRP_VALIDATE_SHIPPING_ORG - show dependent code
ViewMRP_WEB_PLANNED_SUPPLY_V
Package BodyMSC_X_VMI_POREQ - show dependent code
ViewMSD_SR_LOC_SUP_V
ViewMTL_CONSUMPTION_DEFINITION_V
ViewMTL_EAM_ASSET_NUMBERS_ALL_V
ViewMTL_INTERCOMPANY_PARAMETERS_V
ViewMTL_SUPPLIER_SITES_V
Package BodyOKC_REP_UTIL_PVT - show dependent code
ViewOKE_DELIVERABLE_PURCHASING_V
ViewOKE_DTS_PAYABLES_V
ViewOKE_DTS_PURCHASING_V
ViewOKE_VENDOR_SITES_V
Package BodyOKL_AM_VENDOR_RES_SHARE_PVT - show dependent code
ViewOKL_BPD_AP_DISB_DTLS_UV
ViewOKL_BPD_DISB_LOV_UV
ViewOKL_BPD_VENDOR_SITES_V
Package BodyOKL_CO_WF - show dependent code
Package BodyOKL_CREATE_DISB_TRANS_PVT - show dependent code
ViewOKL_CS_DIS_ADDRESS_UV
ViewOKL_CS_PAY_INVOICES_UV
ViewOKL_CS_VENDORS_UV
ViewOKL_CS_VENDOR_CONTACTS_UV
ViewOKL_CURE_HEADER_UV
ViewOKL_CURE_REFUNDS_SUMRY_UV
Package BodyOKL_CURE_REQUEST_PVT - show dependent code
ViewOKL_CURE_RFND_DTLS_UV
ViewOKL_CURE_VENDOR_SUMRY_UV
Package BodyOKL_EXT_BILLING_CHARGES_PVT - show dependent code
Package BodyOKL_FUNDING_PVT - show dependent code
Package BodyOKL_FUNDING_WF - show dependent code
ViewOKL_FUND_REQ_HEADERS_UV
ViewOKL_LA_PASSTHRU_VENDOR_UV
ViewOKL_LA_VENDOR_PAYMENTS_UV
Package BodyOKL_OPEN_INTERFACE_PVT - show dependent code
ViewOKL_OR_SUBSIDY_REFUNDS
Package BodyOKL_PAY_CURE_REFUNDS_PVT - show dependent code
PL/SQL PackageOKL_PAY_CURE_REFUNDS_PVT - show dependent code
Package BodyOKL_PAY_INVOICES_CONS_PVT - show dependent code
Package BodyOKL_PAY_INVOICES_TRANS_PVT - show dependent code
Package BodyOKL_PYD_PVT - show dependent code
Package BodyOKL_REQ_WF - show dependent code
Package BodyOKL_STRY_CALL_CO_PUB - show dependent code
Package BodyOKL_TBC_PVT - show dependent code
ViewOKS_AUTH_SHOWALL_PROD_V
Package BodyOKS_AUTH_UTIL_PVT - show dependent code
Package BodyOKS_ENTITLEMENTS_PVT - show dependent code
Package BodyOKS_ENTITLEMENTS_WEB - show dependent code
ViewOKS_PRODUCT_DETAILS_V
ViewOKX_VENDOR_CONTACTS_V
ViewOKX_VENDOR_SITES_V
ViewOTA_VENDOR_ADDRESSES_V
ViewOTA_VENDOR_CONTACTS_V
ViewOTFV_FINANCE_HEADERS
Package BodyPAAP_PWP_PKG - show dependent code
Package BodyPA_CC_AR_AP_TRANSFER - show dependent code
Package BodyPA_DCTN_APRV_NOTIFICATION - show dependent code
Package BodyPA_DEDUCTIONS - show dependent code
ViewPA_PRVDR_CC_ORG_REL_V
Package BodyPER_ASG_BUS3 - show dependent code
ViewPER_ASSIGNMENTS_V
ViewPER_ASSIGNMENTS_V13
ViewPER_ASSIGNMENTS_V2
Package BodyPER_QH_FIND_QUERY - show dependent code
PL/SQL PackagePER_QH_FIND_QUERY - show dependent code
Package BodyPER_QH_MAINTAIN_QUERY - show dependent code
PL/SQL PackagePER_QH_MAINTAIN_QUERY - show dependent code
PL/SQL PackagePER_QH_SUMMARY_QUERY - show dependent code
Package BodyPJM_INQUIRY - show dependent code
ViewPJM_PROJECT_RFQ_V
ViewPMIBV_LOT_LIST_V
ViewPMIBV_LOT_SOURCE_PURCH_V
ViewPMIFV_LOT_LIST_V
ViewPMIFV_LOT_SOURCE_PURCH_V
ViewPMITS_QC_SAMPLES_V
ViewPN_AEL_PAY_GL_V
ViewPN_EXCLUDE_TERMS_V
Package BodyPN_LEASE_UTILS - show dependent code
ViewPN_PAYMENT_ITEMS_V
ViewPN_PAYMENT_TERMS_HISTORY_V
ViewPN_PAYMENT_TERMS_V
Package BodyPN_R12_UTIL_PKG - show dependent code
ViewPN_TERM_TEMPLATES_V
ViewPN_TRX_LEASE_EXPENSE
ViewPN_VAR_TERMS_V
ViewPN_XLA_EXTRACT_HEADERS_V
ViewPOBV_SUPPLIER_SITES
ViewPOFV_APPROVED_SUPPLIER_LISTS
ViewPOFV_BKT_PO_RELEASES
ViewPOFV_BKT_PURCHASE_ORDERS
ViewPOFV_PLAN_PO_RELEASES
ViewPOFV_PLAN_PURCHASE_ORDERS
ViewPOFV_PURCHASE_CONTRACTS
ViewPOFV_PURCHASE_ORDERS
ViewPOFV_QUOTATIONS
ViewPOFV_RECEIVING_TRANSACTIONS
ViewPOFV_REQUESTS_FOR_QUOTATION
ViewPOFV_RFQ_SUPPLIERS
ViewPOFV_RFQ_SUPPLIER_LIST_ENTRIES
ViewPOFV_STD_PURCHASE_ORDERS
ViewPOFV_SUPPLIER_CONTACTS
ViewPOFV_SUPPLIER_SITES
Package BodyPON_AUCTION_CREATE_PO_PKG - show dependent code
Package BodyPON_AUCTION_INTERFACE_PKG - show dependent code
Package BodyPON_AUCTION_PKG - show dependent code
Package BodyPON_BID_VALIDATIONS_PKG - show dependent code
Package BodyPON_PRINTING_PKG - show dependent code
Package BodyPON_SOURCING_OPENAPI_GRP - show dependent code
Package BodyPON_VENDORMERGE_GRP - show dependent code
Package BodyPOR_AMENDMENT_PKG - show dependent code
Package BodyPOR_CONTRACTOR_NOTIFY - show dependent code
ViewPOR_LINES_ALL_V
ViewPOR_RCV_MY_PURCHASE_ITEMS_V
ViewPOR_RCV_PURCHASE_ITEMS_V
ViewPOR_RCV_REQ_ITEMS_V
ViewPOR_RCV_SHIPMENTS_V
ViewPOR_VIEW_LINES_ALL_V
ViewPOS_AP_EXPENSE_REPORTS_V
ViewPOS_AP_INVOICES_V
Package BodyPOS_AP_SUPPLIER_SITE_BO_PKG - show dependent code
Package BodyPOS_ASN_NOTIF - show dependent code
Package BodyPOS_ASN_XML - show dependent code
Package BodyPOS_BATCH_IMPORT_PKG - show dependent code
ViewPOS_BILL_ONLY_ORDERS_V
ViewPOS_BLANKET_AGREE_V
ViewPOS_CHV_SCHEDULE_HEADERS_V
Package BodyPOS_CLM_UTIL_PKG - show dependent code
Package BodyPOS_COMPARE_REVISIONS - show dependent code
ViewPOS_CONSIGNED_SHIPMENTS_V
Package BodyPOS_EXCELASN_PVT - show dependent code
PL/SQL PackagePOS_EXCELASN_PVT - show dependent code
ViewPOS_HEADERS_V
ViewPOS_LINES_V
ViewPOS_ORDER_SUMMARY_V
ViewPOS_PLAN_SCHEDULE_HEADERS_V
ViewPOS_PO_ARCH_SUMMARY_V
ViewPOS_PO_DETAILS_V
ViewPOS_PO_EXPECTED_RECEIPTS_V
ViewPOS_PO_HEADERS_ARCHIVE_V
ViewPOS_PO_INVOICE_SUP_ORDERS_V
ViewPOS_PO_LATE_RECEIPTS_V
ViewPOS_PO_LINES_ARCHIVE_V
ViewPOS_PO_LINES_V
ViewPOS_PO_RFQ_HEADERS_V
ViewPOS_PO_SUMMARY_V
ViewPOS_PO_SUPPLIER_AGREEMENTS_V
ViewPOS_PO_SUPPLIER_INFO_V
ViewPOS_PO_SUPPLIER_ITEMS_V
ViewPOS_PO_SUPPLIER_ORDERS_V
ViewPOS_PO_SUP_ORDER_INVOICES_V
ViewPOS_RCV_EARLY_LATE_RECEIPTS_V
ViewPOS_RCV_REJECTED_ITEMS_V
ViewPOS_RCV_RETURNS_V
ViewPOS_RCV_TRANSACTIONS_V
ViewPOS_RECEIPT_HEADERS_V
Package BodyPOS_REQUEST_UTILS_PKG - show dependent code
ViewPOS_SHIPMENTS_V
ViewPOS_SHIP_SCHEDULE_HEADERS_V
ViewPOS_SUPP_AGREEMENTS_V
Package BodyPOS_SUPP_CUSTOM - show dependent code
Package BodyPOS_SUP_PROF_MRG_GRP - show dependent code
Package BodyPOS_VENDOR_MERGE - show dependent code
ViewPOS_VIEW_ASN
ViewPOS_VIEW_PO_SUMMARY_V
Package BodyPO_AME_WF_PVT - show dependent code
Package BodyPO_APPROVED_SUPPLIER_LIST_SV - show dependent code
Package BodyPO_AP_MERGE_GRP - show dependent code
PL/SQL PackagePO_AP_MERGE_GRP - show dependent code
Package BodyPO_ASL_API_PUB - show dependent code
Package BodyPO_ASL_SV - show dependent code
Package BodyPO_AUTOCREATE_DOC - show dependent code
ViewPO_AUTOSOURCE_DOCUMENTS_V
ViewPO_AUTOSOURCE_RULES_V
Package BodyPO_AUTOSOURCE_SV - show dependent code
Package BodyPO_AUTO_HEADER_PROCESS_PVT - show dependent code
Package BodyPO_AUTO_LINE_PROCESS_PVT - show dependent code
Package BodyPO_CHANGEORDERWF_PVT - show dependent code
Package BodyPO_CHG_REQUEST_GRP - show dependent code
Package BodyPO_COMMUNICATION_PVT - show dependent code
Package BodyPO_COMPARE_REVISIONS - show dependent code
Package BodyPO_CONTERMS_UTL_GRP - show dependent code
Package BodyPO_COO_S - show dependent code
Package BodyPO_COPYDOC_S2 - show dependent code
Package BodyPO_COPYDOC_SUB - show dependent code
ViewPO_CXML_HEADER_ARCH_V
Package BodyPO_DOCUMENT_CHECKS_PVT - show dependent code
Package BodyPO_DOCUMENT_CONTROL_GRP - show dependent code
ViewPO_ECX_HEADER_ARCH_V
ViewPO_ECX_HEADER_V
Package BodyPO_FED_FIELD_FUNCTIONS - show dependent code
ViewPO_GA_ORG_ASSIGNMENTS_V
ViewPO_HEADERS_ARCHIVE_XML
ViewPO_HEADERS_CHANGE_PRINT
ViewPO_HEADERS_INQ_PO_V
ViewPO_HEADERS_INQ_REL_V
ViewPO_HEADERS_INQ_V
ViewPO_HEADERS_PRINT
ViewPO_HEADERS_REF_V
ViewPO_HEADERS_RFQQT_V
ViewPO_HEADERS_V
Package BodyPO_INQ_SV - show dependent code
Package BodyPO_INTERFACE_S - show dependent code
ViewPO_LINES_INQ_V
ViewPO_LINE_LOCATIONS_INQ_V
Package BodyPO_LOCATIONS_S - show dependent code
Package BodyPO_MULTI_MOD_PVT - show dependent code
Package BodyPO_OTM_INTEGRATION_PVT - show dependent code
Package BodyPO_PCARD_PKG - show dependent code
Package BodyPO_PDOI_HEADER_PROCESS_PVT - show dependent code
Package BodyPO_PDOI_POSTPROC_PVT - show dependent code
ViewPO_PURCHASE_HISTORY_V
ViewPO_QUOTATIONS_TO_APPROVE
Package BodyPO_R12_CAT_UPG_DEF_PVT - show dependent code
Package BodyPO_R12_CAT_UPG_VAL_PVT - show dependent code
ViewPO_RELEASES_V
ViewPO_RELEASE_ARCHIVE_XML
ViewPO_RELEASE_TRANSACTION_V
ViewPO_RELEASE_XML
Package BodyPO_REQAPPROVAL_INIT1 - show dependent code
Package BodyPO_REQCHANGEREQUESTNOTIF_PVT - show dependent code
ViewPO_REQEXPRESS_LINES_V
Package BodyPO_REQIMP_PKG - show dependent code
ViewPO_REQUISITION_TEMPLATES_V
ViewPO_RFQS_FOR_QUOTE_ALL_V
ViewPO_RFQ_HEADERS_PRINT
ViewPO_SGD_HEADERS_V
ViewPO_SGD_MOD_HEADERS_V
Package BodyPO_SOURCING_PVT - show dependent code
ViewPO_SP_VAL_V
Package BodyPO_TAX_INTERFACE_PVT - show dependent code
ViewPO_TEMP_LABOR_HEADERS_V
Package BodyPO_THIRD_PARTY_STOCK_GRP - show dependent code
ViewPO_TRANSACTION_V
ViewPO_VENDOR_SITES_ALL1_DFV
ViewPO_VENDOR_SITES_ALL2_DFV
ViewPO_VENDOR_SITES_ALL_DFV
Package BodyPO_VENDOR_SITES_SV - show dependent code
Package BodyPO_VERIFY_VENDOR_ELIGIBILITY - show dependent code
Package BodyPO_VMI_ENABLED - show dependent code
Package BodyPO_VMI_GRP - show dependent code
Package BodyPO_WFDS_PUB - show dependent code
Package BodyPO_WF_PO_NOTIFICATION - show dependent code
Package BodyPO_XML_DELIVERY - show dependent code
ViewPSA_AP_AEL_GL_BC_INV_V
Package BodyQA_FLEX_UTIL - show dependent code
Package BodyQA_SS_IMPORT_WF - show dependent code
ViewRCV_AEL_GL_V
Package BodyRCV_DEFAULT_PKG - show dependent code
Package BodyRCV_GAPLESS_NUMBERING - show dependent code
Package BodyRCV_HEADERS_INTERFACE_SV - show dependent code
ViewRCV_RECEIPT_CONFIRMATION_HDR_V
ViewRCV_RECEIPT_CONFIRMATION_TXN_V
ViewRCV_RECEIPT_CONFIRMATION_V
PL/SQL PackageRCV_TABLE_FUNCTIONS - show dependent code
Package BodyRCV_TABLE_FUNCTIONS - show dependent code
Package BodyRCV_TRANSACTION_PROCESSOR - show dependent code
ViewRCV_VRC_HDS_V
Package BodyWIP_OSP_SHP_I_WF - show dependent code
Package BodyWIP_WF_UPDATE_DATE - show dependent code
ViewWMS_LABEL_REQUESTS_HIST_V
Package BodyWMS_RULES_WORKBENCH_PVT - show dependent code
ViewWSH_CAL_ASG_DETAIL_V
Package BodyWSH_CAL_ASG_VALIDATIONS - show dependent code
ViewWSH_ITM_SHIPMENT_V
Package BodyWSH_VENDOR_PARTY_MERGE_PKG - show dependent code
Package BodyWSH_WSHRDPAK_XMLP_PKG - show dependent code
Package BodyXLE_THIRDPARTY - show dependent code
ViewXTR_AP_OPEN_APLD_TRX_V
ViewXTR_AP_OPEN_TRX_V
ViewXTR_AP_ORIG_TRX_V
PL/SQL PackageZX_PO_REC_PKG - show dependent code
Package BodyZX_TAX_RECOVERY_PKG - show dependent code
PL/SQL PackageZX_TAX_RECOVERY_PKG - show dependent code
Package BodyZX_TEST_API - show dependent code