[Home] [Help]
115: PROCEDURE validate_item
116: (
117: x_return_status OUT NOCOPY VARCHAR2,
118: x_msg_data OUT NOCOPY VARCHAR2,
119: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
120: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE
121: )
122: IS
123:
120: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE
121: )
122: IS
123:
124: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE )
125: IS
126: SELECT DISTINCT MI.inventory_item_id,
127: MI.inventory_item_flag,
128: MI.eng_item_flag,
130: MI.wip_supply_type,
131: MI.eam_item_type,
132: MI.comms_nl_trackable_flag,
133: MI.serv_req_enabled_code
134: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
135: WHERE DECODE(G_APPLN_USAGE,'PM','Y',MP.eam_enabled_flag )='Y'
136: AND MP.organization_id = MI.organization_id
137: AND MI.concatenated_segments = c_item_number
138: AND MI.enabled_flag = 'Y'
150: MI.wip_supply_type,
151: MI.eam_item_type,
152: MI.comms_nl_trackable_flag,
153: MI.serv_req_enabled_code
154: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
155: WHERE DECODE(G_APPLN_USAGE,'PM','Y',MP.eam_enabled_flag )='Y'
156: AND MP.organization_id = MI.organization_id
157: AND MI.inventory_item_id = c_inventory_item_id
158: AND MI.enabled_flag = 'Y'
613: ahl_mc_headers_b mch,
614: ahl_mc_path_position_nodes mcp,
615: --ahl_item_associations_v igass ,
616: ahl_item_associations_vl igass, --priyan changes due to performance reasons , Refer Bug # 5078530
617: mtl_system_items_kfv MTL,
618: mtl_item_status STAT,
619: fnd_lookup_values_vl IT
620: WHERE mch.mc_header_id = mcr.mc_header_id
621: and mch.mc_id = mcp.mc_id