DBA Data[Home] [Help]

APPS.GMF_PERIODCLOSE_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 130: FROM mtl_material_transactions_temp

126: -- Unprocessed Material transactions (must resolve)
127: BEGIN
128: SELECT COUNT(*)
129: INTO l_tcount
130: FROM mtl_material_transactions_temp
131: WHERE organization_id = p_org_id
132: AND trunc(transaction_date) <= l_sched_close_date
133: AND NVL(transaction_status,0) <> 2; -- 2 indicates a save-only status
134: