DBA Data[Home] [Help]

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;