DBA Data[Home] [Help]

APPS.XLA_THIRD_PARTY_MERGE dependencies on XLA_THIRD_PARTIES_V

Line 335: FROM XLA_THIRD_PARTIES_V

331: -- Validate the passed original third party
332: BEGIN
333: SELECT 'X'
334: INTO v_dummy
335: FROM XLA_THIRD_PARTIES_V
336: WHERE THIRD_PARTY_ID = p_original_third_party_id
337: AND THIRD_PARTY_TYPE = p_third_party_type;
338: EXCEPTION
339: WHEN NO_DATA_FOUND THEN

Line 354: FROM XLA_THIRD_PARTIES_V

350: -- Validate the passed new third party
351: BEGIN
352: SELECT 'X'
353: INTO v_dummy
354: FROM XLA_THIRD_PARTIES_V
355: WHERE THIRD_PARTY_ID = p_new_third_party_id
356: AND THIRD_PARTY_TYPE = p_third_party_type;
357: EXCEPTION
358: WHEN NO_DATA_FOUND THEN

Line 5220: xla_third_parties_v p1,

5216: ent.entity_id,
5217: ent.source_application_id,
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,

Line 5221: xla_third_parties_v p2,

5217: ent.source_application_id,
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,

Line 5305: v_original_party_number xla_third_parties_v.third_party_number%TYPE;

5301: v_old_site_id NUMBER(15);
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;

Line 5308: v_new_party_number xla_third_parties_v.third_party_number%TYPE;

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);
5311: v_mapping_flag VARCHAR2(1);
5312: v_entity_id NUMBER(15);

Line 5464: xla_third_parties_v p1,

5460: ent.entity_id,
5461: ent.source_application_id,
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,

Line 5465: xla_third_parties_v p2,

5461: ent.source_application_id,
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,