APPS.RCV_RMA_HEADERS dependencies on HZ_CUST_ACCOUNTS

Line 309: hz_cust_accounts acct

305: AND p_header_record.header_record.customer_id IS NOT NULL THEN
306: SELECT party.party_name
307: INTO p_header_record.header_record.customer_party_name
308: FROM hz_parties party,
309: hz_cust_accounts acct
310: WHERE acct.party_id = party.party_id
311: AND acct.cust_account_id = p_header_record.header_record.customer_id;
312: END IF;
313:

Line 330: hz_cust_accounts acct

326: AND p_header_record.header_record.customer_party_name IS NOT NULL THEN
327: SELECT acct.cust_account_id
328: INTO p_header_record.header_record.customer_id
329: FROM hz_parties party,
330: hz_cust_accounts acct
331: WHERE party.party_id = acct.party_id
332: AND party.party_name = p_header_record.header_record.customer_party_name
333: AND acct.account_number = p_header_record.header_record.customer_account_number;
334: END IF;

Line 357: -- For RMA, we can default customer_id which is actually the cust_account_id in hz_cust_accounts.

353: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
354: ) IS
355: BEGIN
356: NULL;
357: -- For RMA, we can default customer_id which is actually the cust_account_id in hz_cust_accounts.
358: -- If party_name is given and for that party_id, if there exists only one account_id in the accounts table
359: -- then we can default that value.
360: -- If both party_id and party_name is given, then we consider only party_id. If party_id has a wrong value but party_name has a correct value what do we do? Ask PM. In validate
361: -- we use all the values for vendors .Do we need to do the same here also?

Line 367: -- from hz_cust_accounts acct

363:
364:
365: -- If (customer_id is null and (party_id is not null) then
366: -- select count(*) into l_count
367: -- from hz_cust_accounts acct
368: -- where acct.party_id = acct.party_id;
369:
370: -- If (l_count = 1) then /* There is only one acct for this party hence default*/
371: -- select acct.cust_account_id

Line 372: -- from hz_cust_accounts acct

368: -- where acct.party_id = acct.party_id;
369:
370: -- If (l_count = 1) then /* There is only one acct for this party hence default*/
371: -- select acct.cust_account_id
372: -- from hz_cust_accounts acct
373: -- where acct.party_id = party_id;
374: -- end if;
375: -- end if;
376:

Line 379: -- from hz_parties party, hz_cust_accounts acct

375: -- end if;
376:
377: -- If (customer_id is null and (party_name is not null) then
378: -- select count(*)
379: -- from hz_parties party, hz_cust_accounts acct
380: -- where acct.party_id = party.party_id and
381: -- party.party_name = party_name;
382:
383: -- If (l_count = 1) then /* There is only one acct for this party hence default*/

Line 385: -- from hz_parties party, hz_cust_accounts acct

381: -- party.party_name = party_name;
382:
383: -- If (l_count = 1) then /* There is only one acct for this party hence default*/
384: -- select acct.cust_account_id
385: -- from hz_parties party, hz_cust_accounts acct
386: -- where acct.party_id = party.party_id and
387: -- party.party_name = party_name;
388: -- end if;
389:

Line 448: l_status hz_cust_accounts.status%TYPE;

444:
445: PROCEDURE validate_customer_info(
446: p_header_record IN OUT NOCOPY rcv_roi_preprocessor.header_rec_type
447: ) IS
448: l_status hz_cust_accounts.status%TYPE;
449: l_validation_failed BOOLEAN; /*Bug 4344351*/
450: BEGIN
451: l_validation_failed := FALSE;
452:

Line 457: FROM hz_cust_accounts acct

453: IF p_header_record.header_record.customer_id IS NOT NULL THEN
454:
455: SELECT status
456: INTO l_status
457: FROM hz_cust_accounts acct
458: WHERE acct.cust_account_id = p_header_record.header_record.customer_id;
459:
460: IF l_status <> 'A' THEN
461: IF (g_asn_debug = 'Y') THEN