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.

APPS.MSC_CL_DEMAND_ODS_LOAD dependencies on MSC_ST_DEMANDS

Line 630: MSC_ST_DEMANDS msd

626: msd.ORIGINATION_TYPE,
627: msd.SR_INSTANCE_ID,
628: msd.ORGANIZATION_ID
629: FROM MSC_ITEM_ID_LID t1,
630: MSC_ST_DEMANDS msd
631: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
632: AND msd.ORIGINATION_TYPE = 29
633: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES
634: AND t1.SR_INVENTORY_ITEM_ID(+)= msd.inventory_item_id

Line 675: MSC_ST_DEMANDS msd

671: -- msc_tp_id_lid c1,
672: MSC_ITEM_ID_LID t1,
673: MSC_ITEM_ID_LID t2,
674: MSC_DESIGNATORS md,
675: MSC_ST_DEMANDS msd
676: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id
677: AND t1.sr_instance_id= msd.sr_instance_id
678: AND t2.SR_INVENTORY_ITEM_ID(+)= nvl(msd.using_assembly_item_id,msd.inventory_item_id)
679: AND t2.sr_instance_id(+)= msd.sr_instance_id

Line 780: ||' MSC_ST_DEMANDS msd '

776: ||' FROM '
777: ||' MSC_ITEM_ID_LID t1, '
778: ||' MSC_ITEM_ID_LID t2, '
779: ||' MSC_DESIGNATORS md, '
780: ||' MSC_ST_DEMANDS msd '
781: ||'WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id '
782: ||' AND t1.sr_instance_id= msd.sr_instance_id '
783: ||' AND t2.SR_INVENTORY_ITEM_ID(+)= nvl(msd.using_assembly_item_id,msd.inventory_item_id) '
784: ||' AND t2.sr_instance_id(+)= msd.sr_instance_id '

Line 1398: MSC_ST_DEMANDS msd

1394: MSC_ITEM_ID_LID t1,
1395: MSC_ITEM_ID_LID t2,
1396: MSC_DESIGNATORS md,
1397: MSC_TP_SITE_ID_LID mtsil,
1398: MSC_ST_DEMANDS msd
1399: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id
1400: AND t1.sr_instance_id= msd.sr_instance_id
1401: AND t2.SR_INVENTORY_ITEM_ID= msd.using_assembly_item_id
1402: AND t2.sr_instance_id= msd.sr_instance_id