APPS.FV_SF1080_TRANSACTION dependencies on RA_CUSTOMER_TRX

Line 256: FROM RA_CUSTOMER_TRX rct,

252: hzl.address4 cust_address4,
253: hzl.city cust_city,
254: hzl.state cust_state,
255: hzl.postal_code cust_postal_code
256: FROM RA_CUSTOMER_TRX rct,
257: hz_locations hzl, hz_cust_acct_sites hzcas,
258: hz_party_sites hzps , HZ_CUST_SITE_USEs hzcsu,hz_cust_accounts hzca, hz_parties hzp
259: WHERE rct.set_of_books_id = parm_set_of_books_id
260: AND rct.bill_to_customer_id = hzca.cust_account_id

Line 301: FROM RA_CUSTOMER_TRX

297: FROM hz_cust_accounts hzca
298: WHERE cust_account_id like nvl(parm_customer,'%')))
299: and rct.customer_trx_id in
300: (SELECT CUSTOMER_TRX_ID
301: FROM RA_CUSTOMER_TRX
302: WHERE nvl(status_trx,'-1') LIKE decode(parm_open_invoices_only,'Y','OP','N','%'))
303: AND rct.customer_trx_id IN
304: (SELECT CUSTOMER_TRX_ID
305: FROM RA_CUSTOMER_TRX

Line 305: FROM RA_CUSTOMER_TRX

301: FROM RA_CUSTOMER_TRX
302: WHERE nvl(status_trx,'-1') LIKE decode(parm_open_invoices_only,'Y','OP','N','%'))
303: AND rct.customer_trx_id IN
304: (SELECT CUSTOMER_TRX_ID
305: FROM RA_CUSTOMER_TRX
306: WHERE batch_id IN
307: (SELECT BATCH_ID
308: FROM RA_BATCHES
309: WHERE BATCH_ID = decode(parm_batch,null,BATCH_ID,parm_batch))

Line 313: FROM RA_CUSTOMER_TRX rct

309: WHERE BATCH_ID = decode(parm_batch,null,BATCH_ID,parm_batch))
310: OR (nvl(BATCH_ID,'99') LIKE decode(parm_print_choice,'SEL','99','NEW','99')))
311: AND rct.customer_trx_id IN
312: (SELECT rct.CUSTOMER_TRX_ID
313: FROM RA_CUSTOMER_TRX rct
314: WHERE (nvl(rct.printing_count,'99') like
315: decode(parm_print_choice,'NEW','99','%'))
316: AND (nvl(to_char(rct.printing_original_date,'DD-MM-YYYY'),'01-01-1999') like
317: decode(parm_print_choice,'NEW','01-01-1999','%'))

Line 441: FROM RA_CUSTOMER_TRX_LINES

437: LINE_COUNT := 0;
438: line_count_flag := 0;
439: SELECT COUNT(*)
440: INTO LINE_COUNT
441: FROM RA_CUSTOMER_TRX_LINES
442: WHERE CUSTOMER_TRX_ID = TS_REPORT_HEADER_ENTRY.CUSTOMER_TRX_ID;
443: ---FV_UTILITY.DEBUG_MESG('line_count = ' ||line_count);
444: EXCEPTION
445: WHEN NO_DATA_FOUND THEN

Line 531: FROM RA_CUSTOMER_TRX_LINES rtl

527: rtl.QUANTITY_INVOICED,
528: rtl.UNIT_SELLING_PRICE,
529: rtl.UOM_CODE,
530: segment
531: FROM RA_CUSTOMER_TRX_LINES rtl
532: WHERE rtl.customer_trx_id =
533: TS_REPORT_HEADER_ENTRY.CUSTOMER_TRX_ID
534: AND rtl.line_number = line_counter;
535:

Line 562: FROM RA_CUSTOMER_TRX_LINES rtl

558: rtl.QUANTITY_INVOICED,
559: rtl.UNIT_SELLING_PRICE,
560: rtl.UOM_CODE,
561: segment
562: FROM RA_CUSTOMER_TRX_LINES rtl
563: WHERE rtl.customer_trx_id =
564: TS_REPORT_HEADER_ENTRY.CUSTOMER_TRX_ID;
565: END IF;
566: END;