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.CHV_BUILD_SCHEDULES dependencies on PO_ASL_ATTRIBUTES_VAL_V

Line 146: FROM po_asl_attributes_val_v paa

142: p_bucket_pattern_id,
143: paa.vendor_id,
144: paa.vendor_site_id,
145: p_schedule_subtype
146: FROM po_asl_attributes_val_v paa
147: WHERE ((paa.using_organization_id = -1 and not exists
148: (SELECT *
149: FROM po_asl_attributes_val_v paa2
150: WHERE paa2.using_organization_id = x_organization_id

Line 149: FROM po_asl_attributes_val_v paa2

145: p_schedule_subtype
146: FROM po_asl_attributes_val_v paa
147: WHERE ((paa.using_organization_id = -1 and not exists
148: (SELECT *
149: FROM po_asl_attributes_val_v paa2
150: WHERE paa2.using_organization_id = x_organization_id
151: AND paa2.vendor_id = paa.vendor_id
152: AND paa2.vendor_site_id = paa.vendor_site_id
153: AND paa2.item_id = paa.item_id ))

Line 206: FROM po_asl_attributes_val_v paa,

202: paa.vendor_id,
203: paa.vendor_site_id,
204: decode(p_schedule_type, 'PLAN_SCHEDULE', paa.plan_schedule_type,
205: paa.ship_schedule_type)
206: FROM po_asl_attributes_val_v paa,
207: chv_bucket_patterns cbp,
208: po_vendor_sites_all povs
209: WHERE ((paa.using_organization_id = -1 and not exists
210: (SELECT *

Line 211: FROM po_asl_attributes_val_v paa2

207: chv_bucket_patterns cbp,
208: po_vendor_sites_all povs
209: WHERE ((paa.using_organization_id = -1 and not exists
210: (SELECT *
211: FROM po_asl_attributes_val_v paa2
212: WHERE paa2.using_organization_id = x_organization_id
213: AND paa2.vendor_id = paa.vendor_id
214: AND paa2.vendor_site_id = paa.vendor_site_id
215: AND paa2.item_id = paa.item_id ))

Line 273: FROM po_asl_attributes_val_v paa

269:
270: CURSOR C_CHECK_ORG IS
271: SELECT paa.vendor_id,
272: paa.vendor_site_id
273: FROM po_asl_attributes_val_v paa
274: WHERE ((paa.using_organization_id = -1 and not exists
275: (SELECT *
276: FROM po_asl_attributes_val_v paa2
277: WHERE paa2.using_organization_id = x_organization_id

Line 276: FROM po_asl_attributes_val_v paa2

272: paa.vendor_site_id
273: FROM po_asl_attributes_val_v paa
274: WHERE ((paa.using_organization_id = -1 and not exists
275: (SELECT *
276: FROM po_asl_attributes_val_v paa2
277: WHERE paa2.using_organization_id = x_organization_id
278: AND paa2.vendor_id = paa.vendor_id
279: AND paa2.vendor_site_id = paa.vendor_site_id
280: AND paa2.item_id = paa.item_id ))

Line 287: FROM po_asl_attributes_val_v paa

283:
284: CURSOR C_CHECK_V_VS IS
285: SELECT paa.vendor_id,
286: paa.vendor_site_id
287: FROM po_asl_attributes_val_v paa
288: WHERE ((paa.using_organization_id = -1 and not exists
289: (SELECT *
290: FROM po_asl_attributes_val_v paa2
291: WHERE paa2.using_organization_id = x_organization_id

Line 290: FROM po_asl_attributes_val_v paa2

286: paa.vendor_site_id
287: FROM po_asl_attributes_val_v paa
288: WHERE ((paa.using_organization_id = -1 and not exists
289: (SELECT *
290: FROM po_asl_attributes_val_v paa2
291: WHERE paa2.using_organization_id = x_organization_id
292: AND paa2.vendor_id = paa.vendor_id
293: AND paa2.vendor_site_id = paa.vendor_site_id
294: AND paa2.item_id = paa.item_id ))

Line 303: FROM po_asl_attributes_val_v paa

299:
300: CURSOR C_CHECK_V_VS_ITEM IS
301: SELECT paa.vendor_id,
302: paa.vendor_site_id
303: FROM po_asl_attributes_val_v paa
304: WHERE ((paa.using_organization_id = -1 and not exists
305: (SELECT *
306: FROM po_asl_attributes_val_v paa2
307: WHERE paa2.using_organization_id = x_organization_id

Line 306: FROM po_asl_attributes_val_v paa2

302: paa.vendor_site_id
303: FROM po_asl_attributes_val_v paa
304: WHERE ((paa.using_organization_id = -1 and not exists
305: (SELECT *
306: FROM po_asl_attributes_val_v paa2
307: WHERE paa2.using_organization_id = x_organization_id
308: AND paa2.vendor_id = paa.vendor_id
309: AND paa2.vendor_site_id = paa.vendor_site_id
310: AND paa2.item_id = paa.item_id ))

Line 321: FROM po_asl_attributes_val_v paa

317:
318: CURSOR C_CHECK_V_VS_AS_FLAG IS
319: SELECT paa.vendor_id,
320: paa.vendor_site_id
321: FROM po_asl_attributes_val_v paa
322: WHERE ((paa.using_organization_id = -1 and not exists
323: (SELECT *
324: FROM po_asl_attributes_val_v paa2
325: WHERE paa2.using_organization_id = x_organization_id

Line 324: FROM po_asl_attributes_val_v paa2

320: paa.vendor_site_id
321: FROM po_asl_attributes_val_v paa
322: WHERE ((paa.using_organization_id = -1 and not exists
323: (SELECT *
324: FROM po_asl_attributes_val_v paa2
325: WHERE paa2.using_organization_id = x_organization_id
326: AND paa2.vendor_id = paa.vendor_id
327: AND paa2.vendor_site_id = paa.vendor_site_id
328: AND paa2.item_id = paa.item_id ))

Line 344: FROM po_asl_attributes_val_v paa

340:
341: CURSOR C_CHECK_V_VS_ST_FLAG IS
342: SELECT paa.vendor_id,
343: paa.vendor_site_id
344: FROM po_asl_attributes_val_v paa
345: WHERE ((paa.using_organization_id = -1 and not exists
346: (SELECT *
347: FROM po_asl_attributes_val_v paa2
348: WHERE paa2.using_organization_id = x_organization_id

Line 347: FROM po_asl_attributes_val_v paa2

343: paa.vendor_site_id
344: FROM po_asl_attributes_val_v paa
345: WHERE ((paa.using_organization_id = -1 and not exists
346: (SELECT *
347: FROM po_asl_attributes_val_v paa2
348: WHERE paa2.using_organization_id = x_organization_id
349: AND paa2.vendor_id = paa.vendor_id
350: AND paa2.vendor_site_id = paa.vendor_site_id
351: AND paa2.item_id = paa.item_id ))

Line 366: FROM po_asl_attributes_val_v paa,

362:
363: CURSOR C_CHECK_BP IS
364: SELECT paa.vendor_id,
365: paa.vendor_site_id
366: FROM po_asl_attributes_val_v paa,
367: chv_bucket_patterns cbp
368: WHERE ((paa.using_organization_id = -1 and not exists
369: (SELECT *
370: FROM po_asl_attributes_val_v paa2

Line 370: FROM po_asl_attributes_val_v paa2

366: FROM po_asl_attributes_val_v paa,
367: chv_bucket_patterns cbp
368: WHERE ((paa.using_organization_id = -1 and not exists
369: (SELECT *
370: FROM po_asl_attributes_val_v paa2
371: WHERE paa2.using_organization_id = x_organization_id
372: AND paa2.vendor_id = paa.vendor_id
373: AND paa2.vendor_site_id = paa.vendor_site_id
374: AND paa2.item_id = paa.item_id ))

Line 1408: FROM po_asl_attributes_val_v paa

1404: paa.asl_id,
1405: paa.item_id,
1406: NVL(paa.enable_authorizations_flag, 'N'),
1407: paa.purchasing_unit_of_measure
1408: FROM po_asl_attributes_val_v paa
1409: WHERE ((paa.using_organization_id = -1 and not exists
1410: (SELECT *
1411: FROM po_asl_attributes_val_v paa2
1412: WHERE paa2.using_organization_id = x_organization_id

Line 1411: FROM po_asl_attributes_val_v paa2

1407: paa.purchasing_unit_of_measure
1408: FROM po_asl_attributes_val_v paa
1409: WHERE ((paa.using_organization_id = -1 and not exists
1410: (SELECT *
1411: FROM po_asl_attributes_val_v paa2
1412: WHERE paa2.using_organization_id = x_organization_id
1413: AND paa2.vendor_id = paa.vendor_id
1414: AND paa2.vendor_site_id = paa.vendor_site_id
1415: AND paa2.item_id = paa.item_id ))

Line 1670: FROM po_asl_attributes_val_v paa

1666: INTO x_asl_id_l,
1667: x_enable_authorizations_flag_l,
1668: x_purch_unit_of_measure_l,
1669: x_using_org_id_l
1670: FROM po_asl_attributes_val_v paa
1671: WHERE paa.vendor_id = x_vendor_id
1672: AND paa.vendor_site_id = x_vendor_site_id
1673: AND paa.item_id = x_item_id_l
1674: AND paa.using_organization_id =

Line 1676: FROM po_asl_attributes_val_v paa2

1672: AND paa.vendor_site_id = x_vendor_site_id
1673: AND paa.item_id = x_item_id_l
1674: AND paa.using_organization_id =
1675: (SELECT MAX(paa2.using_organization_id)
1676: FROM po_asl_attributes_val_v paa2
1677: WHERE decode(paa2.using_organization_id, -1,
1678: x_organization_id, paa2.using_organization_id) =
1679: x_organization_id
1680: AND paa2.vendor_id = x_vendor_id

Line 1725: FROM po_asl_attributes_val_v paa

1721: max(paa.using_organization_id)
1722: INTO x_asl_id_l,
1723: x_enable_authorizations_flag_l,
1724: x_using_org_id_l
1725: FROM po_asl_attributes_val_v paa
1726: WHERE paa.vendor_id = x_vendor_id
1727: AND paa.vendor_site_id = x_vendor_site_id
1728: AND paa.item_id = x_item_id_l
1729: AND paa.using_organization_id =

Line 1731: FROM po_asl_attributes_val_v paa2

1727: AND paa.vendor_site_id = x_vendor_site_id
1728: AND paa.item_id = x_item_id_l
1729: AND paa.using_organization_id =
1730: (SELECT MAX(paa2.using_organization_id)
1731: FROM po_asl_attributes_val_v paa2
1732: WHERE decode(paa2.using_organization_id, -1,
1733: x_organization_id, paa2.using_organization_id) =
1734: x_organization_id
1735: AND paa2.vendor_id = x_vendor_id