EBS:AR或AP的是否过账状态函数

EBS AR或AP的是否过账

-- 获取过帐状态
AP_CHECKS_PKG.GET_POSTING_STATUS(l_check_id IN NUMBER)
AP_INVOICES_PKG.GET_POSTING_STATUS(l_invoice_id IN NUMBER)
AP_INVOICES_UTILITY_PKG.GET_POSTING_STATUS(l_invoice_id IN NUMBER)
AP_INVOICE_LINES_UTILITY_PKG.GET_POSTING_STATUS(p_invoice_id   IN NUMBER, p_line_number  IN NUMBER) 
ARP_RECON_REP.GET_POSTING_STATUS 

　　

补充一下

AR发票是否过账GL，通过 分配表

 RA_CUST_TRX_LINE_GL_DIST_ALL RCTLD的 

,RCTLD.GL_POSTED_DATE -- 当此值非空时，表示已经过账GL，并记录过账日期
,RCTLD.posting_control_id -- '-3' (未过账的默认值)