APPS.INV_LOT_SEL_ATTR dependencies on MTL_LOT_NUMBERS

Line 62: FROM mtl_lot_numbers

58: IF(p_lot_serial_number IS NOT NULL) THEN
59: IF(flex_name = 'Lot Attributes') THEN
60: SELECT lot_attribute_category
61: INTO context_value
62: FROM mtl_lot_numbers
63: WHERE lot_number = p_lot_serial_number
64: AND inventory_item_id = item_id
65: AND organization_id = org_id;
66: ELSIF (flex_name = 'Serial Attributes') THEN

Line 227: FROM mtl_lot_numbers

223: l_progress_indicator := '30';
224:
225: SELECT lot_attribute_category
226: INTO l_context_value
227: FROM mtl_lot_numbers
228: WHERE lot_number = p_lot_serial
229: AND inventory_item_id = item_id
230: AND organization_id = org_id;
231:

Line 286: if( upper(p_table_name) = 'MTL_LOT_NUMBERS' ) then

282: l_retDate VARCHAR2(15) := 'DATE';
283: l_retNumber VARcHAR2(15) := 'NUMBER';
284: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
285: BEGIN
286: if( upper(p_table_name) = 'MTL_LOT_NUMBERS' ) then
287: if( upper(p_column_name ) = 'VENDOR_ID') then
288: x_column_type := l_retNumber;
289: elsif( upper(p_column_name) = 'GRADE_CODE') then
290: x_column_type := l_retVarchar;

Line 945: FROM mtl_lot_numbers

941: l_lot_number VARCHAR2(80);
942: BEGIN
943: SELECT lot_number
944: INTO l_lot_number
945: FROM mtl_lot_numbers
946: WHERE lot_number = p_lot_number
947: AND inventory_item_id = p_inventory_item_id
948: AND organization_id = p_org_id;
949: RETURN TRUE;

Line 1203: IF p_table_name = 'MTL_LOT_NUMBERS' THEN

1199:
1200: END LOOP;
1201: CLOSE column_csr;
1202:
1203: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1204: l_sel_stmt := l_sel_stmt || ' ' ||
1205: 'from mtl_lot_numbers ' ||
1206: 'where lot_number = :b_lot_number ' ||
1207: 'and inventory_item_id = :b_item_id ' ||

Line 1205: 'from mtl_lot_numbers ' ||

1201: CLOSE column_csr;
1202:
1203: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1204: l_sel_stmt := l_sel_stmt || ' ' ||
1205: 'from mtl_lot_numbers ' ||
1206: 'where lot_number = :b_lot_number ' ||
1207: 'and inventory_item_id = :b_item_id ' ||
1208: 'and organization_id = :b_org_id ' ;
1209: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN

Line 1225: IF p_table_name = 'MTL_LOT_NUMBERS' THEN

1221:
1222: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_org_id', p_organization_id);
1223: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_item_id', p_inventory_item_id);
1224:
1225: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1226: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_lot_number', p_lot_serial_number);
1227: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN
1228: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_serial_number', p_lot_serial_number);
1229: END IF;

Line 1421: FROM mtl_lot_numbers

1417: ,attribute12
1418: ,attribute13
1419: ,attribute14
1420: ,attribute15
1421: FROM mtl_lot_numbers
1422: WHERE inventory_item_id = p_inventory_item_id
1423: AND organization_id = p_organization_id
1424: AND lot_number = p_lot_number;
1425:

Line 1460: l_dflex_r.flexfield_name := 'MTL_LOT_NUMBERS';

1456: CLOSE inv_attr;
1457:
1458: x_return_status := 'S';
1459: l_dflex_r.application_id := 401;
1460: l_dflex_r.flexfield_name := 'MTL_LOT_NUMBERS';
1461: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
1462: l_global_context := l_contexts_dr.global_context;
1463: l_context := l_contexts_dr.context_code(l_global_context);
1464: