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 962: FROM mtl_lot_numbers

958: l_lot_number VARCHAR2(80);
959: BEGIN
960: SELECT lot_number
961: INTO l_lot_number
962: FROM mtl_lot_numbers
963: WHERE lot_number = p_lot_number
964: AND inventory_item_id = p_inventory_item_id
965: AND organization_id = p_org_id;
966: RETURN TRUE;

Line 1266: IF p_table_name = 'MTL_LOT_NUMBERS' THEN

1262:
1263: END LOOP;
1264: CLOSE column_csr;
1265:
1266: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1267: l_sel_stmt := l_sel_stmt || ' ' ||
1268: 'from mtl_lot_numbers ' ||
1269: 'where lot_number = :b_lot_number ' ||
1270: 'and inventory_item_id = :b_item_id ' ||

Line 1268: 'from mtl_lot_numbers ' ||

1264: CLOSE column_csr;
1265:
1266: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1267: l_sel_stmt := l_sel_stmt || ' ' ||
1268: 'from mtl_lot_numbers ' ||
1269: 'where lot_number = :b_lot_number ' ||
1270: 'and inventory_item_id = :b_item_id ' ||
1271: 'and organization_id = :b_org_id ' ;
1272: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN

Line 1287: IF p_table_name = 'MTL_LOT_NUMBERS' THEN

1283:
1284: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_org_id', p_organization_id);
1285: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_item_id', p_inventory_item_id);
1286:
1287: IF p_table_name = 'MTL_LOT_NUMBERS' THEN
1288: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_lot_number', p_lot_serial_number);
1289: ELSIF p_table_name = 'MTL_SERIAL_NUMBERS' THEN
1290: DBMS_SQL.BIND_VARIABLE(l_sql_p, 'b_serial_number', p_lot_serial_number);
1291: END IF;

Line 1573: FROM mtl_lot_numbers

1569: ,attribute12
1570: ,attribute13
1571: ,attribute14
1572: ,attribute15
1573: FROM mtl_lot_numbers
1574: WHERE inventory_item_id = p_inventory_item_id
1575: AND organization_id = p_organization_id
1576: AND lot_number = p_lot_number;
1577:

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

1608: CLOSE inv_attr;
1609:
1610: x_return_status := 'S';
1611: l_dflex_r.application_id := 401;
1612: l_dflex_r.flexfield_name := 'MTL_LOT_NUMBERS';
1613: fnd_dflex.get_contexts(flexfield => l_dflex_r, contexts => l_contexts_dr);
1614: l_global_context := l_contexts_dr.global_context;
1615: l_context := l_contexts_dr.context_code(l_global_context);
1616:

Line 2086: IF (UPPER(p_flex_name) = 'MTL_LOT_NUMBERS') THEN

2082: BEGIN
2083:
2084: l_lot_exist := 0;
2085:
2086: IF (UPPER(p_flex_name) = 'MTL_LOT_NUMBERS') THEN
2087:
2088: BEGIN
2089: SELECT 1
2090: , attribute_category

Line 2093: FROM mtl_lot_numbers

2089: SELECT 1
2090: , attribute_category
2091: INTO l_lot_exist
2092: , l_attribute_category
2093: FROM mtl_lot_numbers
2094: WHERE organization_id = p_organization_id
2095: AND inventory_item_id = p_inventory_item_id
2096: AND lot_number = p_lot_number;
2097: EXCEPTION

Line 2109: FROM mtl_lot_numbers

2105: SELECT 1
2106: , lot_attribute_category
2107: INTO l_lot_exist
2108: , l_attribute_category
2109: FROM mtl_lot_numbers
2110: WHERE organization_id = p_organization_id
2111: AND inventory_item_id = p_inventory_item_id
2112: AND lot_number = p_lot_number;
2113: EXCEPTION

Line 2183: l_where_clause := 'SELECT 1 FROM mtl_lot_numbers ' ||

2179: END LOOP contextLoop;
2180:
2181: IF l_where_clause IS NOT NULL THEN
2182:
2183: l_where_clause := 'SELECT 1 FROM mtl_lot_numbers ' ||
2184: ' WHERE organization_id = :org_id ' ||
2185: ' AND inventory_item_id = :item_id ' ||
2186: ' AND lot_number = :lot ' || l_where_clause;
2187: