APPS.POS_COMPARE_REVISIONS dependencies on MTL_SYSTEM_ITEMS_KFV

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 2660: c_item mtl_system_items_kfv.concatenated_segments%TYPE;

2656: c_item_id NUMBER := NULL;
2657:
2658: c_job_id NUMBER := NULL;
2659: c_org_id NUMBER := NULL;
2660: c_item mtl_system_items_kfv.concatenated_segments%TYPE;
2661: c_job per_jobs.name%TYPE;
2662:
2663: v_progress VARCHAR2(3);
2664:

Line 3888: c_item mtl_system_items_kfv.concatenated_segments%TYPE;

3884: c_item_id NUMBER := NULL;
3885:
3886: c_job_id NUMBER := NULL;
3887: c_org_id NUMBER := NULL;
3888: c_item mtl_system_items_kfv.concatenated_segments%TYPE;
3889: c_job per_jobs.name%TYPE;
3890:
3891: v_progress VARCHAR2(3);
3892:

Line 5176: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;

5172: ********************************************************************/
5173: FUNCTION get_item( p_item_id IN NUMBER, p_org_id IN NUMBER)
5174: RETURN VARCHAR2 AS
5175:
5176: v_item_name mtl_system_items_kfv.concatenated_segments%TYPE;
5177: v_progress varchar2(3);
5178:
5179: BEGIN
5180:

Line 5186: from mtl_system_items_kfv msik, FINANCIALS_SYSTEM_PARAMS_ALL FSP

5182:
5183:
5184: select msik.concatenated_segments
5185: INTO v_item_name
5186: from mtl_system_items_kfv msik, FINANCIALS_SYSTEM_PARAMS_ALL FSP
5187: where msik.INVENTORY_ITEM_ID = P_ITEM_ID
5188: AND FSP.INVENTORY_ORGANIZATION_ID = NVL(msik.ORGANIZATION_ID,FSP.INVENTORY_ORGANIZATION_ID)
5189: AND FSP.ORG_ID (+)= P_ORG_ID and rownum = 1;
5190: