VIEW: APPS.MSD_LB_RECEIPT_SINCE_CS_V

Source

View Text - Preformatted

SELECT mdp.liab_plan_name, 7, org.level_pk org , 1, PRD.LEVEL_PK prd, 12, sup.level_pk sup, mr.TRANSACTION_QTY , NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 'I', to_number(null), to_number(null) FROM MSD_DEMAND_PLANS MDP, MSC_PLANS MP, MSD_LEVEL_VALUES_LB PRD , MSD_LEVEL_VALUES_LB SUP , MSD_LEVEL_VALUES_LB ORG , MSC_PO_RECEIPTS MR, msc_trading_partners mtp, MSC_item_suppliers mis WHERE MP.PLAN_ID = MDP.LIAB_PLAN_ID and /* Product Mapping */ PRD.LEVEL_ID = 1 AND MR.INVENTORY_ITEM_ID = PRD.SR_LEVEL_PK AND MDP.LIAB_PLAN_ID = PRD.PLAN_ID and /* Supplier Mapping */ sup.level_id = 12 and sup.sr_level_pk = mr.supplier_id AND MDP.LIAB_PLAN_ID = SUP.PLAN_ID and /*org Mapping */ org.level_id = 7 and mtp.sr_tp_id = mr.organization_id and mtp.sr_instance_id =mr.sr_instance_id and org.sr_level_pk = mtp.sr_instance_id||':'||mtp.sr_tp_id and mtp.partner_type = 3 and MDP.LIAB_PLAN_ID =ORG.PLAN_ID and /* date range */ MR.TRANSACTION_DATE BETWEEN MDP.PREVIOUS_PLAN_START_DATE AND MDP.PLAN_START_DATE and /* Agreement */ mis.inventory_item_id = prd.sr_level_pk and mis.supplier_id = sup.sr_level_pk and mis.organization_id = mtp.sr_tp_id and mis.sr_instance_id = mtp.sr_instance_id and mis.INCLUDE_LIABILITY_AGREEMENT = 1

View Text - HTML Formatted

SELECT MDP.LIAB_PLAN_NAME
, 7
, ORG.LEVEL_PK ORG
, 1
, PRD.LEVEL_PK PRD
, 12
, SUP.LEVEL_PK SUP
, MR.TRANSACTION_QTY
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, 1
, 1
, 'I'
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM MSD_DEMAND_PLANS MDP
, MSC_PLANS MP
, MSD_LEVEL_VALUES_LB PRD
, MSD_LEVEL_VALUES_LB SUP
, MSD_LEVEL_VALUES_LB ORG
, MSC_PO_RECEIPTS MR
, MSC_TRADING_PARTNERS MTP
, MSC_ITEM_SUPPLIERS MIS
WHERE MP.PLAN_ID = MDP.LIAB_PLAN_ID
AND /* PRODUCT MAPPING */ PRD.LEVEL_ID = 1
AND MR.INVENTORY_ITEM_ID = PRD.SR_LEVEL_PK
AND MDP.LIAB_PLAN_ID = PRD.PLAN_ID
AND /* SUPPLIER MAPPING */ SUP.LEVEL_ID = 12
AND SUP.SR_LEVEL_PK = MR.SUPPLIER_ID
AND MDP.LIAB_PLAN_ID = SUP.PLAN_ID
AND /*ORG MAPPING */ ORG.LEVEL_ID = 7
AND MTP.SR_TP_ID = MR.ORGANIZATION_ID
AND MTP.SR_INSTANCE_ID =MR.SR_INSTANCE_ID
AND ORG.SR_LEVEL_PK = MTP.SR_INSTANCE_ID||':'||MTP.SR_TP_ID
AND MTP.PARTNER_TYPE = 3
AND MDP.LIAB_PLAN_ID =ORG.PLAN_ID
AND /* DATE RANGE */ MR.TRANSACTION_DATE BETWEEN MDP.PREVIOUS_PLAN_START_DATE
AND MDP.PLAN_START_DATE
AND /* AGREEMENT */ MIS.INVENTORY_ITEM_ID = PRD.SR_LEVEL_PK
AND MIS.SUPPLIER_ID = SUP.SR_LEVEL_PK
AND MIS.ORGANIZATION_ID = MTP.SR_TP_ID
AND MIS.SR_INSTANCE_ID = MTP.SR_INSTANCE_ID
AND MIS.INCLUDE_LIABILITY_AGREEMENT = 1