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_SUPPLIER_CONSOLIDATION_PK dependencies on BIS_OPERATING_UNITS_V

Line 109: AND (psp.org_id in (SELECT id FROM bis_operating_units_v

105: WHERE psp.item_id = p_item_id
106: AND psp.date_dimension BETWEEN p_start_date AND p_end_date
107: AND (psp.supplier_id = p_cons_supplier_id
108: OR ALL_SUPPLIER = p_cons_supplier_id)
109: AND (psp.org_id in (SELECT id FROM bis_operating_units_v
110: WHERE responsibility_id in
111: (SELECT responsibility_id
112: FROM fnd_user_resp_groups
113: WHERE user_id = p_user_id

Line 204: AND (phc2.org_id in (SELECT id FROM bis_operating_units_v

200: AND psc2.quantity <= psc1.quantity
201: AND (psc2.ship_to_location_id = psc1.ship_to_location_id
202: OR psc2.ship_to_location_id IS NULL)
203: AND phc2.vendor_id = p_pref_supplier_id
204: AND (phc2.org_id in (SELECT id FROM bis_operating_units_v
205: WHERE responsibility_id in
206: (SELECT responsibility_id
207: FROM fnd_user_resp_groups
208: WHERE user_id = p_user_id

Line 282: AND (phc2.org_id in (SELECT id FROM bis_operating_units_v

278: AND NVL(phc2.end_date, v_cons_date)
279: AND NVL(phc2.currency_code, MAGIC_STRING) =
280: NVL(phc1.currency_code, MAGIC_STRING)
281: AND phc2.vendor_id = p_pref_supplier_id
282: AND (phc2.org_id in (SELECT id FROM bis_operating_units_v
283: WHERE responsibility_id in
284: (SELECT responsibility_id
285: FROM fnd_user_resp_groups
286: WHERE user_id = p_user_id

Line 351: AND (psp.org_id in (SELECT id FROM bis_operating_units_v

347: WHERE psp.item_id = p_item_id
348: AND NVL(psp.quantity_purchased, 0) <> 0
349: AND psp.date_dimension BETWEEN p_start_date AND p_end_date
350: AND psp.supplier_id = p_pref_supplier_id
351: AND (psp.org_id in (SELECT id FROM bis_operating_units_v
352: WHERE responsibility_id in
353: (SELECT responsibility_id
354: FROM fnd_user_resp_groups
355: WHERE user_id = p_user_id

Line 394: AND (psp.org_id in (SELECT id FROM bis_operating_units_v

390: WHERE psp.item_id = p_item_id
391: AND NVL(psp.quantity_received, 0) <> 0
392: AND psp.date_dimension BETWEEN p_start_date AND p_end_date
393: AND psp.supplier_id = p_pref_supplier_id
394: AND (psp.org_id in (SELECT id FROM bis_operating_units_v
395: WHERE responsibility_id in
396: (SELECT responsibility_id
397: FROM fnd_user_resp_groups
398: WHERE user_id = p_user_id

Line 438: AND (psp.org_id in (SELECT id FROM bis_operating_units_v

434: WHERE psp.item_id = p_item_id
435: AND NVL(psp.quantity_purchased, 0) <> 0
436: AND psp.date_dimension BETWEEN p_start_date AND p_end_date
437: AND psp.supplier_id = p_pref_supplier_id
438: AND (psp.org_id in (SELECT id FROM bis_operating_units_v
439: WHERE responsibility_id in
440: (SELECT responsibility_id
441: FROM fnd_user_resp_groups
442: WHERE user_id = p_user_id