APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_THIRD_PARTY_SITES_V

Line 382: FROM XLA_THIRD_PARTY_SITES_V

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

Line 403: FROM XLA_THIRD_PARTY_SITES_V

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

Line 5175: xla_third_party_sites_v s1,

5171: ent.ledger_id
5172: FROM xla_events evt,
5173: xla_third_parties_v p1,
5174: xla_third_parties_v p2,
5175: xla_third_party_sites_v s1,
5176: xla_third_party_sites_v s2,
5177: xla_transaction_entities ent,
5178: xla_ledger_options lgopt,
5179: xla_launch_options lnopt

Line 5176: xla_third_party_sites_v s2,

5172: FROM xla_events evt,
5173: xla_third_parties_v p1,
5174: xla_third_parties_v p2,
5175: xla_third_party_sites_v s1,
5176: xla_third_party_sites_v s2,
5177: xla_transaction_entities ent,
5178: xla_ledger_options lgopt,
5179: xla_launch_options lnopt
5180: WHERE (p_event_id IS NULL OR evt.EVENT_ID = p_event_id)

Line 5253: v_original_site_code xla_third_party_sites_v.third_party_site_code%TYPE;

5249: v_new_party_id NUMBER(15);
5250: v_new_site_id NUMBER(15);
5251: -- v_original_desc_token VARCHAR2(1000);
5252: v_original_party_number xla_third_parties_v.third_party_number%TYPE;
5253: v_original_site_code xla_third_party_sites_v.third_party_site_code%TYPE;
5254: -- v_new_desc_token VARCHAR2(1000);
5255: v_new_party_number xla_third_parties_v.third_party_number%TYPE;
5256: v_new_site_code xla_third_party_sites_v.third_party_site_code%TYPE;
5257: v_party_type VARCHAR2(1);

Line 5256: v_new_site_code xla_third_party_sites_v.third_party_site_code%TYPE;

5252: v_original_party_number xla_third_parties_v.third_party_number%TYPE;
5253: v_original_site_code xla_third_party_sites_v.third_party_site_code%TYPE;
5254: -- v_new_desc_token VARCHAR2(1000);
5255: v_new_party_number xla_third_parties_v.third_party_number%TYPE;
5256: v_new_site_code xla_third_party_sites_v.third_party_site_code%TYPE;
5257: v_party_type VARCHAR2(1);
5258: v_mapping_flag VARCHAR2(1);
5259: v_entity_id NUMBER(15);
5260: v_src_appl_id NUMBER(15);