DBA Data[Home] [Help]

APPS.GMF_PERIODCLOSE_PUB dependencies on MTL_TRANSACTIONS_INTERFACE

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

215: l_stmt_num := 40;
216: -- Pending material transactions (optional)
217: -- Need to ignore Ship Confirm Open Interface detail records.
218: -- these are stored in WSH_PICKING_DETAILS_INTERFACE, which is a view
219: -- on MTL_TRANSACTIONS_INTERFACE filtered by process_flag = 9
220: BEGIN
221:
222: SELECT COUNT(*)
223: INTO x_pend_matl

Line 224: FROM mtl_transactions_interface

220: BEGIN
221:
222: SELECT COUNT(*)
223: INTO x_pend_matl
224: FROM mtl_transactions_interface
225: WHERE organization_id = p_org_id
226: AND transaction_date <= l_sched_close_date
227: AND process_flag <> 9;
228: