VIEW: APPS.PMITS_WAREHOUSE_MASTER_V

Source

View Text - Preformatted

SELECT WHSE.WHSE_CODE ,WHSE.WHSE_NAME ,WHSE.ORGN_CODE ,WHSE.LOCT_CTL ,LOCT_CTL_LKUP.MEANING ,WHSE.ADDR_ID ,WHSE.CONSIGN_IND ,CONSIGN_IND_LKUP.MEANING ,WHSE.REGION_CODE ,WHSE.WHSE_CLASS ,WHSE.WHSE_CONTACT ,WHSE.WHSE_PHONE ,WHSE.TAXLOC_CODE ,WHSE.LAST_UPDATE_DATE ,WHSE.LAST_UPDATED_BY ,WHSE.CREATION_DATE ,WHSE.CREATED_BY ,WHSE.DELETE_MARK ,WHSE.TEXT_CODE ,WHSE.LAST_UPDATE_LOGIN ,WHSE.INGREDIENT_STAGE ,WHSE.PRODUCT_STAGE ,WHSE.RECV_STAGE ,WHSE.SHIP_STAGE ,WHSE.MTL_ORGANIZATION_ID ,MTL_PARAM.ORGANIZATION_CODE FROM IC_WHSE_MST WHSE, MTL_PARAMETERS MTL_PARAM, GEM_LOOKUPS LOCT_CTL_LKUP, GEM_LOOKUPS CONSIGN_IND_LKUP WHERE WHSE.MTL_ORGANIZATION_ID = MTL_PARAM.ORGANIZATION_ID AND LOCT_CTL_LKUP.LOOKUP_TYPE = 'LOCATION_CONTROL' AND LOCT_CTL_LKUP.LOOKUP_CODE = WHSE.LOCT_CTL AND CONSIGN_IND_LKUP.LOOKUP_TYPE = 'CONSIGNMENT' AND CONSIGN_IND_LKUP.LOOKUP_CODE = WHSE.CONSIGN_IND AND 'TRUE' = PMI_SECURITY_PKG.show_record(WHSE.orgn_code)

View Text - HTML Formatted

SELECT WHSE.WHSE_CODE
, WHSE.WHSE_NAME
, WHSE.ORGN_CODE
, WHSE.LOCT_CTL
, LOCT_CTL_LKUP.MEANING
, WHSE.ADDR_ID
, WHSE.CONSIGN_IND
, CONSIGN_IND_LKUP.MEANING
, WHSE.REGION_CODE
, WHSE.WHSE_CLASS
, WHSE.WHSE_CONTACT
, WHSE.WHSE_PHONE
, WHSE.TAXLOC_CODE
, WHSE.LAST_UPDATE_DATE
, WHSE.LAST_UPDATED_BY
, WHSE.CREATION_DATE
, WHSE.CREATED_BY
, WHSE.DELETE_MARK
, WHSE.TEXT_CODE
, WHSE.LAST_UPDATE_LOGIN
, WHSE.INGREDIENT_STAGE
, WHSE.PRODUCT_STAGE
, WHSE.RECV_STAGE
, WHSE.SHIP_STAGE
, WHSE.MTL_ORGANIZATION_ID
, MTL_PARAM.ORGANIZATION_CODE
FROM IC_WHSE_MST WHSE
, MTL_PARAMETERS MTL_PARAM
, GEM_LOOKUPS LOCT_CTL_LKUP
, GEM_LOOKUPS CONSIGN_IND_LKUP
WHERE WHSE.MTL_ORGANIZATION_ID = MTL_PARAM.ORGANIZATION_ID
AND LOCT_CTL_LKUP.LOOKUP_TYPE = 'LOCATION_CONTROL'
AND LOCT_CTL_LKUP.LOOKUP_CODE = WHSE.LOCT_CTL
AND CONSIGN_IND_LKUP.LOOKUP_TYPE = 'CONSIGNMENT'
AND CONSIGN_IND_LKUP.LOOKUP_CODE = WHSE.CONSIGN_IND
AND 'TRUE' = PMI_SECURITY_PKG.SHOW_RECORD(WHSE.ORGN_CODE)