DBA Data[Home] [Help]

APPS.PO_COMPARE_REVISIONS dependencies on ICX_UTIL

Line 122: * ICX_UTIL.ITEM_FLEX_SEG function.

118: * HISTORY
119: * 08-AUG-97 Nilo Paredes Created
120: * 22-SEP-97 Rami Haddad Return NULL if no values found.
121: * Obtain item number by calling
122: * ICX_UTIL.ITEM_FLEX_SEG function.
123: ********************************************************************/
124: FUNCTION get_item_number(p_item_id IN NUMBER)
125: RETURN VARCHAR2 AS
126:

Line 134: SELECT icx_util.item_flex_seg( msi.rowid )

130: BEGIN
131:
132: v_progress := '030';
133:
134: SELECT icx_util.item_flex_seg( msi.rowid )
135: INTO v_item_num
136: FROM
137: mtl_system_items msi,
138: financials_system_parameters fsp