VIEW: APPS.MSD_SR_PDUE_BACKLOG_V

Source

View Text - Preformatted

SELECT pdue.inv_org_id, null, nvl(pdue.inventory_item_id, msd_sr_util.get_null_pk), null, decode(decode(nvl(lower(filtercust.parameter_value), '1'), '1', '1', 'attribute1', hca.attribute1, 'attribute2', hca.attribute2, 'attribute3', hca.attribute3, 'attribute4', hca.attribute4, 'attribute5', hca.attribute5, 'attribute6', hca.attribute6, 'attribute7', hca.attribute7, 'attribute8', hca.attribute8, 'attribute9', hca.attribute9, 'attribute10', hca.attribute10, 'attribute11', hca.attribute11, 'attribute12', hca.attribute12, 'attribute13', hca.attribute13, 'attribute14', hca.attribute14, 'attribute15', hca.attribute15, '2') , '1' , nvl(hca.cust_account_id, msd_sr_util.get_null_pk), msd_sr_util.get_null_pk), null, msd_sr_util.get_null_pk, null, msd_sr_util.get_null_pk, null, msd_sr_util.get_all_dcs_pk, null, pdue.time_snapshot_date_id, pdue.pdue_amt_g, msd_sr_util.uom_conv(pdue.uom, pdue.inventory_item_id) * pdue.pdue_qty, msd_sr_util.get_null_pk, null, msd_sr_util.get_null_pk, null FROM ISC_BOOK_SUM2_PDUE2_F pdue, MTL_SYSTEM_ITEMS itm, msd_app_instance_orgs app, msd_setup_parameters morg, msd_setup_parameters para2, HZ_CUST_ACCOUNTS hca, (select parameter_value from msd_setup_parameters where parameter_name = 'MSD_CUSTOMER_ATTRIBUTE') filtercust WHERE morg.parameter_name = 'MSD_MASTER_ORG' and para2.parameter_name = 'MSD_TWO_LEVEL_PLANNING' AND pdue.inventory_item_id = itm.inventory_item_id AND pdue.inv_org_id = itm.organization_id and app.organization_id = pdue.inv_org_id and pdue.late_schedule_flag = 1 and nvl(pdue.days_late, 0) >= 0 and pdue.item_type_code in ('MODEL', 'STANDARD') and pdue.time_snapshot_date_id <> to_date('01/01/1000', 'MM/DD/YYYY') /* and hca.cust_account_id = pdue.customer_id Bug# 5120021 */ and hca.cust_account_id = pdue.sold_to_org_id and decode(nvl(itm.ato_forecast_control,3), 3, decode(nvl(para2.parameter_value, '2'), '1', msd_sr_util.is_product_family_forecastable(morg.parameter_value, pdue.inventory_item_id, 2), 2), 1) = 1 and (itm.mrp_planning_code <> 6 or (itm.mrp_planning_code = 6 and itm.pick_components_flag = 'Y')) /* order by pdue.inv_org_id, pdue.inventory_item_id, pdue.customer_id, pdue.time_snapshot_date_id Bug# 5120021 */

View Text - HTML Formatted

SELECT PDUE.INV_ORG_ID
, NULL
, NVL(PDUE.INVENTORY_ITEM_ID
, MSD_SR_UTIL.GET_NULL_PK)
, NULL
, DECODE(DECODE(NVL(LOWER(FILTERCUST.PARAMETER_VALUE)
, '1')
, '1'
, '1'
, 'ATTRIBUTE1'
, HCA.ATTRIBUTE1
, 'ATTRIBUTE2'
, HCA.ATTRIBUTE2
, 'ATTRIBUTE3'
, HCA.ATTRIBUTE3
, 'ATTRIBUTE4'
, HCA.ATTRIBUTE4
, 'ATTRIBUTE5'
, HCA.ATTRIBUTE5
, 'ATTRIBUTE6'
, HCA.ATTRIBUTE6
, 'ATTRIBUTE7'
, HCA.ATTRIBUTE7
, 'ATTRIBUTE8'
, HCA.ATTRIBUTE8
, 'ATTRIBUTE9'
, HCA.ATTRIBUTE9
, 'ATTRIBUTE10'
, HCA.ATTRIBUTE10
, 'ATTRIBUTE11'
, HCA.ATTRIBUTE11
, 'ATTRIBUTE12'
, HCA.ATTRIBUTE12
, 'ATTRIBUTE13'
, HCA.ATTRIBUTE13
, 'ATTRIBUTE14'
, HCA.ATTRIBUTE14
, 'ATTRIBUTE15'
, HCA.ATTRIBUTE15
, '2')
, '1'
, NVL(HCA.CUST_ACCOUNT_ID
, MSD_SR_UTIL.GET_NULL_PK)
, MSD_SR_UTIL.GET_NULL_PK)
, NULL
, MSD_SR_UTIL.GET_NULL_PK
, NULL
, MSD_SR_UTIL.GET_NULL_PK
, NULL
, MSD_SR_UTIL.GET_ALL_DCS_PK
, NULL
, PDUE.TIME_SNAPSHOT_DATE_ID
, PDUE.PDUE_AMT_G
, MSD_SR_UTIL.UOM_CONV(PDUE.UOM
, PDUE.INVENTORY_ITEM_ID) * PDUE.PDUE_QTY
, MSD_SR_UTIL.GET_NULL_PK
, NULL
, MSD_SR_UTIL.GET_NULL_PK
, NULL
FROM ISC_BOOK_SUM2_PDUE2_F PDUE
, MTL_SYSTEM_ITEMS ITM
, MSD_APP_INSTANCE_ORGS APP
, MSD_SETUP_PARAMETERS MORG
, MSD_SETUP_PARAMETERS PARA2
, HZ_CUST_ACCOUNTS HCA
, (SELECT PARAMETER_VALUE
FROM MSD_SETUP_PARAMETERS
WHERE PARAMETER_NAME = 'MSD_CUSTOMER_ATTRIBUTE') FILTERCUST
WHERE MORG.PARAMETER_NAME = 'MSD_MASTER_ORG'
AND PARA2.PARAMETER_NAME = 'MSD_TWO_LEVEL_PLANNING'
AND PDUE.INVENTORY_ITEM_ID = ITM.INVENTORY_ITEM_ID
AND PDUE.INV_ORG_ID = ITM.ORGANIZATION_ID
AND APP.ORGANIZATION_ID = PDUE.INV_ORG_ID
AND PDUE.LATE_SCHEDULE_FLAG = 1
AND NVL(PDUE.DAYS_LATE
, 0) >= 0
AND PDUE.ITEM_TYPE_CODE IN ('MODEL'
, 'STANDARD')
AND PDUE.TIME_SNAPSHOT_DATE_ID <> TO_DATE('01/01/1000'
, 'MM/DD/YYYY') /*
AND HCA.CUST_ACCOUNT_ID = PDUE.CUSTOMER_ID BUG# 5120021 */
AND HCA.CUST_ACCOUNT_ID = PDUE.SOLD_TO_ORG_ID
AND DECODE(NVL(ITM.ATO_FORECAST_CONTROL
, 3)
, 3
, DECODE(NVL(PARA2.PARAMETER_VALUE
, '2')
, '1'
, MSD_SR_UTIL.IS_PRODUCT_FAMILY_FORECASTABLE(MORG.PARAMETER_VALUE
, PDUE.INVENTORY_ITEM_ID
, 2)
, 2)
, 1) = 1
AND (ITM.MRP_PLANNING_CODE <> 6 OR (ITM.MRP_PLANNING_CODE = 6
AND ITM.PICK_COMPONENTS_FLAG = 'Y')) /* ORDER BY PDUE.INV_ORG_ID
, PDUE.INVENTORY_ITEM_ID
, PDUE.CUSTOMER_ID
, PDUE.TIME_SNAPSHOT_DATE_ID BUG# 5120021 */