APPS.FARX_AJ dependencies on FA_ASSET_INVOICES

Line 117: FA_ASSET_INVOICES AI_IN,

113: NULL),
114: DECODE(IT.TRANSACTION_TYPE, NULL, 'NO', 'YES'),
115: GAD.ASSET_NUMBER GROUP_ASSET_NUMBER
116: FROM FA_INVOICE_TRANSACTIONS IT,
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,

Line 118: FA_ASSET_INVOICES AI_OUT,

114: DECODE(IT.TRANSACTION_TYPE, NULL, 'NO', 'YES'),
115: GAD.ASSET_NUMBER GROUP_ASSET_NUMBER
116: FROM FA_INVOICE_TRANSACTIONS IT,
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

Line 467: fa_asset_invoices ai_in,

463: gl_code_combinations glcc_ar,
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

Line 523: fa_asset_invoices ai_in,

519: gl_code_combinations glcc_ar,
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

Line 580: fa_asset_invoices ai_in,

576: fa_additions ad,
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

Line 651: fa_asset_invoices ai_in,

647: gl_code_combinations glcc_ar,
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

Line 798: from fa_asset_invoices ai_out,

794: nvl(ai_in.fixed_assets_cost,0),
795: nvl(ai_in.fixed_assets_cost, 0) -
796: nvl(ai_in.payables_cost, 0))
797: * (dh.units_assigned / ah.units)),2)
798: from fa_asset_invoices ai_out,
799: po_vendors po_ai_in,
800: fa_lookups lu,
801: fa_distribution_history dh,
802: gl_code_combinations glcc_fa,

Line 809: fa_asset_invoices ai_in

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
812: nvl(ai_in.fixed_assets_cost,0) <>
813: nvl(ai_in.payables_cost,0)) or

Line 885: from fa_asset_invoices ai_out,

881: nvl(ai_in.fixed_assets_cost,0),
882: ai_out.asset_id,
883: -nvl(ai_out.fixed_assets_cost,0),0)
884: * (dh.units_assigned / ah.units)),2)
885: from fa_asset_invoices ai_out,
886: po_vendors po_ai_in,
887: fa_lookups lu,
888: fa_distribution_history dh,
889: gl_code_combinations glcc_fa,

Line 896: fa_asset_invoices ai_in,

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:
899: /* SLA Changes */
900: ,xla_ae_headers headers

Line 941: and ai_out.asset_id = ai_in.asset_id /* Added for High Cost SQL - to remove FTS on FA-ASSET_INVOICES*/

937: = ai_in.invoice_transaction_id_in and
938: ai_out.asset_invoice_id = ai_in.asset_invoice_id
939: and ai_in.po_vendor_id = po_ai_in.vendor_id(+)
940:
941: and ai_out.asset_id = ai_in.asset_id /* Added for High Cost SQL - to remove FTS on FA-ASSET_INVOICES*/
942:
943:
944: and adj1.book_type_code = h_book and
945: adj1.asset_id = th.asset_id