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.POA_PORTAL_POPULATE_C dependencies on EDW_ITEMS_M

Line 409: edw_items_m item,

405: sum(least(pod.Potential_Svg_G,0)),
406: p_quarter,
407: item.IORG_Purchaseable_Flag
408: from poa_edw_po_dist_f pod,
409: edw_items_m item,
410: edw_organization_m org,
411: edw_trd_partner_m tp,
412: edw_time_m time1,
413: edw_time_m time2,

Line 445: edw_items_m item,

441: 0, 0, 0, 0,
442: p_quarter,
443: item.IORG_Purchaseable_Flag
444: from poa_edw_po_dist_f pod,
445: edw_items_m item,
446: edw_organization_m org,
447: edw_trd_partner_m tp,
448: edw_time_m time1,
449: edw_time_m time2

Line 512: edw_items_m item,

508: 1,1,0)),
509: p_quarter,
510: item.IORG_Purchaseable_Flag
511: from poa_edw_po_dist_f pod,
512: edw_items_m item,
513: edw_time_m time1,
514: edw_time_m time2,
515: edw_time_m time3
516: where pod.ITEM_FK_KEY = item.IREV_ITEM_REVISION_PK_KEY

Line 574: edw_items_m item

570: edw_trd_partner_m tp,
571: edw_time_m time1,
572: edw_time_m time2,
573: edw_time_m time3,
574: edw_items_m item
575: where pod.SUPPLIER_SITE_FK_KEY = tp.TPLO_TPARTNER_LOC_PK_KEY
576: and pod.ITEM_FK_KEY = item.IREV_ITEM_REVISION_PK_KEY
577: and pod.PO_APP_DATE_FK_KEY = time1.CDAY_CAL_DAY_PK_KEY
578: and time1.CDAY_CALENDAR_DATE between p_start and p_end