APPS.OZF_CLAIM_PVT dependencies on OE_TRANSACTION_TYPES_VL
Line 8457: FROM oe_transaction_types_vl
8453: l_lookup_code_count number := 0;
8454:
8455: CURSOR order_type_count_csr(p_id in number) is
8456: SELECT count(transaction_type_id) 8457: FROM oe_transaction_types_vl 8458: WHERE transaction_type_code = 'ORDER'
8459: AND order_category_code IN ('MIXED', 'RETURN')
8460: AND default_inbound_line_type_id IS NOT NULL
8461: AND transaction_type_id = p_id;