PL/SQL (MOSC)

MOSC Banner

Connection between two tables

edited Feb 15, 2012 9:18PM in PL/SQL (MOSC) 2 commentsAnswered
HI,

   Just a simple question.. What is the link between ce_statement_lines and ar_cash_receipts_all except from bank_trx_number of statement line and receipt number of cash receipt.

 I need to get data which is already reconciled but still has a status of remitted.

HERE IS THE SCRIPT

select csl.line_number
      ,cra.org_id
      ,crh.status
      ,crh.current_record_flag
      ,crh.factor_flag
      ,csr.auto_reconciled_flag
      ,csr.current_record_flag
      ,csh.statement_number
      ,csl.bank_trx_number
      ,aba.bank_account_num
  from ce_statement_headers_all csh
      ,ce_statement_lines csl
      ,ap_bank_accounts_all aba

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center