eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_REIMB_ACTIVITY_PROCESS dependencies on RA_CUSTOMER_TRX_ALL

Line 88: l_trx_number ra_customer_trx_all.trx_number%TYPE;

84: l_error_message VARCHAR2(600);
85: l_error_code BOOLEAN;
86: l_seed_count NUMBER;
87: l_Acct_count NUMBER;
88: l_trx_number ra_customer_trx_all.trx_number%TYPE;
89: l_purchase_order ra_customer_trx_all.purchase_order%TYPE;
90: l_start_date_commitment ra_customer_trx_all.start_date_commitment%TYPE;
91: l_end_date_commitment ra_customer_trx_all.end_date_commitment%TYPE;
92: l_extended_amount ra_customer_trx_lines_all.extended_amount%TYPE;

Line 89: l_purchase_order ra_customer_trx_all.purchase_order%TYPE;

85: l_error_code BOOLEAN;
86: l_seed_count NUMBER;
87: l_Acct_count NUMBER;
88: l_trx_number ra_customer_trx_all.trx_number%TYPE;
89: l_purchase_order ra_customer_trx_all.purchase_order%TYPE;
90: l_start_date_commitment ra_customer_trx_all.start_date_commitment%TYPE;
91: l_end_date_commitment ra_customer_trx_all.end_date_commitment%TYPE;
92: l_extended_amount ra_customer_trx_lines_all.extended_amount%TYPE;
93: l_agree_num VARCHAR2(25);

Line 90: l_start_date_commitment ra_customer_trx_all.start_date_commitment%TYPE;

86: l_seed_count NUMBER;
87: l_Acct_count NUMBER;
88: l_trx_number ra_customer_trx_all.trx_number%TYPE;
89: l_purchase_order ra_customer_trx_all.purchase_order%TYPE;
90: l_start_date_commitment ra_customer_trx_all.start_date_commitment%TYPE;
91: l_end_date_commitment ra_customer_trx_all.end_date_commitment%TYPE;
92: l_extended_amount ra_customer_trx_lines_all.extended_amount%TYPE;
93: l_agree_num VARCHAR2(25);
94: TYPE ref_type IS REF CURSOR ;

Line 91: l_end_date_commitment ra_customer_trx_all.end_date_commitment%TYPE;

87: l_Acct_count NUMBER;
88: l_trx_number ra_customer_trx_all.trx_number%TYPE;
89: l_purchase_order ra_customer_trx_all.purchase_order%TYPE;
90: l_start_date_commitment ra_customer_trx_all.start_date_commitment%TYPE;
91: l_end_date_commitment ra_customer_trx_all.end_date_commitment%TYPE;
92: l_extended_amount ra_customer_trx_lines_all.extended_amount%TYPE;
93: l_agree_num VARCHAR2(25);
94: TYPE ref_type IS REF CURSOR ;
95: agree_cur ref_type;

Line 751: l_trx_number ra_customer_trx_all.trx_number%TYPE;

747: l_main_cursor INTEGER;
748: --declare cursors
749: TYPE ref_type IS REF CURSOR ;
750: segment_cur ref_type;
751: l_trx_number ra_customer_trx_all.trx_number%TYPE;
752: l_purchase_order ra_customer_trx_all.purchase_order%TYPE;
753: l_start_date_commitment ra_customer_trx_all.start_date_commitment%TYPE;
754: l_end_date_commitment ra_customer_trx_all.end_date_commitment%TYPE;
755: l_extended_amount ra_customer_trx_lines_all.extended_amount%TYPE;

Line 752: l_purchase_order ra_customer_trx_all.purchase_order%TYPE;

748: --declare cursors
749: TYPE ref_type IS REF CURSOR ;
750: segment_cur ref_type;
751: l_trx_number ra_customer_trx_all.trx_number%TYPE;
752: l_purchase_order ra_customer_trx_all.purchase_order%TYPE;
753: l_start_date_commitment ra_customer_trx_all.start_date_commitment%TYPE;
754: l_end_date_commitment ra_customer_trx_all.end_date_commitment%TYPE;
755: l_extended_amount ra_customer_trx_lines_all.extended_amount%TYPE;
756: l_agree_num VARCHAR2(25);

Line 753: l_start_date_commitment ra_customer_trx_all.start_date_commitment%TYPE;

749: TYPE ref_type IS REF CURSOR ;
750: segment_cur ref_type;
751: l_trx_number ra_customer_trx_all.trx_number%TYPE;
752: l_purchase_order ra_customer_trx_all.purchase_order%TYPE;
753: l_start_date_commitment ra_customer_trx_all.start_date_commitment%TYPE;
754: l_end_date_commitment ra_customer_trx_all.end_date_commitment%TYPE;
755: l_extended_amount ra_customer_trx_lines_all.extended_amount%TYPE;
756: l_agree_num VARCHAR2(25);
757: l_amount VARCHAR2(50);

Line 754: l_end_date_commitment ra_customer_trx_all.end_date_commitment%TYPE;

750: segment_cur ref_type;
751: l_trx_number ra_customer_trx_all.trx_number%TYPE;
752: l_purchase_order ra_customer_trx_all.purchase_order%TYPE;
753: l_start_date_commitment ra_customer_trx_all.start_date_commitment%TYPE;
754: l_end_date_commitment ra_customer_trx_all.end_date_commitment%TYPE;
755: l_extended_amount ra_customer_trx_lines_all.extended_amount%TYPE;
756: l_agree_num VARCHAR2(25);
757: l_amount VARCHAR2(50);
758: l_select_mod VARCHAR2(2000);

Line 1042: FROM ra_customer_trx_all h,

1038: l_trx_sql:='SELECT h.trx_number, h.purchase_order,
1039: h.start_date_commitment,
1040: h.end_date_commitment,
1041: l.extended_amount
1042: FROM ra_customer_trx_all h,
1043: ra_customer_trx_lines_all l
1044: WHERE h.set_of_books_id = :g_ledger_id
1045: AND h.trx_number = :g_agree_num
1046: AND h.customer_trx_id = l.customer_trx_id';

Line 1484: FROM ra_customer_trx_all r,

1480: FROM fnd_flex_values_vl f
1481: where flex_value_set_id = :g_flex_reimb_value_id
1482: AND flex_value BETWEEN '||''''||l_low_reimb||''''||' AND '||''''||l_high_reimb||''''||'
1483: AND f.flex_value in (SELECT r.trx_number
1484: FROM ra_customer_trx_all r,
1485: ra_cust_trx_types_all t
1486: WHERE r.set_of_books_id = :g_ledger_id
1487: AND r.invoice_currency_code = :g_currency
1488: AND r.cust_trx_type_id = t.cust_trx_type_id

Line 1498: FROM ra_customer_trx_all r,

1494: g_agree_sql:= 'SELECT f.flex_value
1495: FROM fnd_flex_values_vl f
1496: where flex_value_set_id = :g_flex_reimb_value_id
1497: AND f.flex_value in(SELECT r.trx_number
1498: FROM ra_customer_trx_all r,
1499: ra_cust_trx_types_all t
1500: WHERE r.set_of_books_id = :g_ledger_id
1501: AND r.invoice_currency_code = :g_currency
1502: AND r.cust_trx_type_id = t.cust_trx_type_id