DBA Data[Home] [Help]

APPS.FV_SF1080_TRANSACTION dependencies on RA_CUSTOMER_TRX_LINES

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;