DBA Data[Home] [Help]

APPS.CSP_VALIDATE_PUB dependencies on MTL_SYSTEM_ITEMS

Line 113: from mtl_system_items_kfv

109: ELSE
110: BEGIN
111: -- validate whether the inventory_item_is exists in the given oranization_id
112: select inventory_item_id into l_check_existence
113: from mtl_system_items_kfv
114: where inventory_item_id = p_inventory_item_id
115: and organization_id = P_organization_id;
116: EXCEPTION
117: WHEN NO_DATA_FOUND THEN

Line 125: fnd_message.set_token('TABLE', 'MTL_SYSTEM_ITEMS', TRUE);

121: WHEN OTHERS THEN
122: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
123: fnd_message.set_token('ERR_FIELD', 'p_inventory_item_id', TRUE);
124: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
125: fnd_message.set_token('TABLE', 'MTL_SYSTEM_ITEMS', TRUE);
126: FND_MSG_PUB.ADD;
127: RAISE EXCP_USER_DEFINED;
128: END;
129: END IF;

Line 133: from mtl_system_items

129: END IF;
130:
131: -- check whether the item is under serial control
132: select serial_number_control_code into l_serial_control_code
133: from mtl_system_items
134: where organization_id = p_organization_id
135: and inventory_item_id = p_inventory_item_id;
136:
137: IF l_serial_control_code <> 1 THEN

Line 143: from mtl_system_items

139: END IF;
140:
141: -- check whether the item is under revision control
142: select revision_qty_control_code into l_revision_control_code
143: from mtl_system_items
144: where organization_id = p_organization_id
145: and inventory_item_id = p_inventory_item_id;
146:
147: IF l_revision_control_code <> 1 THEN

Line 153: from mtl_system_items

149: END IF;
150:
151: -- check whether the item is under lot control
152: select lot_control_code into l_lot_control_code
153: from mtl_system_items
154: where organization_id = p_organization_id
155: and inventory_item_id = p_inventory_item_id;
156:
157: IF l_lot_control_code <> 1 THEN

Line 347: from mtl_system_items_kfv

343: IF p_inventory_item_id IS NULL THEN
344: RAISE EXCP_NO_REQ_PARAMETERS;
345: ELSE -- verify whether the item is assigned to the given organization_id
346: select count(organization_id) into l_count_qty
347: from mtl_system_items_kfv
348: where organization_id = p_organization_id
349: and inventory_item_id = p_inventory_item_id;
350:
351: IF l_count_qty = 0 THEN

Line 360: from mtl_system_items

356: END IF;
357:
358: -- check whether the item is under serial control
359: select serial_number_control_code into l_serial_control_code
360: from mtl_system_items
361: where organization_id = p_organization_id
362: and inventory_item_id = p_inventory_item_id;
363:
364: IF l_serial_control_code <> 1 THEN

Line 370: from mtl_system_items

366: END IF;
367:
368: -- check whether the item is under revision control
369: select revision_qty_control_code into l_revision_control_code
370: from mtl_system_items
371: where organization_id = p_organization_id
372: and inventory_item_id = p_inventory_item_id;
373:
374: IF l_revision_control_code <> 1 THEN

Line 380: from mtl_system_items

376: END IF;
377:
378: -- check whether the item is under lot control
379: select lot_control_code into l_lot_control_code
380: from mtl_system_items
381: where organization_id = p_organization_id
382: and inventory_item_id = p_inventory_item_id;
383:
384: IF l_lot_control_code <> 1 THEN

Line 496: from mtl_system_items

492: revision_qty_control_code
493: into l_serial_control_code,
494: l_lot_control_code,
495: l_revision_control_code
496: from mtl_system_items
497: where organization_id = p_organization_id
498: and inventory_item_id = p_inventory_item_id;
499:
500: IF l_serial_control_code <> 1 THEN

Line 620: from mtl_system_items

616: revision_qty_control_code
617: into l_serial_control_code,
618: l_lot_control_code,
619: l_revision_control_code
620: from mtl_system_items
621: where organization_id = p_organization_id
622: and inventory_item_id = p_inventory_item_id;
623:
624: IF l_serial_control_code <> 1 THEN