APPS.CSP_RECEIVE_PVT dependencies on MTL_LOT_NUMBERS

Line 289: FROM mtl_lot_numbers

285: x_message VARCHAR2(2000);
286:
287: Cursor c_lot_exists(p_lot_number Varchar2,p_item_id number, p_org_id number) Is
288: Select 'Y'
289: FROM mtl_lot_numbers
290: WHERE lot_number = Ltrim(Rtrim(p_lot_number))
291: AND inventory_item_id = p_item_id
292: AND organization_id = p_org_id;
293:

Line 1543: FROM mtl_lot_numbers

1539: , n_attribute7
1540: , n_attribute8
1541: , n_attribute9
1542: , n_attribute10
1543: FROM mtl_lot_numbers
1544: WHERE lot_number = Ltrim(Rtrim(v_lot_number))
1545: AND inventory_item_id = v_inventory_item_id
1546: AND organization_id = v_organization_id;
1547:

Line 1549: l_lot_number mtl_lot_numbers.lot_number%type;

1545: AND inventory_item_id = v_inventory_item_id
1546: AND organization_id = v_organization_id;
1547:
1548:
1549: l_lot_number mtl_lot_numbers.lot_number%type;
1550: l_expiration_date mtl_lot_numbers.expiration_date%type;
1551: l_description mtl_lot_numbers.description%type;
1552: l_vendor_name mtl_lot_numbers.vendor_name%type;
1553: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;

Line 1550: l_expiration_date mtl_lot_numbers.expiration_date%type;

1546: AND organization_id = v_organization_id;
1547:
1548:
1549: l_lot_number mtl_lot_numbers.lot_number%type;
1550: l_expiration_date mtl_lot_numbers.expiration_date%type;
1551: l_description mtl_lot_numbers.description%type;
1552: l_vendor_name mtl_lot_numbers.vendor_name%type;
1553: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1554: l_grade_code mtl_lot_numbers.grade_code%type;

Line 1551: l_description mtl_lot_numbers.description%type;

1547:
1548:
1549: l_lot_number mtl_lot_numbers.lot_number%type;
1550: l_expiration_date mtl_lot_numbers.expiration_date%type;
1551: l_description mtl_lot_numbers.description%type;
1552: l_vendor_name mtl_lot_numbers.vendor_name%type;
1553: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1554: l_grade_code mtl_lot_numbers.grade_code%type;
1555: l_origination_date mtl_lot_numbers.origination_date%type;

Line 1552: l_vendor_name mtl_lot_numbers.vendor_name%type;

1548:
1549: l_lot_number mtl_lot_numbers.lot_number%type;
1550: l_expiration_date mtl_lot_numbers.expiration_date%type;
1551: l_description mtl_lot_numbers.description%type;
1552: l_vendor_name mtl_lot_numbers.vendor_name%type;
1553: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1554: l_grade_code mtl_lot_numbers.grade_code%type;
1555: l_origination_date mtl_lot_numbers.origination_date%type;
1556: l_date_code mtl_lot_numbers.date_code%type;

Line 1553: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;

1549: l_lot_number mtl_lot_numbers.lot_number%type;
1550: l_expiration_date mtl_lot_numbers.expiration_date%type;
1551: l_description mtl_lot_numbers.description%type;
1552: l_vendor_name mtl_lot_numbers.vendor_name%type;
1553: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1554: l_grade_code mtl_lot_numbers.grade_code%type;
1555: l_origination_date mtl_lot_numbers.origination_date%type;
1556: l_date_code mtl_lot_numbers.date_code%type;
1557: l_status_id mtl_lot_numbers.status_id%type;

Line 1554: l_grade_code mtl_lot_numbers.grade_code%type;

1550: l_expiration_date mtl_lot_numbers.expiration_date%type;
1551: l_description mtl_lot_numbers.description%type;
1552: l_vendor_name mtl_lot_numbers.vendor_name%type;
1553: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1554: l_grade_code mtl_lot_numbers.grade_code%type;
1555: l_origination_date mtl_lot_numbers.origination_date%type;
1556: l_date_code mtl_lot_numbers.date_code%type;
1557: l_status_id mtl_lot_numbers.status_id%type;
1558: l_change_date mtl_lot_numbers.change_date%type;

Line 1555: l_origination_date mtl_lot_numbers.origination_date%type;

1551: l_description mtl_lot_numbers.description%type;
1552: l_vendor_name mtl_lot_numbers.vendor_name%type;
1553: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1554: l_grade_code mtl_lot_numbers.grade_code%type;
1555: l_origination_date mtl_lot_numbers.origination_date%type;
1556: l_date_code mtl_lot_numbers.date_code%type;
1557: l_status_id mtl_lot_numbers.status_id%type;
1558: l_change_date mtl_lot_numbers.change_date%type;
1559: l_age mtl_lot_numbers.age%type;

Line 1556: l_date_code mtl_lot_numbers.date_code%type;

1552: l_vendor_name mtl_lot_numbers.vendor_name%type;
1553: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1554: l_grade_code mtl_lot_numbers.grade_code%type;
1555: l_origination_date mtl_lot_numbers.origination_date%type;
1556: l_date_code mtl_lot_numbers.date_code%type;
1557: l_status_id mtl_lot_numbers.status_id%type;
1558: l_change_date mtl_lot_numbers.change_date%type;
1559: l_age mtl_lot_numbers.age%type;
1560: l_retest_date mtl_lot_numbers.retest_date%type;

Line 1557: l_status_id mtl_lot_numbers.status_id%type;

1553: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1554: l_grade_code mtl_lot_numbers.grade_code%type;
1555: l_origination_date mtl_lot_numbers.origination_date%type;
1556: l_date_code mtl_lot_numbers.date_code%type;
1557: l_status_id mtl_lot_numbers.status_id%type;
1558: l_change_date mtl_lot_numbers.change_date%type;
1559: l_age mtl_lot_numbers.age%type;
1560: l_retest_date mtl_lot_numbers.retest_date%type;
1561: l_maturity_date mtl_lot_numbers.maturity_date%type;

Line 1558: l_change_date mtl_lot_numbers.change_date%type;

1554: l_grade_code mtl_lot_numbers.grade_code%type;
1555: l_origination_date mtl_lot_numbers.origination_date%type;
1556: l_date_code mtl_lot_numbers.date_code%type;
1557: l_status_id mtl_lot_numbers.status_id%type;
1558: l_change_date mtl_lot_numbers.change_date%type;
1559: l_age mtl_lot_numbers.age%type;
1560: l_retest_date mtl_lot_numbers.retest_date%type;
1561: l_maturity_date mtl_lot_numbers.maturity_date%type;
1562: l_item_size mtl_lot_numbers.item_size%type;

Line 1559: l_age mtl_lot_numbers.age%type;

1555: l_origination_date mtl_lot_numbers.origination_date%type;
1556: l_date_code mtl_lot_numbers.date_code%type;
1557: l_status_id mtl_lot_numbers.status_id%type;
1558: l_change_date mtl_lot_numbers.change_date%type;
1559: l_age mtl_lot_numbers.age%type;
1560: l_retest_date mtl_lot_numbers.retest_date%type;
1561: l_maturity_date mtl_lot_numbers.maturity_date%type;
1562: l_item_size mtl_lot_numbers.item_size%type;
1563: l_color mtl_lot_numbers.color%type;

Line 1560: l_retest_date mtl_lot_numbers.retest_date%type;

1556: l_date_code mtl_lot_numbers.date_code%type;
1557: l_status_id mtl_lot_numbers.status_id%type;
1558: l_change_date mtl_lot_numbers.change_date%type;
1559: l_age mtl_lot_numbers.age%type;
1560: l_retest_date mtl_lot_numbers.retest_date%type;
1561: l_maturity_date mtl_lot_numbers.maturity_date%type;
1562: l_item_size mtl_lot_numbers.item_size%type;
1563: l_color mtl_lot_numbers.color%type;
1564: l_volume mtl_lot_numbers.volume%type;

Line 1561: l_maturity_date mtl_lot_numbers.maturity_date%type;

1557: l_status_id mtl_lot_numbers.status_id%type;
1558: l_change_date mtl_lot_numbers.change_date%type;
1559: l_age mtl_lot_numbers.age%type;
1560: l_retest_date mtl_lot_numbers.retest_date%type;
1561: l_maturity_date mtl_lot_numbers.maturity_date%type;
1562: l_item_size mtl_lot_numbers.item_size%type;
1563: l_color mtl_lot_numbers.color%type;
1564: l_volume mtl_lot_numbers.volume%type;
1565: l_volume_uom mtl_lot_numbers.volume_uom%type;

Line 1562: l_item_size mtl_lot_numbers.item_size%type;

1558: l_change_date mtl_lot_numbers.change_date%type;
1559: l_age mtl_lot_numbers.age%type;
1560: l_retest_date mtl_lot_numbers.retest_date%type;
1561: l_maturity_date mtl_lot_numbers.maturity_date%type;
1562: l_item_size mtl_lot_numbers.item_size%type;
1563: l_color mtl_lot_numbers.color%type;
1564: l_volume mtl_lot_numbers.volume%type;
1565: l_volume_uom mtl_lot_numbers.volume_uom%type;
1566: l_place_of_origin mtl_lot_numbers.place_of_origin%type;

Line 1563: l_color mtl_lot_numbers.color%type;

1559: l_age mtl_lot_numbers.age%type;
1560: l_retest_date mtl_lot_numbers.retest_date%type;
1561: l_maturity_date mtl_lot_numbers.maturity_date%type;
1562: l_item_size mtl_lot_numbers.item_size%type;
1563: l_color mtl_lot_numbers.color%type;
1564: l_volume mtl_lot_numbers.volume%type;
1565: l_volume_uom mtl_lot_numbers.volume_uom%type;
1566: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1567: l_best_by_date mtl_lot_numbers.best_by_date%type;

Line 1564: l_volume mtl_lot_numbers.volume%type;

1560: l_retest_date mtl_lot_numbers.retest_date%type;
1561: l_maturity_date mtl_lot_numbers.maturity_date%type;
1562: l_item_size mtl_lot_numbers.item_size%type;
1563: l_color mtl_lot_numbers.color%type;
1564: l_volume mtl_lot_numbers.volume%type;
1565: l_volume_uom mtl_lot_numbers.volume_uom%type;
1566: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1567: l_best_by_date mtl_lot_numbers.best_by_date%type;
1568: l_length mtl_lot_numbers.length%type;

Line 1565: l_volume_uom mtl_lot_numbers.volume_uom%type;

1561: l_maturity_date mtl_lot_numbers.maturity_date%type;
1562: l_item_size mtl_lot_numbers.item_size%type;
1563: l_color mtl_lot_numbers.color%type;
1564: l_volume mtl_lot_numbers.volume%type;
1565: l_volume_uom mtl_lot_numbers.volume_uom%type;
1566: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1567: l_best_by_date mtl_lot_numbers.best_by_date%type;
1568: l_length mtl_lot_numbers.length%type;
1569: l_length_uom mtl_lot_numbers.length_uom%type;

Line 1566: l_place_of_origin mtl_lot_numbers.place_of_origin%type;

1562: l_item_size mtl_lot_numbers.item_size%type;
1563: l_color mtl_lot_numbers.color%type;
1564: l_volume mtl_lot_numbers.volume%type;
1565: l_volume_uom mtl_lot_numbers.volume_uom%type;
1566: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1567: l_best_by_date mtl_lot_numbers.best_by_date%type;
1568: l_length mtl_lot_numbers.length%type;
1569: l_length_uom mtl_lot_numbers.length_uom%type;
1570: l_recycled_content mtl_lot_numbers.recycled_content%type;

Line 1567: l_best_by_date mtl_lot_numbers.best_by_date%type;

1563: l_color mtl_lot_numbers.color%type;
1564: l_volume mtl_lot_numbers.volume%type;
1565: l_volume_uom mtl_lot_numbers.volume_uom%type;
1566: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1567: l_best_by_date mtl_lot_numbers.best_by_date%type;
1568: l_length mtl_lot_numbers.length%type;
1569: l_length_uom mtl_lot_numbers.length_uom%type;
1570: l_recycled_content mtl_lot_numbers.recycled_content%type;
1571: l_thickness mtl_lot_numbers.thickness%type;

Line 1568: l_length mtl_lot_numbers.length%type;

1564: l_volume mtl_lot_numbers.volume%type;
1565: l_volume_uom mtl_lot_numbers.volume_uom%type;
1566: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1567: l_best_by_date mtl_lot_numbers.best_by_date%type;
1568: l_length mtl_lot_numbers.length%type;
1569: l_length_uom mtl_lot_numbers.length_uom%type;
1570: l_recycled_content mtl_lot_numbers.recycled_content%type;
1571: l_thickness mtl_lot_numbers.thickness%type;
1572: l_thickness_uom mtl_lot_numbers.thickness_uom%type;

Line 1569: l_length_uom mtl_lot_numbers.length_uom%type;

1565: l_volume_uom mtl_lot_numbers.volume_uom%type;
1566: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1567: l_best_by_date mtl_lot_numbers.best_by_date%type;
1568: l_length mtl_lot_numbers.length%type;
1569: l_length_uom mtl_lot_numbers.length_uom%type;
1570: l_recycled_content mtl_lot_numbers.recycled_content%type;
1571: l_thickness mtl_lot_numbers.thickness%type;
1572: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1573: l_width mtl_lot_numbers.width%type;

Line 1570: l_recycled_content mtl_lot_numbers.recycled_content%type;

1566: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1567: l_best_by_date mtl_lot_numbers.best_by_date%type;
1568: l_length mtl_lot_numbers.length%type;
1569: l_length_uom mtl_lot_numbers.length_uom%type;
1570: l_recycled_content mtl_lot_numbers.recycled_content%type;
1571: l_thickness mtl_lot_numbers.thickness%type;
1572: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1573: l_width mtl_lot_numbers.width%type;
1574: l_width_uom mtl_lot_numbers.width_uom%type;

Line 1571: l_thickness mtl_lot_numbers.thickness%type;

1567: l_best_by_date mtl_lot_numbers.best_by_date%type;
1568: l_length mtl_lot_numbers.length%type;
1569: l_length_uom mtl_lot_numbers.length_uom%type;
1570: l_recycled_content mtl_lot_numbers.recycled_content%type;
1571: l_thickness mtl_lot_numbers.thickness%type;
1572: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1573: l_width mtl_lot_numbers.width%type;
1574: l_width_uom mtl_lot_numbers.width_uom%type;
1575: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;

Line 1572: l_thickness_uom mtl_lot_numbers.thickness_uom%type;

1568: l_length mtl_lot_numbers.length%type;
1569: l_length_uom mtl_lot_numbers.length_uom%type;
1570: l_recycled_content mtl_lot_numbers.recycled_content%type;
1571: l_thickness mtl_lot_numbers.thickness%type;
1572: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1573: l_width mtl_lot_numbers.width%type;
1574: l_width_uom mtl_lot_numbers.width_uom%type;
1575: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1576: l_vendor_id mtl_lot_numbers.vendor_id%type;

Line 1573: l_width mtl_lot_numbers.width%type;

1569: l_length_uom mtl_lot_numbers.length_uom%type;
1570: l_recycled_content mtl_lot_numbers.recycled_content%type;
1571: l_thickness mtl_lot_numbers.thickness%type;
1572: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1573: l_width mtl_lot_numbers.width%type;
1574: l_width_uom mtl_lot_numbers.width_uom%type;
1575: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1576: l_vendor_id mtl_lot_numbers.vendor_id%type;
1577: l_territory_code mtl_lot_numbers.territory_code%type;

Line 1574: l_width_uom mtl_lot_numbers.width_uom%type;

1570: l_recycled_content mtl_lot_numbers.recycled_content%type;
1571: l_thickness mtl_lot_numbers.thickness%type;
1572: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1573: l_width mtl_lot_numbers.width%type;
1574: l_width_uom mtl_lot_numbers.width_uom%type;
1575: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1576: l_vendor_id mtl_lot_numbers.vendor_id%type;
1577: l_territory_code mtl_lot_numbers.territory_code%type;
1578: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;

Line 1575: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;

1571: l_thickness mtl_lot_numbers.thickness%type;
1572: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1573: l_width mtl_lot_numbers.width%type;
1574: l_width_uom mtl_lot_numbers.width_uom%type;
1575: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1576: l_vendor_id mtl_lot_numbers.vendor_id%type;
1577: l_territory_code mtl_lot_numbers.territory_code%type;
1578: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1579: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;

Line 1576: l_vendor_id mtl_lot_numbers.vendor_id%type;

1572: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1573: l_width mtl_lot_numbers.width%type;
1574: l_width_uom mtl_lot_numbers.width_uom%type;
1575: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1576: l_vendor_id mtl_lot_numbers.vendor_id%type;
1577: l_territory_code mtl_lot_numbers.territory_code%type;
1578: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1579: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1580: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;

Line 1577: l_territory_code mtl_lot_numbers.territory_code%type;

1573: l_width mtl_lot_numbers.width%type;
1574: l_width_uom mtl_lot_numbers.width_uom%type;
1575: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1576: l_vendor_id mtl_lot_numbers.vendor_id%type;
1577: l_territory_code mtl_lot_numbers.territory_code%type;
1578: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1579: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1580: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1581: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;

Line 1578: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;

1574: l_width_uom mtl_lot_numbers.width_uom%type;
1575: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1576: l_vendor_id mtl_lot_numbers.vendor_id%type;
1577: l_territory_code mtl_lot_numbers.territory_code%type;
1578: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1579: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1580: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1581: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1582: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;

Line 1579: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;

1575: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1576: l_vendor_id mtl_lot_numbers.vendor_id%type;
1577: l_territory_code mtl_lot_numbers.territory_code%type;
1578: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1579: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1580: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1581: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1582: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1583: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;

Line 1580: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;

1576: l_vendor_id mtl_lot_numbers.vendor_id%type;
1577: l_territory_code mtl_lot_numbers.territory_code%type;
1578: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1579: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1580: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1581: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1582: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1583: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1584: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;

Line 1581: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;

1577: l_territory_code mtl_lot_numbers.territory_code%type;
1578: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1579: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1580: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1581: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1582: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1583: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1584: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1585: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;

Line 1582: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;

1578: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1579: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1580: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1581: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1582: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1583: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1584: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1585: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1586: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;

Line 1583: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;

1579: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1580: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1581: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1582: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1583: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1584: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1585: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1586: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1587: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;

Line 1584: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;

1580: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1581: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1582: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1583: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1584: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1585: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1586: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1587: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1588: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;

Line 1585: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;

1581: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1582: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1583: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1584: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1585: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1586: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1587: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1588: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1589: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;

Line 1586: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;

1582: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1583: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1584: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1585: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1586: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1587: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1588: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1589: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1590: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;

Line 1587: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;

1583: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1584: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1585: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1586: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1587: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1588: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1589: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1590: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1591: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;

Line 1588: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;

1584: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1585: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1586: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1587: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1588: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1589: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1590: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1591: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1592: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;

Line 1589: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;

1585: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1586: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1587: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1588: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1589: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1590: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1591: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1592: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1593: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;

Line 1590: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;

1586: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1587: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1588: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1589: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1590: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1591: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1592: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1593: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1594: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;

Line 1591: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;

1587: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1588: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1589: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1590: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1591: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1592: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1593: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1594: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1595: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;

Line 1592: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;

1588: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1589: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1590: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1591: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1592: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1593: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1594: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1595: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1596: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;

Line 1593: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;

1589: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1590: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1591: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1592: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1593: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1594: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1595: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1596: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1597: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;

Line 1594: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;

1590: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1591: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1592: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1593: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1594: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1595: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1596: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1597: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1598: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;

Line 1595: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;

1591: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1592: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1593: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1594: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1595: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1596: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1597: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1598: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1599: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;

Line 1596: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;

1592: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1593: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1594: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1595: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1596: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1597: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1598: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1599: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1600: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;

Line 1597: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;

1593: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1594: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1595: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1596: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1597: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1598: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1599: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1600: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1601: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;

Line 1598: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;

1594: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1595: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1596: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1597: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1598: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1599: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1600: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1601: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1602: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;

Line 1599: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;

1595: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1596: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1597: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1598: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1599: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1600: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1601: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1602: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1603: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;

Line 1600: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;

1596: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1597: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1598: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1599: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1600: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1601: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1602: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1603: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1604: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;

Line 1601: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;

1597: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1598: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1599: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1600: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1601: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1602: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1603: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1604: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1605: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;

Line 1602: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;

1598: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1599: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1600: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1601: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1602: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1603: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1604: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1605: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1606: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;

Line 1603: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;

1599: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1600: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1601: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1602: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1603: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1604: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1605: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1606: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1607: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;

Line 1604: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;

1600: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1601: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1602: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1603: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1604: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1605: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1606: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1607: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1608: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;

Line 1605: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;

1601: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1602: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1603: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1604: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1605: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1606: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1607: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1608: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1609: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;

Line 1606: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;

1602: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1603: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1604: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1605: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1606: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1607: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1608: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1609: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1610: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;

Line 1607: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;

1603: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1604: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1605: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1606: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1607: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1608: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1609: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1610: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1611: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;

Line 1608: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;

1604: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1605: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1606: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1607: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1608: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1609: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1610: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1611: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1612: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;

Line 1609: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;

1605: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1606: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1607: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1608: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1609: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1610: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1611: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1612: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1613: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;

Line 1610: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;

1606: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1607: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1608: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1609: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1610: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1611: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1612: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1613: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1614: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;

Line 1611: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;

1607: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1608: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1609: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1610: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1611: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1612: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1613: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1614: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1615: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;

Line 1612: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;

1608: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1609: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1610: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1611: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1612: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1613: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1614: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1615: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;
1616: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;

Line 1613: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;

1609: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1610: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1611: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1612: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1613: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1614: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1615: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;
1616: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;
1617: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;

Line 1614: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;

1610: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1611: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1612: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1613: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1614: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1615: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;
1616: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;
1617: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;
1618: l_n_attribute10 mtl_lot_numbers.n_attribute10%type ;

Line 1615: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;

1611: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1612: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1613: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1614: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1615: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;
1616: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;
1617: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;
1618: l_n_attribute10 mtl_lot_numbers.n_attribute10%type ;
1619: l_source_code mtl_transaction_lots_interface.source_code%TYPE;

Line 1616: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;

1612: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1613: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1614: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1615: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;
1616: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;
1617: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;
1618: l_n_attribute10 mtl_lot_numbers.n_attribute10%type ;
1619: l_source_code mtl_transaction_lots_interface.source_code%TYPE;
1620: l_source_line_id mtl_transaction_lots_interface.source_line_id%TYPE;

Line 1617: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;

1613: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1614: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1615: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;
1616: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;
1617: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;
1618: l_n_attribute10 mtl_lot_numbers.n_attribute10%type ;
1619: l_source_code mtl_transaction_lots_interface.source_code%TYPE;
1620: l_source_line_id mtl_transaction_lots_interface.source_line_id%TYPE;
1621: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;

Line 1618: l_n_attribute10 mtl_lot_numbers.n_attribute10%type ;

1614: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1615: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;
1616: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;
1617: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;
1618: l_n_attribute10 mtl_lot_numbers.n_attribute10%type ;
1619: l_source_code mtl_transaction_lots_interface.source_code%TYPE;
1620: l_source_line_id mtl_transaction_lots_interface.source_line_id%TYPE;
1621: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;
1622: