VIEW: APPS.MSD_LB_FCST_BASIS_CS_V

Source

View Text - Preformatted

SELECT mdp.liab_plan_name, 7, ORG.LEVEL_PK, 1, PRD.LEVEL_PK, 12, GEO.LEVEL_PK, 34, DCS.LEVEL_PK, MAD.CUTOFF_DAYS QTY, mad.creation_date, mad.created_by, mad.last_update_date, mad.last_updated_by, mad.last_update_login, 1, 1, 'I', to_number(null), to_number(null) FROM MSC_ASL_AUTH_DETAILS MAD, MSC_TRADING_PARTNERS MTP, MSD_LEVEL_VALUES_LB PRD, MSD_LEVEL_VALUES_LB ORG, MSD_LEVEL_VALUES_LB GEO, MSD_LEVEL_VALUES_LB DCS, MSC_PLANS pln, msd_demand_plans mdp WHERE PLN.PLAN_ID = PRD.PLAN_ID AND PRD.LEVEL_ID = 1 AND PRD.SR_LEVEL_PK = MAD.INVENTORY_ITEM_ID AND PLN.PLAN_ID = ORG.PLAN_ID AND ORG.LEVEL_ID = 7 AND MTP.SR_INSTANCE_ID = MAD.SR_INSTANCE_ID AND MTP.SR_TP_ID = MAD.ORGANIZATION_ID AND MTP.PARTNER_TYPE = 3 AND ORG.SR_LEVEL_PK = MTP.sr_instance_id||':'||sr_tp_id AND PLN.PLAN_ID = GEO.PLAN_ID AND GEO.LEVEL_ID = 12 AND GEO.SR_LEVEL_PK = MAD.SUPPLIER_ID AND PLN.PLAN_ID = DCS.PLAN_ID AND DCS.LEVEL_ID = 34 AND DCS.SR_LEVEL_PK = MAD.AUTHorization_CODE and pln.plan_id = mdp.liab_plan_id and mad.INCLUDE_LIABILITY_AGREEMENT = 1

View Text - HTML Formatted

SELECT MDP.LIAB_PLAN_NAME
, 7
, ORG.LEVEL_PK
, 1
, PRD.LEVEL_PK
, 12
, GEO.LEVEL_PK
, 34
, DCS.LEVEL_PK
, MAD.CUTOFF_DAYS QTY
, MAD.CREATION_DATE
, MAD.CREATED_BY
, MAD.LAST_UPDATE_DATE
, MAD.LAST_UPDATED_BY
, MAD.LAST_UPDATE_LOGIN
, 1
, 1
, 'I'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM MSC_ASL_AUTH_DETAILS MAD
, MSC_TRADING_PARTNERS MTP
, MSD_LEVEL_VALUES_LB PRD
, MSD_LEVEL_VALUES_LB ORG
, MSD_LEVEL_VALUES_LB GEO
, MSD_LEVEL_VALUES_LB DCS
, MSC_PLANS PLN
, MSD_DEMAND_PLANS MDP
WHERE PLN.PLAN_ID = PRD.PLAN_ID
AND PRD.LEVEL_ID = 1
AND PRD.SR_LEVEL_PK = MAD.INVENTORY_ITEM_ID
AND PLN.PLAN_ID = ORG.PLAN_ID
AND ORG.LEVEL_ID = 7
AND MTP.SR_INSTANCE_ID = MAD.SR_INSTANCE_ID
AND MTP.SR_TP_ID = MAD.ORGANIZATION_ID
AND MTP.PARTNER_TYPE = 3
AND ORG.SR_LEVEL_PK = MTP.SR_INSTANCE_ID||':'||SR_TP_ID
AND PLN.PLAN_ID = GEO.PLAN_ID
AND GEO.LEVEL_ID = 12
AND GEO.SR_LEVEL_PK = MAD.SUPPLIER_ID
AND PLN.PLAN_ID = DCS.PLAN_ID
AND DCS.LEVEL_ID = 34
AND DCS.SR_LEVEL_PK = MAD.AUTHORIZATION_CODE
AND PLN.PLAN_ID = MDP.LIAB_PLAN_ID
AND MAD.INCLUDE_LIABILITY_AGREEMENT = 1