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.MRP_SOURCING_API_PK dependencies on PO_VENDOR_SITES_ALL

Line 70: var_new_site_code po_vendor_sites_all.vendor_site_code%type;

66:
67: var_set_id NUMBER;
68: var_vendor_id NUMBER;
69: var_site_id NUMBER;
70: var_new_site_code po_vendor_sites_all.vendor_site_code%type;
71: var_source_org NUMBER;
72: var_alloc_percent NUMBER;
73: var_rank NUMBER;
74: var_sr_id NUMBER;

Line 339: po_vendor_sites_all site,

335: if var_vendor_id is not null then
336: SELECT site.vendor_site_code
337: INTO var_new_site_code
338: FROM
339: po_vendor_sites_all site,
340: po_vendors ven
341: WHERE NVL(ven.enabled_flag, 'N') = 'Y'
342: AND SYSDATE BETWEEN NVL(ven.start_date_active, SYSDATE -1)
343: AND NVL(ven.end_date_active, sysdate+1)

Line 422: var_vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE;

418: arg_source_subinventory IN OUT NOCOPY VARCHAR2,
419: arg_sourcing_rule_id OUT NOCOPY NUMBER,
420: arg_error_message OUT NOCOPY VARCHAR2)
421: RETURN BOOLEAN IS
422: var_vendor_site_code po_vendor_sites_all.vendor_site_code%TYPE;
423: BEGIN
424: if( mrp_sourcing(
425: arg_mode => arg_mode,
426: arg_item_id => arg_item_id,

Line 442: po_vendor_sites_all dest_site,

438: IF var_vendor_site_code IS NOT NULL THEN
439: select dest_site.vendor_site_id
440: into arg_vendor_site_id
441: FROM org_organization_definitions oog,
442: po_vendor_sites_all dest_site,
443: po_vendors ven
444: WHERE NVL(ven.enabled_flag, 'N') = 'Y'
445: AND sysdate BETWEEN NVL(ven.start_date_active, sysdate -1)
446: AND NVL(ven.end_date_active, sysdate+1)