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.QP_BULK_VALUE_TO_ID dependencies on MTL_SYSTEM_ITEMS_VL

Line 366: FROM mtl_system_items_vl a, qp_interface_pricing_attribs c

362: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS)=
363: (SELECT a.inventory_item_id,
364: DECODE(a.inventory_item_id, NULL, null, 'P'),
365: DECODE(a.inventory_item_id, NULL, qipa.ATTRIBUTE_STATUS||'004',qipa.ATTRIBUTE_STATUS)
366: FROM mtl_system_items_vl a, qp_interface_pricing_attribs c
367: WHERE (c.product_attr_value IS NULL and
368: a.concatenated_segments= c.product_attr_val_disp
369: OR c.product_attr_value IS NOT NULL and
370: a.inventory_item_id = c.product_attr_value)

Line 385: FROM MTL_SYSTEM_ITEMS_VL A

381: SET (PRODUCT_ATTR_VALUE, PROCESS_STATUS_FLAG, ATTRIBUTE_STATUS) =
382: (
383: SELECT A.INVENTORY_ITEM_ID, DECODE(A.INVENTORY_ITEM_ID, NULL, NULL, 'P'),
384: DECODE(INVENTORY_ITEM_ID, NULL,QIPA.ATTRIBUTE_STATUS||'004',QIPA.ATTRIBUTE_STATUS)
385: FROM MTL_SYSTEM_ITEMS_VL A
386: WHERE QIPA.PRODUCT_ATTR_VALUE IS NOT NULL
387: AND A.INVENTORY_ITEM_ID = QIPA.PRODUCT_ATTR_VALUE
388: AND A.ORGANIZATION_ID = FND_PROFILE.VALUE('QP_ORGANIZATION_ID')
389: AND ROWNUM < 2

Line 393: FROM MTL_SYSTEM_ITEMS_VL A

389: AND ROWNUM < 2
390: UNION ALL
391: SELECT A.INVENTORY_ITEM_ID, DECODE(A.INVENTORY_ITEM_ID, NULL, NULL, 'P'),
392: DECODE(INVENTORY_ITEM_ID, NULL, QIPA.ATTRIBUTE_STATUS||'004',QIPA.ATTRIBUTE_STATUS)
393: FROM MTL_SYSTEM_ITEMS_VL A
394: WHERE QIPA.PRODUCT_ATTR_VALUE IS NULL
395: AND A.CONCATENATED_SEGMENTS=QIPA.PRODUCT_ATTR_VAL_DISP
396: AND A.ORGANIZATION_ID = FND_PROFILE.VALUE('QP_ORGANIZATION_ID')
397: AND ROWNUM < 2