DBA Data[Home] [Help]

APPS.CSE_DEPLOYMENT_GRP dependencies on MTL_SYSTEM_ITEMS_KFV

Line 523: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;

519: l_hz_location_id NUMBER;
520: i PLS_INTEGER := 0;
521: l_org_id NUMBER;
522: l_incurred_by_org_id PA_EXPENDITURES_ALL.INCURRED_BY_ORGANIZATION_ID%TYPE;
523: l_item_name MTL_SYSTEM_ITEMS_KFV.CONCATENATED_SEGMENTS%TYPE;
524: l_user_id NUMBER DEFAULT FND_GLOBAL.USER_ID;
525: l_transaction_source PA_EXPENDITURE_ITEMS_ALL.TRANSACTION_SOURCE%TYPE;
526: l_sysdate DATE:=sysdate;
527: l_ref_sufix NUMBER;

Line 717: FROM mtl_system_items_kfv

713: debug(' instance_id : '||p_trf_pa_attr_rec.instance_id);
714:
715: SELECT concatenated_segments
716: INTO l_item_name
717: FROM mtl_system_items_kfv
718: WHERE inventory_item_id = p_trf_pa_attr_rec.item_id
719: AND organization_id = p_trf_pa_attr_rec.inv_master_org_id;
720:
721: debug(' item : '||l_item_name);