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.XLA_THIRD_PARTY_MERGE dependencies on XLA_THIRD_PARTY_SITES_V

Line 384: FROM XLA_THIRD_PARTY_SITES_V

380: -- Validate the passed original third party site
381: BEGIN
382: SELECT 'X'
383: INTO v_dummy
384: FROM XLA_THIRD_PARTY_SITES_V
385: WHERE THIRD_PARTY_ID = p_original_third_party_id
386: AND THIRD_PARTY_SITE_ID = p_original_site_id
387: AND THIRD_PARTY_TYPE = p_third_party_type
388: AND ROWNUM = 1; -- May return multiple sites (e.g. different ship tos)

Line 405: FROM XLA_THIRD_PARTY_SITES_V

401: -- Validate the passed new third party site
402: BEGIN
403: SELECT 'X'
404: INTO v_dummy
405: FROM XLA_THIRD_PARTY_SITES_V
406: WHERE THIRD_PARTY_ID = p_new_third_party_id
407: AND THIRD_PARTY_SITE_ID = p_new_site_id
408: AND THIRD_PARTY_TYPE = p_third_party_type
409: AND ROWNUM = 1; -- May return multiple sites (e.g. different ship tos)

Line 5222: xla_third_party_sites_v s1,

5218: ent.ledger_id
5219: FROM xla_events evt,
5220: xla_third_parties_v p1,
5221: xla_third_parties_v p2,
5222: xla_third_party_sites_v s1,
5223: xla_third_party_sites_v s2,
5224: xla_transaction_entities ent,
5225: xla_ledger_options lgopt,
5226: xla_launch_options lnopt

Line 5223: xla_third_party_sites_v s2,

5219: FROM xla_events evt,
5220: xla_third_parties_v p1,
5221: xla_third_parties_v p2,
5222: xla_third_party_sites_v s1,
5223: xla_third_party_sites_v s2,
5224: xla_transaction_entities ent,
5225: xla_ledger_options lgopt,
5226: xla_launch_options lnopt
5227: WHERE

Line 5306: v_original_site_code xla_third_party_sites_v.third_party_site_code%TYPE;

5302: v_new_party_id NUMBER(15);
5303: v_new_site_id NUMBER(15);
5304: -- v_original_desc_token VARCHAR2(1000);
5305: v_original_party_number xla_third_parties_v.third_party_number%TYPE;
5306: v_original_site_code xla_third_party_sites_v.third_party_site_code%TYPE;
5307: -- v_new_desc_token VARCHAR2(1000);
5308: v_new_party_number xla_third_parties_v.third_party_number%TYPE;
5309: v_new_site_code xla_third_party_sites_v.third_party_site_code%TYPE;
5310: v_party_type VARCHAR2(1);

Line 5309: v_new_site_code xla_third_party_sites_v.third_party_site_code%TYPE;

5305: v_original_party_number xla_third_parties_v.third_party_number%TYPE;
5306: v_original_site_code xla_third_party_sites_v.third_party_site_code%TYPE;
5307: -- v_new_desc_token VARCHAR2(1000);
5308: v_new_party_number xla_third_parties_v.third_party_number%TYPE;
5309: v_new_site_code xla_third_party_sites_v.third_party_site_code%TYPE;
5310: v_party_type VARCHAR2(1);
5311: v_mapping_flag VARCHAR2(1);
5312: v_entity_id NUMBER(15);
5313: v_src_appl_id NUMBER(15);

Line 5466: xla_third_party_sites_v s1,

5462: ent.ledger_id
5463: FROM xla_events evt,
5464: xla_third_parties_v p1,
5465: xla_third_parties_v p2,
5466: xla_third_party_sites_v s1,
5467: xla_third_party_sites_v s2,
5468: xla_transaction_entities ent,
5469: xla_ledger_options lgopt,
5470: xla_launch_options lnopt

Line 5467: xla_third_party_sites_v s2,

5463: FROM xla_events evt,
5464: xla_third_parties_v p1,
5465: xla_third_parties_v p2,
5466: xla_third_party_sites_v s1,
5467: xla_third_party_sites_v s2,
5468: xla_transaction_entities ent,
5469: xla_ledger_options lgopt,
5470: xla_launch_options lnopt
5471: WHERE ';