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 678: MSC_ST_DEMANDS msd

674: msd.ORIGINATION_TYPE,
675: msd.SR_INSTANCE_ID,
676: msd.ORGANIZATION_ID
677: FROM MSC_ITEM_ID_LID t1,
678: MSC_ST_DEMANDS msd
679: WHERE msd.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
680: AND msd.ORIGINATION_TYPE = 29
681: AND msd.DELETED_FLAG= MSC_UTIL.SYS_YES
682: AND t1.SR_INVENTORY_ITEM_ID(+)= msd.inventory_item_id

Line 725: MSC_ST_DEMANDS msd

721: -- msc_tp_id_lid c1,
722: MSC_ITEM_ID_LID t1,
723: MSC_ITEM_ID_LID t2,
724: MSC_DESIGNATORS md,
725: MSC_ST_DEMANDS msd
726: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id
727: AND t1.sr_instance_id= msd.sr_instance_id
728: AND t2.SR_INVENTORY_ITEM_ID(+)= nvl(msd.using_assembly_item_id,msd.inventory_item_id)
729: AND t2.sr_instance_id(+)= msd.sr_instance_id

Line 834: ||' MSC_ST_DEMANDS msd '

830: ||' FROM '
831: ||' MSC_ITEM_ID_LID t1, '
832: ||' MSC_ITEM_ID_LID t2, '
833: ||' MSC_DESIGNATORS md, '
834: ||' MSC_ST_DEMANDS msd '
835: ||'WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id '
836: ||' AND t1.sr_instance_id= msd.sr_instance_id '
837: ||' AND t2.SR_INVENTORY_ITEM_ID(+)= nvl(msd.using_assembly_item_id,msd.inventory_item_id) '
838: ||' AND t2.sr_instance_id(+)= msd.sr_instance_id '

Line 1667: MSC_ST_DEMANDS msd

1663: MSC_ITEM_ID_LID t1,
1664: MSC_ITEM_ID_LID t2,
1665: MSC_DESIGNATORS md,
1666: MSC_TP_SITE_ID_LID mtsil,
1667: MSC_ST_DEMANDS msd
1668: WHERE t1.SR_INVENTORY_ITEM_ID= msd.inventory_item_id
1669: AND t1.sr_instance_id= msd.sr_instance_id
1670: AND t2.SR_INVENTORY_ITEM_ID= msd.using_assembly_item_id
1671: AND t2.sr_instance_id= msd.sr_instance_id