eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MSD_SHIPMENT_DATA_V

Source

View Text - Preformatted


SELECT org_pk.level_value , org_pk.level_pk inv_org_pk, item_pk.level_value , item_pk.level_pk item_pk, sales_channel_pk.level_value, sales_channel_pk.level_pk sales_channel_pk, sales_rep_pk.level_value , sales_rep_pk.level_pk sales_rep_pk, ship_to_loc_pk.level_value , ship_to_loc_pk.level_pk ship_to_loc_pk, msd.USER_DEFINED1, null user_defined1_pk, msd.USER_DEFINED2, null USER_DEFINED2_PK, msd.BOOKED_DATE , msd.REQUESTED_DATE, msd.PROMISED_DATE, msd.shipped_DATE, msd.AMOUNT , msd.QTY_shipped from msd_shipment_data msd, msd_level_values org_pk, msd_level_values item_pk, msd_level_values sales_channel_pk, msd_level_values sales_rep_pk, msd_level_values ship_to_loc_pk WHERE /* inv_org_pk */ (org_pk.instance = msd.instance and org_pk.sr_level_pk = msd.sr_inv_org_pk and org_pk.level_id = 7) AND /* item_pk */ (item_pk.instance = msd.instance and item_pk.sr_level_pk = msd.sr_item_pk and item_pk.level_id = 1) AND /* sales_channel_pk */ (sales_channel_pk.instance = msd.instance and sales_channel_pk.sr_level_pk = msd.sr_sales_channel_pk and sales_channel_pk.level_id = 27) AND /* sales_rep_pk */ (sales_rep_pk.instance = msd.instance and sales_rep_pk.sr_level_pk = msd.sr_sales_rep_pk and sales_rep_pk.level_id = 18) AND /* ship_to_loc_pk */ (ship_to_loc_pk.instance = msd.instance and ship_to_loc_pk.sr_level_pk = msd.sr_ship_to_loc_pk and ship_to_loc_pk.level_id = 11)

View Text - HTML Formatted

SELECT ORG_PK.LEVEL_VALUE
, ORG_PK.LEVEL_PK INV_ORG_PK
, ITEM_PK.LEVEL_VALUE
, ITEM_PK.LEVEL_PK ITEM_PK
, SALES_CHANNEL_PK.LEVEL_VALUE
, SALES_CHANNEL_PK.LEVEL_PK SALES_CHANNEL_PK
, SALES_REP_PK.LEVEL_VALUE
, SALES_REP_PK.LEVEL_PK SALES_REP_PK
, SHIP_TO_LOC_PK.LEVEL_VALUE
, SHIP_TO_LOC_PK.LEVEL_PK SHIP_TO_LOC_PK
, MSD.USER_DEFINED1
, NULL USER_DEFINED1_PK
, MSD.USER_DEFINED2
, NULL USER_DEFINED2_PK
, MSD.BOOKED_DATE
, MSD.REQUESTED_DATE
, MSD.PROMISED_DATE
, MSD.SHIPPED_DATE
, MSD.AMOUNT
, MSD.QTY_SHIPPED
FROM MSD_SHIPMENT_DATA MSD
, MSD_LEVEL_VALUES ORG_PK
, MSD_LEVEL_VALUES ITEM_PK
, MSD_LEVEL_VALUES SALES_CHANNEL_PK
, MSD_LEVEL_VALUES SALES_REP_PK
, MSD_LEVEL_VALUES SHIP_TO_LOC_PK
WHERE /* INV_ORG_PK */ (ORG_PK.INSTANCE = MSD.INSTANCE
AND ORG_PK.SR_LEVEL_PK = MSD.SR_INV_ORG_PK
AND ORG_PK.LEVEL_ID = 7)
AND /* ITEM_PK */ (ITEM_PK.INSTANCE = MSD.INSTANCE
AND ITEM_PK.SR_LEVEL_PK = MSD.SR_ITEM_PK
AND ITEM_PK.LEVEL_ID = 1)
AND /* SALES_CHANNEL_PK */ (SALES_CHANNEL_PK.INSTANCE = MSD.INSTANCE
AND SALES_CHANNEL_PK.SR_LEVEL_PK = MSD.SR_SALES_CHANNEL_PK
AND SALES_CHANNEL_PK.LEVEL_ID = 27)
AND /* SALES_REP_PK */ (SALES_REP_PK.INSTANCE = MSD.INSTANCE
AND SALES_REP_PK.SR_LEVEL_PK = MSD.SR_SALES_REP_PK
AND SALES_REP_PK.LEVEL_ID = 18)
AND /* SHIP_TO_LOC_PK */ (SHIP_TO_LOC_PK.INSTANCE = MSD.INSTANCE
AND SHIP_TO_LOC_PK.SR_LEVEL_PK = MSD.SR_SHIP_TO_LOC_PK
AND SHIP_TO_LOC_PK.LEVEL_ID = 11)