VIEW: APPS.MSC_ASL_LIABILITY_AGREEMENT_V

Source

View Text - Preformatted

SELECT msc.rowid, msc.transaction_id, msc.parent_id, msc.plan_id, msc.supplier_id, mtp.partner_name, msc.supplier_site_id, mtps.tp_site_code, msc.organization_id, msi.organization_code, msc.inventory_item_id, msi.item_name, msc.authorization_code, lkup.meaning authorization_type , msc.percentage_purchase_price percentage_purchase_price , msc.cutoff_days , msc.sr_instance_id, msc.using_organization_id, msc_get_name.org_code(msc.using_organization_id,msc.sr_instance_id), msc.last_update_date, msc.last_updated_by, msc.creation_date, msc.created_by, msc.last_update_login, msc.collected_flag , nvl(msc.include_liability_agreement ,2), nvl(msc.asl_liability_agreement_basis,2) FROM msc_trading_partners mtp, msc_trading_partner_sites mtps, msc_system_items msi, msc_asl_auth_details msc , mfg_lookups lkup WHERE mtp.partner_id = msc.supplier_id AND mtp.partner_type = 1 AND mtps.partner_id(+) = msc.supplier_id AND mtps.partner_site_id(+) = msc.supplier_site_id AND msi.inventory_item_id = msc.inventory_item_id AND msi.organization_id = msc.organization_id AND msi.sr_instance_id = msc.sr_instance_id and lkup.lookup_type = 'MSC_AUTHORIZATIONS' and lkup.lookup_code = msc.authorization_code AND msi.plan_id = -1

View Text - HTML Formatted

SELECT MSC.ROWID
, MSC.TRANSACTION_ID
, MSC.PARENT_ID
, MSC.PLAN_ID
, MSC.SUPPLIER_ID
, MTP.PARTNER_NAME
, MSC.SUPPLIER_SITE_ID
, MTPS.TP_SITE_CODE
, MSC.ORGANIZATION_ID
, MSI.ORGANIZATION_CODE
, MSC.INVENTORY_ITEM_ID
, MSI.ITEM_NAME
, MSC.AUTHORIZATION_CODE
, LKUP.MEANING AUTHORIZATION_TYPE
, MSC.PERCENTAGE_PURCHASE_PRICE PERCENTAGE_PURCHASE_PRICE
, MSC.CUTOFF_DAYS
, MSC.SR_INSTANCE_ID
, MSC.USING_ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(MSC.USING_ORGANIZATION_ID
, MSC.SR_INSTANCE_ID)
, MSC.LAST_UPDATE_DATE
, MSC.LAST_UPDATED_BY
, MSC.CREATION_DATE
, MSC.CREATED_BY
, MSC.LAST_UPDATE_LOGIN
, MSC.COLLECTED_FLAG
, NVL(MSC.INCLUDE_LIABILITY_AGREEMENT
, 2)
, NVL(MSC.ASL_LIABILITY_AGREEMENT_BASIS
, 2)
FROM MSC_TRADING_PARTNERS MTP
, MSC_TRADING_PARTNER_SITES MTPS
, MSC_SYSTEM_ITEMS MSI
, MSC_ASL_AUTH_DETAILS MSC
, MFG_LOOKUPS LKUP
WHERE MTP.PARTNER_ID = MSC.SUPPLIER_ID
AND MTP.PARTNER_TYPE = 1
AND MTPS.PARTNER_ID(+) = MSC.SUPPLIER_ID
AND MTPS.PARTNER_SITE_ID(+) = MSC.SUPPLIER_SITE_ID
AND MSI.INVENTORY_ITEM_ID = MSC.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MSC.ORGANIZATION_ID
AND MSI.SR_INSTANCE_ID = MSC.SR_INSTANCE_ID
AND LKUP.LOOKUP_TYPE = 'MSC_AUTHORIZATIONS'
AND LKUP.LOOKUP_CODE = MSC.AUTHORIZATION_CODE
AND MSI.PLAN_ID = -1