Unposted entry in OPM
Hi,
We find some unposted entry in OPM.material is consumed but not booked in allocation and stock of material is also not update.We use following query to find unposted entry.
/*----------------------------------------------------------*/
SELECT bas.organization_id org_id,
xxscl_get_orgnm (bas.organization_id) org_nm,
bas.inventory_item_id AS item_id,
xxscl_inv_item_info_pkg.xxscl_get_itm_code (bas.inventory_item_id,
101)
item,
dtl.allocdtl_id,
mst.alloc_code,
dtl.allocated_expense_amt,
NVL (dtl.period_qty, 0) period_qty,
bas.cmpntcls_id,
bas.analysis_code#1 analysis_code,
dtl.alloc_id,
dtl.line_no,
dtl.ac_status,