APPS.FARX_AJ dependencies on FA_BOOKS

Line 119: FA_BOOKS BK_IN,

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
123: from per_people_f

Line 120: FA_BOOKS BK_OUT,

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
123: from per_people_f
124: where TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE

Line 134: FA_BOOKS ACTIVE_BK,

130: PO_VENDORS PO_IN,
131: PO_VENDORS PO_OUT,
132: FA_ADDITIONS AD,
133: GL_CODE_COMBINATIONS DHCC,
134: FA_BOOKS ACTIVE_BK,
135: FA_ADDITIONS_B GAD
136: WHERE
137: TH.TRANSACTION_TYPE_CODE IN ('ADJUSTMENT','CIP ADJUSTMENT') AND
138: TH.BOOK_TYPE_CODE = h_book AND

Line 710: from fa_books bk_in,

706: to_number (null),
707: null,
708: round(sum((bk_in.cost - nvl(bk_out.cost,0)) *
709: dh.units_assigned / ah.units),2)
710: from fa_books bk_in,
711: fa_books bk_out,
712: fa_distribution_history dh,
713: fa_lookups lu,
714: gl_code_combinations glcc_fa,

Line 711: fa_books bk_out,

707: null,
708: round(sum((bk_in.cost - nvl(bk_out.cost,0)) *
709: dh.units_assigned / ah.units),2)
710: from fa_books bk_in,
711: fa_books bk_out,
712: fa_distribution_history dh,
713: fa_lookups lu,
714: gl_code_combinations glcc_fa,
715: gl_code_combinations glcc_ar,