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.FARX_AJ dependencies on FA_TRANSACTION_HEADERS

Line 121: FA_TRANSACTION_HEADERS TH,

117: FA_ASSET_INVOICES AI_IN,
118: FA_ASSET_INVOICES AI_OUT,
119: FA_BOOKS BK_IN,
120: FA_BOOKS BK_OUT,
121: FA_TRANSACTION_HEADERS TH,
122: ( select full_name name, employee_number, person_id employee_id
123: from per_people_f
124: where TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE
125: ) EMP,

Line 468: fa_transaction_headers th

464: fa_additions ad,
465: fa_distribution_history dh,
466: fa_asset_history ah,
467: fa_asset_invoices ai_in,
468: fa_transaction_headers th
469: where
470: lu.lookup_code = 'CIP ADDITION' and
471: lu.lookup_type = 'FAXOLTRX' and
472: ah.asset_type = 'CIP' and

Line 524: fa_transaction_headers th

520: fa_additions ad,
521: fa_distribution_history dh,
522: fa_asset_history ah,
523: fa_asset_invoices ai_in,
524: fa_transaction_headers th
525: where
526: lu.lookup_code = 'ADDITION' and
527: lu.lookup_type = 'FAXOLTRX' and
528: ah.asset_type <> 'CIP' and

Line 581: fa_transaction_headers tht,

577: fa_distribution_history dh,
578: fa_asset_history ah,
579: fa_invoice_transactions it,
580: fa_asset_invoices ai_in,
581: fa_transaction_headers tht,
582: fa_transaction_headers th
583: where it.book_type_code = h_book and
584: it.invoice_transaction_id = th.invoice_transaction_id and
585: it.transaction_type = 'MASS ADDITION'

Line 582: fa_transaction_headers th

578: fa_asset_history ah,
579: fa_invoice_transactions it,
580: fa_asset_invoices ai_in,
581: fa_transaction_headers tht,
582: fa_transaction_headers th
583: where it.book_type_code = h_book and
584: it.invoice_transaction_id = th.invoice_transaction_id and
585: it.transaction_type = 'MASS ADDITION'
586: and lu.lookup_code = decode(th.transaction_type_code,

Line 652: fa_transaction_headers th

648: fa_additions ad,
649: fa_asset_history ah,
650: fa_category_books cat_bk,
651: fa_asset_invoices ai_in,
652: fa_transaction_headers th
653: where
654: lu.lookup_code = decode(ah.asset_type, 'CIP',
655: 'CIP ADDITION', 'ADDITION') and
656: lu.lookup_type = 'FAXOLTRX'

Line 719: fa_transaction_headers th

715: gl_code_combinations glcc_ar,
716: fa_additions ad,
717: fa_asset_history ah,
718: fa_category_books cat_bk,
719: fa_transaction_headers th
720: where
721: th.book_type_code = h_book and
722: th.invoice_transaction_id is null and
723: th.transaction_type_code in ('CIP ADDITION', 'CIP ADDITION/VOID',

Line 807: fa_transaction_headers th,

803: gl_code_combinations glcc_ar,
804: fa_additions ad,
805: fa_asset_history ah,
806: fa_category_books cat_bk,
807: fa_transaction_headers th,
808: fa_invoice_transactions it,
809: fa_asset_invoices ai_in
810: where it.book_type_code = h_book and
811: ((it.transaction_type = 'MASS ADDITION' and

Line 894: fa_transaction_headers th,

890: gl_code_combinations glcc_ar,
891: fa_additions ad,
892: fa_asset_history ah,
893: fa_category_books cat_bk,
894: fa_transaction_headers th,
895: fa_invoice_transactions it,
896: fa_asset_invoices ai_in,
897: fa_adjustments adj1
898: