Re: Sort Data, at runtime
From: Iceman <econstantine_at_fattal.com.lb>
Date: 8 Sep 2004 23:29:35 -0700
Message-ID: <92c03dc2.0409082229.1e474b3e_at_posting.google.com>
Date: 8 Sep 2004 23:29:35 -0700
Message-ID: <92c03dc2.0409082229.1e474b3e_at_posting.google.com>
Daniel,
[Quoted] in the POST-QUERY trigger for this datablock I'm running this code
BEGIN
SELECT distinct description, segment1 INTO :ITEM_DESCRIPTION,
:INVENTORY_ITEM_CODE
FROM apps.mtl_system_items
WHERE organization_id = :xxp_quotation_header.organization_id
AND inventory_item_id = :INVENTORY_ITEM_ID;
EXCEPTION WHEN OTHERS THEN NULL;
END;
SET_RECORD_PROPERTY(:SYSTEM.TRIGGER_RECORD, :SYSTEM.TRIGGER_BLOCK,
STATUS, QUERY_STATUS);
This is what keeps them sync.
Received on Thu Sep 09 2004 - 08:29:35 CEST