APPS.INV_EAM_ASSET_NUMBER_PVT dependencies on MTL_SERIAL_NUMBERS

Line 141: from mtl_serial_numbers

137: */
138:
139: -- check if serial number exists within asset group
140: select count(1) into l_count
141: from mtl_serial_numbers
142: where inventory_item_id = p_inventory_item_id
143: and serial_number = p_serial_number;
144:
145: if l_count > 0 then

Line 343: CURSOR C IS SELECT rowid FROM MTL_SERIAL_NUMBERS

339: l_api_name CONSTANT VARCHAR2(30) := 'insert_row';
340: l_api_version CONSTANT NUMBER := 1.0;
341: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
342:
343: CURSOR C IS SELECT rowid FROM MTL_SERIAL_NUMBERS
344: WHERE inventory_item_id = P_INVENTORY_ITEM_ID
345: AND serial_number = P_SERIAL_NUMBER
346: AND current_organization_id = P_ORGANIZATION_ID;
347:

Line 370: INSERT INTO MTL_SERIAL_NUMBERS(

366: -- API body
367:
368: --'Serial Tracking in WIP' project- insert WIP_ENTITY_ID, OPERATION_SEQ_NUM, INTRAOPERATION_STEP_TYPE
369: -- INTO MSN.
370: INSERT INTO MTL_SERIAL_NUMBERS(
371: INVENTORY_ITEM_ID,
372: SERIAL_NUMBER,
373: INITIALIZATION_DATE,
374: DESCRIPTIVE_TEXT,

Line 840: UPDATE MTL_SERIAL_NUMBERS

836:
837: -- API body
838:
839:
840: UPDATE MTL_SERIAL_NUMBERS
841: SET
842: DESCRIPTIVE_TEXT = decode(P_FROM_PUBLIC_API, 'N', P_DESCRIPTIVE_TEXT, decode(P_DESCRIPTIVE_TEXT, fnd_api.g_miss_char, null, decode(P_DESCRIPTIVE_TEXT, NULL, DESCRIPTIVE_TEXT, P_DESCRIPTIVE_TEXT))),
843: CATEGORY_ID = decode(P_FROM_PUBLIC_API, 'N', P_CATEGORY_ID, decode(P_CATEGORY_ID, fnd_api.g_miss_num, null, decode(P_CATEGORY_ID, NULL, CATEGORY_ID, P_CATEGORY_ID))),
844: PROD_ORGANIZATION_ID = decode(P_FROM_PUBLIC_API, 'N', P_PROD_ORGANIZATION_ID, decode(P_PROD_ORGANIZATION_ID, fnd_api.g_miss_num, null, decode(P_PROD_ORGANIZATION_ID, NULL, PROD_ORGANIZATION_ID, P_PROD_ORGANIZATION_ID))),

Line 1077: FROM MTL_SERIAL_NUMBERS

1073: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name || '.' || l_api_name;
1074:
1075: CURSOR C IS
1076: SELECT *
1077: FROM MTL_SERIAL_NUMBERS
1078: WHERE rowid = P_Rowid
1079: FOR UPDATE of SERIAL_NUMBER NOWAIT;
1080: Recinfo C%ROWTYPE;
1081: