View: PMIBV_ORGANIZATION_LOV_V | Oracle EBS ETRM Search

This view selects unique item/organization combinations from the GR_OTHER_NAMES_TL table and denormalizes the foreign key to the SY_ORGN_MST table for the organization description.

APPS.GR_OTHER_NAMES_ORGN_V·↳ GR_OTHER_NAMES_TL·↳ SY_ORGN_MST·Explore GR module →

Table: GMD_SAMPLE_REPLICATES_GT 12.1.1

owner GMD·GMD - Process Manufacturing Product Development·5 columns

GMD.GMD_SAMPLE_REPLICATES_GT·Explore GMD module →

View: IC_PURG_VW1 12.1.1

GMI - Process Manufacturing Inventory·5 columns

Transaction purge view.

APPS.IC_PURG_VW1·↳ IC_TRAN_CMP·↳ OP_BILL_LAD·↳ OP_ORDR_DTL·Explore GMI module →

View: PMIBV_PLANT_LOV_V 12.2.2

PMI - Process Manufacturing Intelligence (Obsolete)·2 columns

PMI LOV View for Plant

APPS.PMIBV_PLANT_LOV_V·↳ SY_ORGN_MST·Explore PMI module →

View: CM_APCM_MST_V 12.1.1

GMF - Process Manufacturing Financials·4 columns

View to enable master-detail relationship on Invoice Price Maintenance form

APPS.CM_APCM_MST_V·↳ CM_APCM_MST·↳ PO_ORDR_HDR·Explore GMF module →

View: CR_RSRC_DTL_VW1 12.2.2

GMP - Process Manufacturing Process Planning·4 columns

Not currently used

APPS.CR_RSRC_DTL_VW1·↳ CR_RSRC_DTL·↳ CR_RSRC_MST·Explore GMP module →

View: CR_RSRC_DTL_VW2 12.2.2

GMP - Process Manufacturing Process Planning·4 columns

Not currently used.

APPS.CR_RSRC_DTL_VW2·↳ CR_RSRC_DTL·↳ CR_RSRC_MST·Explore GMP module →

View: OP_ORDR_HDR_VW1 12.1.1

GML - Process Manufacturing Logistics·6 columns

View containing order header information used for lookups.

APPS.OP_ORDR_HDR_VW1·↳ FND_PROFILE·↳ OP_CUST_MST·↳ OP_HOLD_CDS·Explore GML module →

View: PMIBV_INVCAL_LOV_V 12.2.2

PMI - Process Manufacturing Intelligence (Obsolete)·3 columns

PMI LOV View for Inventory Calendar

APPS.PMIBV_INVCAL_LOV_V·↳ IC_CLDR_HDR·Explore PMI module →

View: GR_OTHER_NAMES_ORGN_V 12.2.2

GR - Process Manufacturing Regulatory Management·3 columns

This view selects unique item/organization combinations from the GR_OTHER_NAMES_TL table and denormalizes the foreign key to the SY_ORGN_MST table for the organization description.

APPS.GR_OTHER_NAMES_ORGN_V·↳ GR_OTHER_NAMES_TL·↳ SY_ORGN_MST·Explore GR module →

View: BIS_PROCESS_MFG_ORGS_V 12.1.1

BIS - Applications BIS·7 columns

APPS.BIS_PROCESS_MFG_ORGS_V·↳ PMI_SECURITY_PKG·↳ SY_ORGN_MST·Explore BIS module →

View: FM_FORM_EFF_VW1 12.2.2

GMD - Process Manufacturing Product Development·7 columns

Item Effectivity View

APPS.FM_FORM_EFF_VW1·↳ FM_FORM_EFF·Explore GMD module →

View: PMIBV_INVCALPERIOD_LOV_V 12.2.2

PMI - Process Manufacturing Intelligence (Obsolete)·5 columns

PMI LOV View for Cost Calendar Period

APPS.PMIBV_INVCALPERIOD_LOV_V·↳ IC_CLDR_DTL·Explore PMI module →

Table: GR_COVER_LETTERS_B 12.1.1 hub-leaning

owner GR·GR - Process Manufacturing Regulatory Management·7 columns

The base table for the cover letter for the recipient and the default cover letter for the Organization table.

GR.GR_COVER_LETTERS_B·Explore GR module →

View: CM_APCM_MST_V 12.2.2

GMF - Process Manufacturing Financials·4 columns

View to enable master-detail relationship on Invoice Price Maintenance form

APPS.CM_APCM_MST_V·↳ CM_APCM_MST·↳ PO_ORDR_HDR·Explore GMF module →

View: BIS_PROCESS_MFG_WAREHOUSES_V 12.1.1

BIS - Applications BIS·6 columns

APPS.BIS_PROCESS_MFG_WAREHOUSES_V·↳ IC_WHSE_MST·↳ PMI_SECURITY_PKG·Explore BIS module →

Table: GMD_SAMPLE_REPLICATES_GT 12.2.2

owner GMD·GMD - Process Manufacturing Product Development·5 columns

GMD.GMD_SAMPLE_REPLICATES_GT·Explore GMD module →

View: FM_FORM_EFF_VW1 12.1.1

GMD - Process Manufacturing Product Development·7 columns

Item Effectivity View

APPS.FM_FORM_EFF_VW1·↳ FM_FORM_EFF·Explore GMD module →

Table: SY_ORGN_USR 12.1.1 link

owner GMA·GMA - Process Manufacturing Systems·7 columns

Associates OPM Organizations with FND users

GMA.SY_ORGN_USR·Explore GMA module →

View: PMIBV_PLANT_LOV_V 12.1.1

PMI - Process Manufacturing Intelligence·2 columns

PMI LOV View for Plant

APPS.PMIBV_PLANT_LOV_V·↳ SY_ORGN_MST·Explore PMI module →

Table: GMD_FORMULA_SECURITY_TEMP 12.2.2

owner GMD·GMD - Process Manufacturing Product Development·10 columns

GMD.GMD_FORMULA_SECURITY_TEMP·Explore GMD module →

View: OP_ORDR_HDR_VW1 12.2.2

GML - Process Manufacturing Logistics·6 columns

View containing order header information used for lookups.

APPS.OP_ORDR_HDR_VW1·↳ FND_PROFILE·↳ OP_CUST_MST·↳ OP_HOLD_CDS·Explore GML module →

Table: RH_RSCL_TBL 12.2.2 standalone

owner GMP·GMP - Process Manufacturing Process Planning·10 columns

* NOT USED *

GMP.RH_RSCL_TBL·Explore GMP module →

Table: GR_OTHER_NAMES_TL 12.2.2 link

owner GR·GR - Process Manufacturing Regulatory Management·11 columns

The synonym entity records alternative names for an item by language. They will be sequenced in one of two ways, as determined by the preference SYNONYM STORAGE SEQUENCE. The values for this are 'A' -- Alphabetically, in which case the sequ

GR.GR_OTHER_NAMES_TL·Explore GR module →

View: CM_WHSE_EFF_V 12.2.2

GMF - Process Manufacturing Financials·3 columns

View to enable master-detail relationship on Rollup Target Warehouses form

APPS.CM_WHSE_EFF_V·↳ CM_WHSE_EFF·Explore GMF module →

Table: SY_ORGN_USR 12.2.2 link

owner GMA·GMA - Process Manufacturing Systems·7 columns

Associates OPM Organizations with FND users

GMA.SY_ORGN_USR·Explore GMA module →

Table: SY_ORGN_MST_TL 12.2.2 standalone

owner GMA·GMA - Process Manufacturing Systems·9 columns

Translations table table holding OPM Organization names in multiple languages

GMA.SY_ORGN_MST_TL·Explore GMA module →

View: GMI_LOTS_DEST_LIST_V 12.1.1

GMI - Process Manufacturing Inventory·11 columns

This view is used to populate the Lot Genealogy Tree Navigator (on the Lot Genealogy Inquiry) when the navigation mode is Where Used, and the user has submitted query parameters through the Find dialogue box.

APPS.GMI_LOTS_DEST_LIST_V·↳ GMI_LOTS_LIST_V·↳ GMI_LOT_TRACE_PKG·Explore GMI module →

Table: GMD_TECH_PARAMETERS_TL 12.2.2 standalone

owner GMD·GMD - Process Manufacturing Product Development·11 columns

Technical parameters header translation table

GMD.GMD_TECH_PARAMETERS_TL·Explore GMD module →

Table: GMD_TECH_PARAMETERS_TL 12.1.1 standalone

owner GMD·GMD - Process Manufacturing Product Development·11 columns

Technical parameters header translation table

GMD.GMD_TECH_PARAMETERS_TL·Explore GMD module →

Table: IC_CLDR_HDR_TL 12.1.1 standalone

owner GMI·GMI - Process Manufacturing Inventory·10 columns

Translations table table holding OPM inventory calendar descriptions in multiple languages