无一揽子协议不允许下达采购订单-优快云博客

本文介绍了一个Oracle Purchasing中WHEN-VALIDATE-RECORD触发器的应用实例，该触发器用于检查是否存在有效的批价协议，若不存在则阻止采购订单的创建。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

应用	Oracle Purchasing				层 Level			Function
函数名 Funcgtion Name	PO_POXPOEPO				表单名 Form Name			POXPOEPO
说明 Description	无一揽子协议不允许下达采购订单
条件 Condition	触发器事件 Tirgger Event			WHEN-VALIDATE-RECORD
	触发器对象 Tirgger Object			PO_LINES
	条件 Condition			not exists (select 'X' from po.po_headers_all pha, po.po_lines_all pla, po.po_line_locations_all pll, po.po_vendors pv, po.po_vendor_sites_all pvs, inv.mtl_system_items_b msi where pha.po_header_id = pla.po_header_id and pll.po_line_id(+) = pla.po_line_id and pha.org_id = * and pv.vendor_id = pha.vendor_id and pha.type_lookup_code = 'BLANKET' and nvl(pha.cancel_flag, 'N') = 'N' and nvl(pll.cancel_flag, 'N') = 'N' and nvl(pla.cancel_flag, 'N') = 'N' and nvl(pha.closed_code, 'OPEN') = 'OPEN' and nvl(pla.closed_code, 'OPEN') = 'OPEN' and nvl(pll.closed_code, 'OPEN') = 'OPEN' and pvs.vendor_id = pv.vendor_id and pha.authorization_status = 'APPROVED' and pvs.vendor_site_id = pha.vendor_site_id and pvs.org_id = pha.org_id and (trunc(pll.end_date) >= trunc(sysdate) or pll.end_date is null) and msi.inventory_item_id = pla.item_id and msi.organization_id = * and msi.segment1 =:PO_LINES.ITEM_NUMBER and pv.vendor_name=:PO_HEADERS.VENDOR_NAME and pvs.vendor_site_code=:PO_HEADERS.VENDOR_SITE_CODE and pha.currency_code =:PO_HEADERS.CURRENCY_CODE ) and :PO_HEADERS.DOC_TYPE_NAME = '标准采购订单' and :PO_HEADERS.VENDOR_NAME like 'R%临时%'
	处理模式 Processing Mode			Not in Enter-Query Mode
	上下文层/值 Contest Level/Value			Responsibility/***职责
活动 Actions	序号 seq	特性 Type	说明 Description			语言 Language	消息类型 Message Type		Error
	10	Message	/			ALL	消息文本 Message Type		无一揽子采购协议不允下达采购订单!
	20	Builtin	/			ALL	内置类型 Builtin Type		RAISE FORM_TIRGGER_FAILURE
处理模式	讯息提醒模式
作业	讯息型态:显示
	讯息内容: 无一揽子采购协议不允下达采购订单!