DBA Data[Home] [Help]

APPS.CST_ACCOUNTINGPERIOD_PUB dependencies on MTL_TRANSACTIONS_INTERFACE

Line 273: -- on MTL_TRANSACTIONS_INTERFACE filtered by process_flag = 9

269: l_stmt_num := 80;
270: -- Pending material transactions (optional)
271: -- Need to ignore Ship Confirm Open Interface detail records.
272: -- these are stored in WSH_PICKING_DETAILS_INTERFACE, which is a view
273: -- on MTL_TRANSACTIONS_INTERFACE filtered by process_flag = 9
274: BEGIN
275:
276: SELECT COUNT(*)
277: INTO l_tcount

Line 278: FROM mtl_transactions_interface

274: BEGIN
275:
276: SELECT COUNT(*)
277: INTO l_tcount
278: FROM mtl_transactions_interface
279: WHERE organization_id = p_org_id
280: AND transaction_date <= l_sched_close_date
281: AND process_flag <> 9;
282: