DBA Data[Home] [Help]

APPS.GR_REG_PRINT_DOC dependencies on MTL_SYSTEM_ITEMS

Line 102: from mtl_system_items

98:
99: /* Used to retrieve Item Code */
100: CURSOR c_get_item_code(p_organization_id NUMBER, p_item_id NUMBER)IS
101: Select segment1
102: from mtl_system_items
103: where inventory_item_id = p_item_id
104: and organization_id = p_organization_id;
105:
106: /* M.Grosser 12-Apr-2005 End of changes */

Line 464: from mtl_system_items

460:
461: /* Used to retrieve Item Code */
462: CURSOR c_get_item_code(p_organization_id NUMBER, p_item_id NUMBER)IS
463: Select segment1
464: from mtl_system_items
465: where inventory_item_id = p_item_id
466: and organization_id = p_organization_id;
467:
468: /* Used to Check the Item Regulatory Item or not

Line 807: SELECT inventory_item_id from mtl_system_items

803: SELECT ORGANIZATION_CODE from mtl_parameters
804: where ORGANIZATION_ID = l_orgn_id;
805:
806: Cursor C_get_item_id(l_orgn_id number, l_item_code varchar2) IS
807: SELECT inventory_item_id from mtl_system_items
808: where ORGANIZATION_ID = l_orgn_id
809: and SEGMENT1 = l_item_code;
810:
811: