APPS.INVPULI2 dependencies on MTL_ITEM_TEMPLATES

Line 33: FROM mtl_item_templates

29:
30: CURSOR check_template_name (cp_template_name VARCHAR2) IS
31: SELECT template_id,
32: context_organization_id
33: FROM mtl_item_templates
34: WHERE template_name = cp_template_name;
35:
36: CURSOR check_template_id (cp_template_id NUMBER) IS
37: SELECT template_id,

Line 39: FROM mtl_item_templates

35:
36: CURSOR check_template_id (cp_template_id NUMBER) IS
37: SELECT template_id,
38: context_organization_id
39: FROM mtl_item_templates
40: WHERE template_id = cp_template_id;
41:
42: /*Added for bug 8848620 fp for 7581972 and 8808831 */
43:

Line 55: FROM MTL_ITEM_TEMPLATES MIT

51:
52: CURSOR check_template_name_icc (cp_template_name VARCHAR2,cp_cat_grp_id NUMBER) IS
53: SELECT TEMPLATE_ID,
54: CONTEXT_ORGANIZATION_ID
55: FROM MTL_ITEM_TEMPLATES MIT
56: WHERE TEMPLATE_NAME = CP_TEMPLATE_NAME
57: AND EXISTS (SELECT 1
58: FROM EGO_CAT_GRP_TEMPLATES
59: WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID

Line 68: FROM MTL_ITEM_TEMPLATES MIT

64:
65: CURSOR check_template_id_icc (cp_template_id NUMBER,cp_cat_grp_id NUMBER) IS
66: SELECT TEMPLATE_ID,
67: CONTEXT_ORGANIZATION_ID
68: FROM MTL_ITEM_TEMPLATES MIT
69: WHERE TEMPLATE_ID = CP_TEMPLATE_ID
70: AND EXISTS (SELECT 1
71: FROM EGO_CAT_GRP_TEMPLATES
72: WHERE CATALOG_GROUP_ID IN (SELECT ITEM_CATALOG_GROUP_ID

Line 119: FROM MTL_ITEM_TEMPLATES MIT

115: GLOBAL_ATTRIBUTE17,
116: GLOBAL_ATTRIBUTE18,
117: GLOBAL_ATTRIBUTE19,
118: GLOBAL_ATTRIBUTE20
119: FROM MTL_ITEM_TEMPLATES MIT
120: WHERE MIT.template_id = cp_template_id;
121:
122: --Bug:6282388
123: CURSOR isMasterOrg(cp_orgid NUMBER)

Line 132: context_orgid mtl_item_templates.context_organization_id%TYPE;

128: AND rownum = 1;
129:
130: l_isMasterOrg NUMBER;
131: AttRec MTL_SYSTEM_ITEMS_B%ROWTYPE;
132: context_orgid mtl_item_templates.context_organization_id%TYPE;
133: l_template_id mtl_item_templates.template_id%TYPE := NULL;
134: rtn_status number := 0;
135: dumm_status number := 0;
136: LOGGING_ERR EXCEPTION;

Line 133: l_template_id mtl_item_templates.template_id%TYPE := NULL;

129:
130: l_isMasterOrg NUMBER;
131: AttRec MTL_SYSTEM_ITEMS_B%ROWTYPE;
132: context_orgid mtl_item_templates.context_organization_id%TYPE;
133: l_template_id mtl_item_templates.template_id%TYPE := NULL;
134: rtn_status number := 0;
135: dumm_status number := 0;
136: LOGGING_ERR EXCEPTION;
137: l_error_exists BOOLEAN := FALSE;

Line 146: mtl_item_templates.template_id%TYPE

142:
143: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
144:
145: TYPE template_id_type IS TABLE OF
146: mtl_item_templates.template_id%TYPE
147: INDEX BY BINARY_INTEGER;
148:
149: --Bug 4456453
150: TYPE transaction_table_type IS TABLE OF

Line 1490: FROM mtl_item_templates

1486: FOR i IN trans_cur LOOP
1487: IF l_template_id IS NOT NULL AND i.inventory_item_id IS NULL AND i.organization_id IS NOT NULL THEN
1488: begin
1489: SELECT CONTEXT_ORGANIZATION_ID into l_temp_org_id
1490: FROM mtl_item_templates
1491: WHERE template_id=l_template_id;
1492: end;
1493:
1494: IF (INV_SERIAL_NUMBER_PUB.is_serial_tagged(p_template_id=>l_template_id