Results for “ship_to_address”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
MRP_GET_PROJECT is a utility PL/SQL package owned by the APPS schema in Oracle E-Business Suite. It is classified under the ETRM metadata as an "OTHER" API, meaning it is not a formally published open interface but an internal helper package used by the Oracle Planning (MRP/MPS) product family and related modules. Its business function is to resolve surrogate numeric identifiers into human-readable descriptive values for display and reporting purposes within planning and project-related screens. Rather than maintaining business logic that creates or updates transactional data, MRP_GET_PROJECT provides a lightweight lookup and translation layer, converting project IDs, task IDs, organization IDs, item IDs, category IDs, customer IDs, and vendor site IDs into the names, codes, and descriptions that end users expect to see. The package is declared AUTHID CURRENT_USER and includes PRAGMA RESTRICT_REFERENCES purity assertions for PROJECT, TASK, and PLANNING_GROUP, confirming that these functions read database state without writing to it, which makes them safe for use inside SQL statements and views.
Key Procedures and Functions
The package exposes thirteen documented functions, all returning VARCHAR2 or an FND lookup meaning type:
- PROJECT — returns the project name or number associated with a given project ID.
- TASK — returns the task name or number for a given task ID.
- PLANNING_GROUP — derives the planning group description for a project ID.
- LOOKUP_FND — resolves a lookup type and lookup code combination into its FND meaning.
- LOOKUP_MEANING — resolves a lookup type and numeric lookup code into its meaning.
- ORG_CODE — returns the organization code for a given organization ID.
- ITEM_NAME — returns the item name for an organization and item ID pair.
- ITEM_DESC — returns the item description for an organization and item ID pair.
- CATEGORY_DESC — returns a category description for a category set and category ID.
- CATEGORY_NAME — returns the category name for a category ID.
- CUSTOMER_NAME — returns the customer name for a customer ID.
- SHIP_TO_ADDRESS — returns a formatted ship-to address for a site ID.
- VENDOR_SITE_CODE — returns the vendor site code for an organization and vendor site ID.
Tables Accessed
The package reads from a broad set of APPS synonyms reflecting its role as a cross-module resolver. Project and task values are sourced from PA_PROJECTS_ALL and PA_TASKS, with planning group parameters drawn from MRP_PROJECT_PARAMETERS. Item name and description lookups use MTL_SYSTEM_ITEMS_KFV and MTL_PARAMETERS. Category resolution relies on MTL_CATEGORIES_KFV and MTL_CATEGORY_SETS. Customer-facing functions access the TCA model through HZ_CUST_ACCOUNTS, HZ_CUST_ACCT_SITES_ALL, HZ_CUST_SITE_USES_ALL, HZ_PARTIES, HZ_PARTY_SITES, and HZ_LOCATIONS, while vendor site data and planning sequence numbers draw on MRP_SEIBAN_NUMBERS. All access is read-only, consistent with the purity pragmas declared in the specification.
Usage Notes
MRP_GET_PROJECT is referenced by 48 other packages, indicating it is an internal dependency of the planning suite rather than a standalone entry point. It is typically invoked from Oracle Forms, concurrent programs, and report queries where a foreign-key ID must be displayed as a meaningful label, and from custom code that needs the same translation behavior as standard planning screens. Because the functions carry RESTRICT_REFERENCES pragmas, they may be embedded directly in SQL SELECT lists and view definitions. Developers extending MRP functionality should treat the package as a stable read-only utility; signature changes should be avoided because of the large number of dependent packages. In EBS 12.1.1 and 12.2.2 the behavior is consistent, with 12.2.2 deployments using the same APPS synonym layer over the TCA and planning tables.
-
Instance to Accounts(Party Accounts) Association.
-
This stores customer invoice information to be used in subcontractor workbench
-
View: MRP_CUST_SUP_ORG_V 12.1.1
Customer and Supplier Organizations View
APPS.MRP_CUST_SUP_ORG_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_ORGANIZATION_INFORMATION_V·Explore MRP module →
-
View: MSC_CUST_SUP_ORG_V 12.1.1
APPS.MSC_CUST_SUP_ORG_V·↳ MSC_TRADING_PARTNERS·↳ MSC_TRADING_PARTNER_SITES·Explore MSC module →
-
View: MRP_BIS_LATE_ORDERS_V 12.2.2
APPS.MRP_BIS_LATE_ORDERS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·Explore MRP module →
-
View: CSD_CUSTOMER_DETAILS_V 12.2.2
APPS.CSD_CUSTOMER_DETAILS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ HZ_PARTY_SITES_V·Explore CSD module →
-
View: CSD_INCIDENTS_V 12.1.1
The view for getting service request information.
APPS.CSD_INCIDENTS_V·↳ AR_LOOKUPS·↳ CSD_PROCESS_UTIL·↳ CSI_INSTANCE_STATUSES·Explore CSD module →
-
View: MRP_CUST_SUP_ORG_V 12.2.2
Customer and Supplier Organizations View
APPS.MRP_CUST_SUP_ORG_V·↳ FND_GLOBAL·↳ HR_API·↳ HR_ORGANIZATION_INFORMATION_V·Explore MRP module →
-
View: MSC_CUST_SUP_ORG_V 12.2.2
APPS.MSC_CUST_SUP_ORG_V·↳ MSC_TRADING_PARTNERS·↳ MSC_TRADING_PARTNER_SITES·Explore MSC module →
-
View: MRP_BIS_LATE_ORDERS_V 12.1.1
APPS.MRP_BIS_LATE_ORDERS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCT_SITES_ALL·↳ HZ_CUST_SITE_USES_ALL·Explore MRP module →
-
- Retrofitted
APPS.MRPFV_SR_BOD_ASSIGNMENTS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCT_SITES_ALL·Explore MRP module →
-
This table holds transaction data for Oracle Collaborative planning.
-
APPS.MRP_UNSCHEDULED_ORDERS_V·↳ BOM_OPERATIONAL_ROUTINGS·↳ CTO_WIP_WORKFLOW_API_PK·↳ HZ_CUST_ACCOUNTS·Explore MRP module →
-
Instance Party Account Details
APPS.CSI_PARTY_ACCT_DETAILS_V·↳ CSI_IPA_RELATION_TYPES·↳ CSI_IP_ACCOUNTS·↳ HZ_CUST_ACCOUNTS·Explore CSI module →
-
View: MSC_SR_ASSIGNMENTS_V 12.1.1
APPS.MSC_SR_ASSIGNMENTS_V·↳ MFG_LOOKUPS·↳ MSC_DRP_ALLOC_RULES·↳ MSC_GET_NAME·Explore MSC module →
-
View: MRP_SR_ASSIGNMENTS_V 12.1.1
Sourcing rule assignments view
APPS.MRP_SR_ASSIGNMENTS_V·↳ MRP_GET_PROJECT·↳ MRP_SOURCING_RULES·↳ MRP_SR_ASSIGNMENTS·Explore MRP module →
-
View: CSD_CUSTOMER_DETAILS_V 12.1.1
APPS.CSD_CUSTOMER_DETAILS_V·↳ HZ_CUST_ACCOUNTS·↳ HZ_PARTIES·↳ HZ_PARTY_SITES_V·Explore CSD module →
-
View: MRP_BIS_FORECAST_WB_V 12.1.1
APPS.MRP_BIS_FORECAST_WB_V·↳ MRP_BIS_FORECAST_WB·Explore MRP module →
-
View: MRP_BIS_FORECAST_WB_V 12.2.2
APPS.MRP_BIS_FORECAST_WB_V·↳ MRP_BIS_FORECAST_WB·Explore MRP module →
-
View: MSC_SUP_DEM_ENTRIES_V 12.1.1
APPS.MSC_SUP_DEM_ENTRIES_V·↳ MSC_SUP_DEM_ENTRIES·Explore MSC module →
-
Instance to Accounts(Party Accounts) Association.
-
Subcontractor workbench customer invoice view
APPS.PA_PWP_CUSTOMER_INVOICE_V·↳ PA_PWP_CUSTOMER_SUMM·↳ PA_PWP_LINK_STATUS_V·Explore PA module →
-
- Retrofitted
APPS.MRPFV_SR_BOD_ASSIGNMENTS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HZ_CUST_ACCOUNTS·↳ HZ_CUST_ACCT_SITES_ALL·Explore MRP module →
-
View: CSD_PRODUCT_TXNS_IRO_V 12.2.2
APPS.CSD_PRODUCT_TXNS_IRO_V·↳ CSD_PARTY_SITES_V·↳ CSD_PRODUCT_TRANSACTIONS·↳ CSD_REPAIRS·Explore CSD module →
-
View: CS_CHARGE_DETAILS_V 12.2.2
Charge Lines associated with Service request,depot repair and Field Service Report
APPS.CS_CHARGE_DETAILS_V·↳ CS_BUSINESS_PROCESSES·↳ CS_ESTIMATE_DETAILS·↳ CS_INCIDENTS_ALL_B·Explore CS module →
-
APPS.MSC_SUP_DEM_ENTRIES_UI_V·↳ FND_GLOBAL·↳ MFG_LOOKUPS·↳ MSC_GROUP_COMPANIES·Explore MSC module →
-
APPS.MSC_SUP_DEM_ENTRIES_UI_V·↳ FND_GLOBAL·↳ MFG_LOOKUPS·↳ MSC_GROUP_COMPANIES·Explore MSC module →
-
Instance Party Account Details
APPS.CSI_PARTY_ACCT_DETAILS_V·↳ CSI_IPA_RELATION_TYPES·↳ CSI_IP_ACCOUNTS·↳ HZ_CUST_ACCOUNTS·Explore CSI module →
-
View: MSC_SR_ASSIGNMENTS_V 12.2.2
APPS.MSC_SR_ASSIGNMENTS_V·↳ MFG_LOOKUPS·↳ MSC_DRP_ALLOC_RULES·↳ MSC_GET_NAME·Explore MSC module →
-
View: CS_CHARGE_DETAILS_V 12.1.1
Charge Lines associated with Service request,depot repair and Field Service Report
APPS.CS_CHARGE_DETAILS_V·↳ CS_BUSINESS_PROCESSES·↳ CS_ESTIMATE_DETAILS·↳ CS_INCIDENTS_ALL_B·Explore CS module →
-
APPS.MRP_UNSCHEDULED_ORDERS_V·↳ BOM_OPERATIONAL_ROUTINGS·↳ CTO_WIP_WORKFLOW_API_PK·↳ HZ_CUST_ACCOUNTS·Explore MRP module →
-
View: MRP_SR_ASSIGNMENTS_V 12.2.2
Sourcing rule assignments view
APPS.MRP_SR_ASSIGNMENTS_V·↳ MRP_GET_PROJECT·↳ MRP_SOURCING_RULES·↳ MRP_SR_ASSIGNMENTS·Explore MRP module →
-
View: MSC_SUP_DEM_ENTRIES_V 12.2.2
APPS.MSC_SUP_DEM_ENTRIES_V·↳ MSC_SUP_DEM_ENTRIES·Explore MSC module →
-
Resale header information
-
Supply demand lines interface table
-
View: CSI_INSTANCE_PARTY_V 12.2.2
Instance Party Associations view.
APPS.CSI_INSTANCE_PARTY_V·↳ CSI_INSTALL_PARAMETERS·↳ CSI_IP_ACCOUNTS·↳ CSI_ITEM_INSTANCES·Explore CSI module →
-
View: CSI_INSTANCE_PARTY_V 12.1.1
Instance Party Associations view.
APPS.CSI_INSTANCE_PARTY_V·↳ CSI_INSTALL_PARAMETERS·↳ CSI_IP_ACCOUNTS·↳ CSI_ITEM_INSTANCES·Explore CSI module →
-
Summary table stores forecast and actual values for use in the Discoverer workbook.
-
Summary table stores forecast and actual values for use in the Discoverer workbook.
-
View: CSD_INCIDENTS_V 12.2.2
The view for getting service request information.
APPS.CSD_INCIDENTS_V·↳ AR_LOOKUPS·↳ CSD_PROCESS_UTIL·↳ CSI_INSTANCE_STATUSES·Explore CSD module →
-
The view for getting service request information.
APPS.CSD_INCIDENTS_NON_SEC_V·↳ AR_LOOKUPS·↳ CSD_PROCESS_UTIL·↳ CSI_INSTANCE_STATUSES·Explore CSD module →
-
View: CSD_PRODUCT_TXNS_V 12.2.2
This View is used for the Receive/Ship tab in the Repair Orders Workbench. This will show all the Charge Lines and related information created for the repair order
APPS.CSD_PRODUCT_TXNS_V·↳ CSD_PRODUCT_TRANSACTIONS·↳ CSD_REPAIRS·↳ CSI_ITEM_INSTANCES·Explore CSD module →
-
View: CSD_PRODUCT_TXNS_V 12.1.1
This View is used for the Receive/Ship tab in the Repair Orders Workbench. This will show all the Charge Lines and related information created for the repair order
APPS.CSD_PRODUCT_TXNS_V·↳ CSD_PRODUCT_TRANSACTIONS·↳ CSD_REPAIRS·↳ CSI_ITEM_INSTANCES·Explore CSD module →
-
View: CSD_PRODUCT_TXNS_IRO_V 12.1.1
APPS.CSD_PRODUCT_TXNS_IRO_V·↳ CSD_PARTY_SITES_V·↳ CSD_PRODUCT_TRANSACTIONS·↳ CSD_REPAIRS·Explore CSD module →
-
The view for getting service request information.
APPS.CSD_INCIDENTS_NON_SEC_V·↳ AR_LOOKUPS·↳ CSD_PROCESS_UTIL·↳ CSI_INSTANCE_STATUSES·Explore CSD module →
-
Chargeback Lines information