[Home] [Help]
124: PROCEDURE validate_item
125: (
126: x_return_status OUT NOCOPY VARCHAR2,
127: x_msg_data OUT NOCOPY VARCHAR2,
128: p_item_number IN MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE,
129: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE
130: )
131: IS
132:
129: p_x_inventory_item_id IN OUT NOCOPY MTL_SYSTEM_ITEMS.inventory_item_id%TYPE
130: )
131: IS
132:
133: CURSOR get_rec_from_value ( c_item_number MTL_SYSTEM_ITEMS_KFV.concatenated_segments%TYPE )
134: IS
135: SELECT DISTINCT MI.inventory_item_id,
136: MI.inventory_item_flag,
137: MI.eng_item_flag,
139: MI.wip_supply_type,
140: MI.eam_item_type,
141: MI.comms_nl_trackable_flag,
142: MI.serv_req_enabled_code
143: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
144: WHERE DECODE(G_APPLN_USAGE,'PM','Y',MP.eam_enabled_flag )='Y'
145: AND MP.organization_id = MI.organization_id
146: AND MI.concatenated_segments = c_item_number
147: AND MI.enabled_flag = 'Y'
159: MI.wip_supply_type,
160: MI.eam_item_type,
161: MI.comms_nl_trackable_flag,
162: MI.serv_req_enabled_code
163: FROM MTL_PARAMETERS MP, MTL_SYSTEM_ITEMS_KFV MI
164: WHERE DECODE(G_APPLN_USAGE,'PM','Y',MP.eam_enabled_flag )='Y'
165: AND MP.organization_id = MI.organization_id
166: AND MI.inventory_item_id = c_inventory_item_id
167: AND MI.enabled_flag = 'Y'
624: ahl_mc_headers_b mch,
625: ahl_mc_path_position_nodes mcp,
626: --ahl_item_associations_v igass ,
627: ahl_item_associations_vl igass, --priyan changes due to performance reasons , Refer Bug # 5078530
628: mtl_system_items_kfv MTL,
629: mtl_item_status STAT,
630: fnd_lookup_values_vl IT
631: WHERE mch.mc_header_id = mcr.mc_header_id
632: and mch.mc_id = mcp.mc_id