APPS.INV_LOT_SEL_ATTR dependencies on MTL_SERIAL_NUMBERS

Line 69: FROM mtl_serial_numbers

65: AND organization_id = org_id;
66: ELSIF (flex_name = 'Serial Attributes') THEN
67: SELECT serial_attribute_category
68: INTO context_value
69: FROM mtl_serial_numbers
70: WHERE serial_number = p_lot_serial_number
71: AND inventory_item_id = item_id
72: AND current_organization_id = org_id;
73: END IF;

Line 216: FROM mtl_serial_numbers

212: l_progress_indicator := '20';
213:
214: SELECT serial_attribute_category
215: INTO l_context_value
216: FROM mtl_serial_numbers
217: WHERE serial_number = p_lot_serial
218: AND inventory_item_id = item_id
219: AND current_organization_id = org_id;
220:

Line 350: elsif( upper(p_table_name) = 'MTL_SERIAL_NUMBERS' ) then

346: x_column_type := l_retDate;
347: else
348: x_column_type := NULL;
349: end if;
350: elsif( upper(p_table_name) = 'MTL_SERIAL_NUMBERS' ) then
351: if( upper(p_column_name) = 'SERIAL_ATTRIBUTE_CATEGORY' )then
352: x_column_type := l_retVarchar;
353: elsif( upper(p_column_name) = 'ORIGINATION_DATE') then
354: x_column_type := l_retDate;

Line 1209: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN

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
1210: l_sel_stmt := l_sel_stmt || ' ' ||
1211: 'from mtl_serial_numbers ' ||
1212: 'where serial_number = :b_serial_number ' ||
1213: 'and inventory_item_id = :b_item_id ' ||

Line 1211: 'from mtl_serial_numbers ' ||

1207: 'and inventory_item_id = :b_item_id ' ||
1208: 'and organization_id = :b_org_id ' ;
1209: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN
1210: l_sel_stmt := l_sel_stmt || ' ' ||
1211: 'from mtl_serial_numbers ' ||
1212: 'where serial_number = :b_serial_number ' ||
1213: 'and inventory_item_id = :b_item_id ' ||
1214: 'and CURRENT_organization_id = :b_org_id ' ;
1215: END IF;

Line 1227: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN

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;
1230:
1231: l_colnum := 0;

Line 1548: FROM mtl_SERIAL_numbers

1544: ,attribute12
1545: ,attribute13
1546: ,attribute14
1547: ,attribute15
1548: FROM mtl_SERIAL_numbers
1549: WHERE inventory_item_id = p_inventory_item_id
1550: AND SERIAL_number = p_serial_number;
1551: /*
1552: CURSOR inv_ship_attr IS

Line 1568: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

1564: , nvl(msn.attribute12, msnt.attribute12) attribute12
1565: , nvl(msn.attribute13, msnt.attribute13) attribute13
1566: , nvl(msn.attribute14, msnt.attribute14) attribute14
1567: , nvl(msn.attribute15, msnt.attribute15) attribute15
1568: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
1569: WHERE msn.inventory_item_id = p_inventory_item_id
1570: AND msn.serial_number = p_serial_number
1571: AND msnt.transaction_temp_id = p_transaction_temp_id
1572: AND msnt.fm_serial_number = p_serial_number

Line 1592: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt

1588: ,msnt.attribute12 attribute12
1589: ,msnt.attribute13 attribute13
1590: ,msnt.attribute14 attribute14
1591: ,msnt.attribute15 attribute15
1592: FROM mtl_serial_numbers msn, mtl_serial_numbers_temp msnt
1593: WHERE msn.inventory_item_id = p_inventory_item_id
1594: AND msn.serial_number = p_serial_number
1595: AND msnt.transaction_temp_id = p_transaction_temp_id
1596: AND msnt.fm_serial_number = p_serial_number

Line 1793: l_dflex_r.flexfield_name := 'MTL_SERIAL_NUMBERS';

1789: END IF;
1790:
1791: x_return_status := 'S';
1792: l_dflex_r.application_id := 401;
1793: l_dflex_r.flexfield_name := 'MTL_SERIAL_NUMBERS';
1794: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
1795: l_global_context := l_contexts_dr.global_context;
1796: l_context := l_contexts_dr.context_code(l_global_context);
1797:

Line 1884: desc_flex_name => 'MTL_SERIAL_NUMBERS', values_or_ids => 'I' , validation_date => SYSDATE) THEN

1880: fnd_flex_descval.set_context_value(l_context);
1881: end if;
1882: debug('calling fnd_flex_descval.concatenated_values', 'GET_INV_SERIAL_ATTR', 9);
1883: IF fnd_flex_descval.validate_desccols(appl_short_name => 'INV',
1884: desc_flex_name => 'MTL_SERIAL_NUMBERS', values_or_ids => 'I' , validation_date => SYSDATE) THEN
1885: x_concatenated_values := fnd_flex_descval.concatenated_values;
1886: ELSE
1887:
1888: x_concatenated_values := null;