DBA Data[Home] [Help]

APPS.POS_COMPARE_REVISIONS dependencies on MTL_SYSTEM_ITEMS

Line 113: * MTL_SYSTEM_ITEMS_KFV view.

109: * Resolves the item number.
110: *
111: * ARGUMENTS
112: * p_item_id Unique identifier for item number in
113: * MTL_SYSTEM_ITEMS_KFV view.
114: *
115: * NOTES
116: * Return NULL if an error occurs.
117: *

Line 137: mtl_system_items msi,

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
139: WHERE
140: p_item_id = msi.inventory_item_id (+)
141: AND fsp.inventory_organization_id = NVL(

Line 2656: c_item mtl_system_items_kfv.concatenated_segments%TYPE;

2652: c_item_id NUMBER := NULL;
2653:
2654: c_job_id NUMBER := NULL;
2655: c_org_id NUMBER := NULL;
2656: c_item mtl_system_items_kfv.concatenated_segments%TYPE;
2657: c_job per_jobs.name%TYPE;
2658:
2659: v_progress VARCHAR2(3);
2660:

Line 3884: c_item mtl_system_items_kfv.concatenated_segments%TYPE;

3880: c_item_id NUMBER := NULL;
3881:
3882: c_job_id NUMBER := NULL;
3883: c_org_id NUMBER := NULL;
3884: c_item mtl_system_items_kfv.concatenated_segments%TYPE;
3885: c_job per_jobs.name%TYPE;
3886:
3887: v_progress VARCHAR2(3);
3888:

Line 5170: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;

5166: ********************************************************************/
5167: FUNCTION get_item( p_item_id IN NUMBER, p_org_id IN NUMBER)
5168: RETURN VARCHAR2 AS
5169:
5170: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
5171: v_progress varchar2(3);
5172:
5173: BEGIN
5174:

Line 5180: from mtl_system_items_kfv msik, FINANCIALS_SYSTEM_PARAMS_ALL FSP

5176:
5177:
5178: select msik.concatenated_segments
5179: INTO v_item_name
5180: from mtl_system_items_kfv msik, FINANCIALS_SYSTEM_PARAMS_ALL FSP
5181: where msik.INVENTORY_ITEM_ID = P_ITEM_ID
5182: AND FSP.INVENTORY_ORGANIZATION_ID = NVL(msik.ORGANIZATION_ID,FSP.INVENTORY_ORGANIZATION_ID)
5183: AND FSP.ORG_ID (+)= P_ORG_ID and rownum = 1;
5184: