VIEW: APPS.POR_TEMPLATE_ASSOC_V

Source

View Text - Preformatted

SELECT pta.rowid row_id, pta.template_assoc_id template_assoc_id, pta.region_code region_code, pta.item_or_category_flag item_or_category_flag, pta.item_or_category_id item_or_category_id, pta.created_by created_by, pta.creation_date creation_date, pta.last_updated_by last_updated_by, pta.last_update_date last_update_date, pta.last_update_login last_update_login from por_template_assoc pta WHERE (PTA.ITEM_OR_CATEGORY_FLAG = 'I' AND EXISTS(SELECT 'ITEM EXISTS IN INV ORG' FROM MTL_SYSTEM_ITEMS_B msi, FINANCIALS_SYSTEM_PARAMETERS fsp WHERE fsp.inventory_organization_id = msi.organization_id AND msi.inventory_item_id = pta.item_or_category_id) ) OR PTA.ITEM_OR_CATEGORY_FLAG = 'C'

View Text - HTML Formatted

SELECT PTA.ROWID ROW_ID
, PTA.TEMPLATE_ASSOC_ID TEMPLATE_ASSOC_ID
, PTA.REGION_CODE REGION_CODE
, PTA.ITEM_OR_CATEGORY_FLAG ITEM_OR_CATEGORY_FLAG
, PTA.ITEM_OR_CATEGORY_ID ITEM_OR_CATEGORY_ID
, PTA.CREATED_BY CREATED_BY
, PTA.CREATION_DATE CREATION_DATE
, PTA.LAST_UPDATED_BY LAST_UPDATED_BY
, PTA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PTA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM POR_TEMPLATE_ASSOC PTA
WHERE (PTA.ITEM_OR_CATEGORY_FLAG = 'I'
AND EXISTS(SELECT 'ITEM EXISTS IN INV ORG'
FROM MTL_SYSTEM_ITEMS_B MSI
, FINANCIALS_SYSTEM_PARAMETERS FSP
WHERE FSP.INVENTORY_ORGANIZATION_ID = MSI.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = PTA.ITEM_OR_CATEGORY_ID) ) OR PTA.ITEM_OR_CATEGORY_FLAG = 'C'