Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Sort Data, at runtime

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@posting.google.com>


Daniel,

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 - 01:29:35 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US