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

1653: , n_attribute7
1654: , n_attribute8
1655: , n_attribute9
1656: , n_attribute10
1657: FROM mtl_lot_numbers
1658: WHERE lot_number = Ltrim(Rtrim(v_lot_number))
1659: AND inventory_item_id = v_inventory_item_id
1660: AND organization_id = v_organization_id;
1661:

Line 1663: l_lot_number mtl_lot_numbers.lot_number%type;

1659: AND inventory_item_id = v_inventory_item_id
1660: AND organization_id = v_organization_id;
1661:
1662:
1663: l_lot_number mtl_lot_numbers.lot_number%type;
1664: l_expiration_date mtl_lot_numbers.expiration_date%type;
1665: l_description mtl_lot_numbers.description%type;
1666: l_vendor_name mtl_lot_numbers.vendor_name%type;
1667: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;

Line 1664: l_expiration_date mtl_lot_numbers.expiration_date%type;

1660: AND organization_id = v_organization_id;
1661:
1662:
1663: l_lot_number mtl_lot_numbers.lot_number%type;
1664: l_expiration_date mtl_lot_numbers.expiration_date%type;
1665: l_description mtl_lot_numbers.description%type;
1666: l_vendor_name mtl_lot_numbers.vendor_name%type;
1667: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1668: l_grade_code mtl_lot_numbers.grade_code%type;

Line 1665: l_description mtl_lot_numbers.description%type;

1661:
1662:
1663: l_lot_number mtl_lot_numbers.lot_number%type;
1664: l_expiration_date mtl_lot_numbers.expiration_date%type;
1665: l_description mtl_lot_numbers.description%type;
1666: l_vendor_name mtl_lot_numbers.vendor_name%type;
1667: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1668: l_grade_code mtl_lot_numbers.grade_code%type;
1669: l_origination_date mtl_lot_numbers.origination_date%type;

Line 1666: l_vendor_name mtl_lot_numbers.vendor_name%type;

1662:
1663: l_lot_number mtl_lot_numbers.lot_number%type;
1664: l_expiration_date mtl_lot_numbers.expiration_date%type;
1665: l_description mtl_lot_numbers.description%type;
1666: l_vendor_name mtl_lot_numbers.vendor_name%type;
1667: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1668: l_grade_code mtl_lot_numbers.grade_code%type;
1669: l_origination_date mtl_lot_numbers.origination_date%type;
1670: l_date_code mtl_lot_numbers.date_code%type;

Line 1667: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;

1663: l_lot_number mtl_lot_numbers.lot_number%type;
1664: l_expiration_date mtl_lot_numbers.expiration_date%type;
1665: l_description mtl_lot_numbers.description%type;
1666: l_vendor_name mtl_lot_numbers.vendor_name%type;
1667: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1668: l_grade_code mtl_lot_numbers.grade_code%type;
1669: l_origination_date mtl_lot_numbers.origination_date%type;
1670: l_date_code mtl_lot_numbers.date_code%type;
1671: l_status_id mtl_lot_numbers.status_id%type;

Line 1668: l_grade_code mtl_lot_numbers.grade_code%type;

1664: l_expiration_date mtl_lot_numbers.expiration_date%type;
1665: l_description mtl_lot_numbers.description%type;
1666: l_vendor_name mtl_lot_numbers.vendor_name%type;
1667: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1668: l_grade_code mtl_lot_numbers.grade_code%type;
1669: l_origination_date mtl_lot_numbers.origination_date%type;
1670: l_date_code mtl_lot_numbers.date_code%type;
1671: l_status_id mtl_lot_numbers.status_id%type;
1672: l_change_date mtl_lot_numbers.change_date%type;

Line 1669: l_origination_date mtl_lot_numbers.origination_date%type;

1665: l_description mtl_lot_numbers.description%type;
1666: l_vendor_name mtl_lot_numbers.vendor_name%type;
1667: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1668: l_grade_code mtl_lot_numbers.grade_code%type;
1669: l_origination_date mtl_lot_numbers.origination_date%type;
1670: l_date_code mtl_lot_numbers.date_code%type;
1671: l_status_id mtl_lot_numbers.status_id%type;
1672: l_change_date mtl_lot_numbers.change_date%type;
1673: l_age mtl_lot_numbers.age%type;

Line 1670: l_date_code mtl_lot_numbers.date_code%type;

1666: l_vendor_name mtl_lot_numbers.vendor_name%type;
1667: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1668: l_grade_code mtl_lot_numbers.grade_code%type;
1669: l_origination_date mtl_lot_numbers.origination_date%type;
1670: l_date_code mtl_lot_numbers.date_code%type;
1671: l_status_id mtl_lot_numbers.status_id%type;
1672: l_change_date mtl_lot_numbers.change_date%type;
1673: l_age mtl_lot_numbers.age%type;
1674: l_retest_date mtl_lot_numbers.retest_date%type;

Line 1671: l_status_id mtl_lot_numbers.status_id%type;

1667: l_supplier_lot_number mtl_lot_numbers.supplier_lot_number%type;
1668: l_grade_code mtl_lot_numbers.grade_code%type;
1669: l_origination_date mtl_lot_numbers.origination_date%type;
1670: l_date_code mtl_lot_numbers.date_code%type;
1671: l_status_id mtl_lot_numbers.status_id%type;
1672: l_change_date mtl_lot_numbers.change_date%type;
1673: l_age mtl_lot_numbers.age%type;
1674: l_retest_date mtl_lot_numbers.retest_date%type;
1675: l_maturity_date mtl_lot_numbers.maturity_date%type;

Line 1672: l_change_date mtl_lot_numbers.change_date%type;

1668: l_grade_code mtl_lot_numbers.grade_code%type;
1669: l_origination_date mtl_lot_numbers.origination_date%type;
1670: l_date_code mtl_lot_numbers.date_code%type;
1671: l_status_id mtl_lot_numbers.status_id%type;
1672: l_change_date mtl_lot_numbers.change_date%type;
1673: l_age mtl_lot_numbers.age%type;
1674: l_retest_date mtl_lot_numbers.retest_date%type;
1675: l_maturity_date mtl_lot_numbers.maturity_date%type;
1676: l_item_size mtl_lot_numbers.item_size%type;

Line 1673: l_age mtl_lot_numbers.age%type;

1669: l_origination_date mtl_lot_numbers.origination_date%type;
1670: l_date_code mtl_lot_numbers.date_code%type;
1671: l_status_id mtl_lot_numbers.status_id%type;
1672: l_change_date mtl_lot_numbers.change_date%type;
1673: l_age mtl_lot_numbers.age%type;
1674: l_retest_date mtl_lot_numbers.retest_date%type;
1675: l_maturity_date mtl_lot_numbers.maturity_date%type;
1676: l_item_size mtl_lot_numbers.item_size%type;
1677: l_color mtl_lot_numbers.color%type;

Line 1674: l_retest_date mtl_lot_numbers.retest_date%type;

1670: l_date_code mtl_lot_numbers.date_code%type;
1671: l_status_id mtl_lot_numbers.status_id%type;
1672: l_change_date mtl_lot_numbers.change_date%type;
1673: l_age mtl_lot_numbers.age%type;
1674: l_retest_date mtl_lot_numbers.retest_date%type;
1675: l_maturity_date mtl_lot_numbers.maturity_date%type;
1676: l_item_size mtl_lot_numbers.item_size%type;
1677: l_color mtl_lot_numbers.color%type;
1678: l_volume mtl_lot_numbers.volume%type;

Line 1675: l_maturity_date mtl_lot_numbers.maturity_date%type;

1671: l_status_id mtl_lot_numbers.status_id%type;
1672: l_change_date mtl_lot_numbers.change_date%type;
1673: l_age mtl_lot_numbers.age%type;
1674: l_retest_date mtl_lot_numbers.retest_date%type;
1675: l_maturity_date mtl_lot_numbers.maturity_date%type;
1676: l_item_size mtl_lot_numbers.item_size%type;
1677: l_color mtl_lot_numbers.color%type;
1678: l_volume mtl_lot_numbers.volume%type;
1679: l_volume_uom mtl_lot_numbers.volume_uom%type;

Line 1676: l_item_size mtl_lot_numbers.item_size%type;

1672: l_change_date mtl_lot_numbers.change_date%type;
1673: l_age mtl_lot_numbers.age%type;
1674: l_retest_date mtl_lot_numbers.retest_date%type;
1675: l_maturity_date mtl_lot_numbers.maturity_date%type;
1676: l_item_size mtl_lot_numbers.item_size%type;
1677: l_color mtl_lot_numbers.color%type;
1678: l_volume mtl_lot_numbers.volume%type;
1679: l_volume_uom mtl_lot_numbers.volume_uom%type;
1680: l_place_of_origin mtl_lot_numbers.place_of_origin%type;

Line 1677: l_color mtl_lot_numbers.color%type;

1673: l_age mtl_lot_numbers.age%type;
1674: l_retest_date mtl_lot_numbers.retest_date%type;
1675: l_maturity_date mtl_lot_numbers.maturity_date%type;
1676: l_item_size mtl_lot_numbers.item_size%type;
1677: l_color mtl_lot_numbers.color%type;
1678: l_volume mtl_lot_numbers.volume%type;
1679: l_volume_uom mtl_lot_numbers.volume_uom%type;
1680: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1681: l_best_by_date mtl_lot_numbers.best_by_date%type;

Line 1678: l_volume mtl_lot_numbers.volume%type;

1674: l_retest_date mtl_lot_numbers.retest_date%type;
1675: l_maturity_date mtl_lot_numbers.maturity_date%type;
1676: l_item_size mtl_lot_numbers.item_size%type;
1677: l_color mtl_lot_numbers.color%type;
1678: l_volume mtl_lot_numbers.volume%type;
1679: l_volume_uom mtl_lot_numbers.volume_uom%type;
1680: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1681: l_best_by_date mtl_lot_numbers.best_by_date%type;
1682: l_length mtl_lot_numbers.length%type;

Line 1679: l_volume_uom mtl_lot_numbers.volume_uom%type;

1675: l_maturity_date mtl_lot_numbers.maturity_date%type;
1676: l_item_size mtl_lot_numbers.item_size%type;
1677: l_color mtl_lot_numbers.color%type;
1678: l_volume mtl_lot_numbers.volume%type;
1679: l_volume_uom mtl_lot_numbers.volume_uom%type;
1680: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1681: l_best_by_date mtl_lot_numbers.best_by_date%type;
1682: l_length mtl_lot_numbers.length%type;
1683: l_length_uom mtl_lot_numbers.length_uom%type;

Line 1680: l_place_of_origin mtl_lot_numbers.place_of_origin%type;

1676: l_item_size mtl_lot_numbers.item_size%type;
1677: l_color mtl_lot_numbers.color%type;
1678: l_volume mtl_lot_numbers.volume%type;
1679: l_volume_uom mtl_lot_numbers.volume_uom%type;
1680: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1681: l_best_by_date mtl_lot_numbers.best_by_date%type;
1682: l_length mtl_lot_numbers.length%type;
1683: l_length_uom mtl_lot_numbers.length_uom%type;
1684: l_recycled_content mtl_lot_numbers.recycled_content%type;

Line 1681: l_best_by_date mtl_lot_numbers.best_by_date%type;

1677: l_color mtl_lot_numbers.color%type;
1678: l_volume mtl_lot_numbers.volume%type;
1679: l_volume_uom mtl_lot_numbers.volume_uom%type;
1680: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1681: l_best_by_date mtl_lot_numbers.best_by_date%type;
1682: l_length mtl_lot_numbers.length%type;
1683: l_length_uom mtl_lot_numbers.length_uom%type;
1684: l_recycled_content mtl_lot_numbers.recycled_content%type;
1685: l_thickness mtl_lot_numbers.thickness%type;

Line 1682: l_length mtl_lot_numbers.length%type;

1678: l_volume mtl_lot_numbers.volume%type;
1679: l_volume_uom mtl_lot_numbers.volume_uom%type;
1680: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1681: l_best_by_date mtl_lot_numbers.best_by_date%type;
1682: l_length mtl_lot_numbers.length%type;
1683: l_length_uom mtl_lot_numbers.length_uom%type;
1684: l_recycled_content mtl_lot_numbers.recycled_content%type;
1685: l_thickness mtl_lot_numbers.thickness%type;
1686: l_thickness_uom mtl_lot_numbers.thickness_uom%type;

Line 1683: l_length_uom mtl_lot_numbers.length_uom%type;

1679: l_volume_uom mtl_lot_numbers.volume_uom%type;
1680: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1681: l_best_by_date mtl_lot_numbers.best_by_date%type;
1682: l_length mtl_lot_numbers.length%type;
1683: l_length_uom mtl_lot_numbers.length_uom%type;
1684: l_recycled_content mtl_lot_numbers.recycled_content%type;
1685: l_thickness mtl_lot_numbers.thickness%type;
1686: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1687: l_width mtl_lot_numbers.width%type;

Line 1684: l_recycled_content mtl_lot_numbers.recycled_content%type;

1680: l_place_of_origin mtl_lot_numbers.place_of_origin%type;
1681: l_best_by_date mtl_lot_numbers.best_by_date%type;
1682: l_length mtl_lot_numbers.length%type;
1683: l_length_uom mtl_lot_numbers.length_uom%type;
1684: l_recycled_content mtl_lot_numbers.recycled_content%type;
1685: l_thickness mtl_lot_numbers.thickness%type;
1686: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1687: l_width mtl_lot_numbers.width%type;
1688: l_width_uom mtl_lot_numbers.width_uom%type;

Line 1685: l_thickness mtl_lot_numbers.thickness%type;

1681: l_best_by_date mtl_lot_numbers.best_by_date%type;
1682: l_length mtl_lot_numbers.length%type;
1683: l_length_uom mtl_lot_numbers.length_uom%type;
1684: l_recycled_content mtl_lot_numbers.recycled_content%type;
1685: l_thickness mtl_lot_numbers.thickness%type;
1686: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1687: l_width mtl_lot_numbers.width%type;
1688: l_width_uom mtl_lot_numbers.width_uom%type;
1689: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;

Line 1686: l_thickness_uom mtl_lot_numbers.thickness_uom%type;

1682: l_length mtl_lot_numbers.length%type;
1683: l_length_uom mtl_lot_numbers.length_uom%type;
1684: l_recycled_content mtl_lot_numbers.recycled_content%type;
1685: l_thickness mtl_lot_numbers.thickness%type;
1686: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1687: l_width mtl_lot_numbers.width%type;
1688: l_width_uom mtl_lot_numbers.width_uom%type;
1689: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1690: l_vendor_id mtl_lot_numbers.vendor_id%type;

Line 1687: l_width mtl_lot_numbers.width%type;

1683: l_length_uom mtl_lot_numbers.length_uom%type;
1684: l_recycled_content mtl_lot_numbers.recycled_content%type;
1685: l_thickness mtl_lot_numbers.thickness%type;
1686: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1687: l_width mtl_lot_numbers.width%type;
1688: l_width_uom mtl_lot_numbers.width_uom%type;
1689: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1690: l_vendor_id mtl_lot_numbers.vendor_id%type;
1691: l_territory_code mtl_lot_numbers.territory_code%type;

Line 1688: l_width_uom mtl_lot_numbers.width_uom%type;

1684: l_recycled_content mtl_lot_numbers.recycled_content%type;
1685: l_thickness mtl_lot_numbers.thickness%type;
1686: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1687: l_width mtl_lot_numbers.width%type;
1688: l_width_uom mtl_lot_numbers.width_uom%type;
1689: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1690: l_vendor_id mtl_lot_numbers.vendor_id%type;
1691: l_territory_code mtl_lot_numbers.territory_code%type;
1692: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;

Line 1689: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;

1685: l_thickness mtl_lot_numbers.thickness%type;
1686: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1687: l_width mtl_lot_numbers.width%type;
1688: l_width_uom mtl_lot_numbers.width_uom%type;
1689: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1690: l_vendor_id mtl_lot_numbers.vendor_id%type;
1691: l_territory_code mtl_lot_numbers.territory_code%type;
1692: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1693: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;

Line 1690: l_vendor_id mtl_lot_numbers.vendor_id%type;

1686: l_thickness_uom mtl_lot_numbers.thickness_uom%type;
1687: l_width mtl_lot_numbers.width%type;
1688: l_width_uom mtl_lot_numbers.width_uom%type;
1689: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1690: l_vendor_id mtl_lot_numbers.vendor_id%type;
1691: l_territory_code mtl_lot_numbers.territory_code%type;
1692: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1693: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1694: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;

Line 1691: l_territory_code mtl_lot_numbers.territory_code%type;

1687: l_width mtl_lot_numbers.width%type;
1688: l_width_uom mtl_lot_numbers.width_uom%type;
1689: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1690: l_vendor_id mtl_lot_numbers.vendor_id%type;
1691: l_territory_code mtl_lot_numbers.territory_code%type;
1692: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1693: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1694: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1695: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;

Line 1692: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;

1688: l_width_uom mtl_lot_numbers.width_uom%type;
1689: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1690: l_vendor_id mtl_lot_numbers.vendor_id%type;
1691: l_territory_code mtl_lot_numbers.territory_code%type;
1692: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1693: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1694: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1695: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1696: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;

Line 1693: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;

1689: l_curl_wrinkle_fold mtl_lot_numbers.curl_wrinkle_fold%type;
1690: l_vendor_id mtl_lot_numbers.vendor_id%type;
1691: l_territory_code mtl_lot_numbers.territory_code%type;
1692: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1693: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1694: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1695: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1696: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1697: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;

Line 1694: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;

1690: l_vendor_id mtl_lot_numbers.vendor_id%type;
1691: l_territory_code mtl_lot_numbers.territory_code%type;
1692: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1693: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1694: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1695: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1696: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1697: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1698: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;

Line 1695: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;

1691: l_territory_code mtl_lot_numbers.territory_code%type;
1692: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1693: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1694: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1695: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1696: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1697: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1698: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1699: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;

Line 1696: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;

1692: l_lot_attribute_category mtl_lot_numbers.lot_attribute_category%type;
1693: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1694: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1695: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1696: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1697: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1698: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1699: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1700: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;

Line 1697: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;

1693: l_c_attribute1 mtl_lot_numbers.c_attribute1%type ;
1694: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1695: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1696: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1697: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1698: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1699: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1700: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1701: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;

Line 1698: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;

1694: l_c_attribute2 mtl_lot_numbers.c_attribute2%type;
1695: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1696: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1697: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1698: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1699: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1700: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1701: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1702: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;

Line 1699: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;

1695: l_c_attribute3 mtl_lot_numbers.c_attribute3%type;
1696: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1697: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1698: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1699: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1700: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1701: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1702: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1703: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;

Line 1700: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;

1696: l_c_attribute4 mtl_lot_numbers.c_attribute4%type;
1697: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1698: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1699: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1700: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1701: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1702: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1703: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1704: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;

Line 1701: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;

1697: l_c_attribute5 mtl_lot_numbers.c_attribute5%type;
1698: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1699: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1700: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1701: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1702: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1703: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1704: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1705: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;

Line 1702: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;

1698: l_c_attribute6 mtl_lot_numbers.c_attribute6%type;
1699: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1700: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1701: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1702: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1703: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1704: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1705: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1706: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;

Line 1703: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;

1699: l_c_attribute7 mtl_lot_numbers.c_attribute7%type;
1700: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1701: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1702: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1703: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1704: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1705: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1706: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1707: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;

Line 1704: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;

1700: l_c_attribute8 mtl_lot_numbers.c_attribute8%type;
1701: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1702: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1703: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1704: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1705: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1706: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1707: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1708: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;

Line 1705: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;

1701: l_c_attribute9 mtl_lot_numbers.c_attribute9%type;
1702: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1703: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1704: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1705: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1706: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1707: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1708: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1709: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;

Line 1706: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;

1702: l_c_attribute10 mtl_lot_numbers.c_attribute10%type ;
1703: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1704: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1705: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1706: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1707: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1708: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1709: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1710: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;

Line 1707: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;

1703: l_c_attribute11 mtl_lot_numbers.c_attribute11%type ;
1704: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1705: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1706: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1707: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1708: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1709: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1710: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1711: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;

Line 1708: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;

1704: l_c_attribute12 mtl_lot_numbers.c_attribute12%type;
1705: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1706: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1707: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1708: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1709: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1710: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1711: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1712: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;

Line 1709: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;

1705: l_c_attribute13 mtl_lot_numbers.c_attribute13%type;
1706: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1707: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1708: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1709: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1710: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1711: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1712: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1713: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;

Line 1710: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;

1706: l_c_attribute14 mtl_lot_numbers.c_attribute14%type;
1707: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1708: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1709: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1710: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1711: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1712: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1713: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1714: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;

Line 1711: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;

1707: l_c_attribute15 mtl_lot_numbers.c_attribute15%type;
1708: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1709: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1710: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1711: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1712: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1713: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1714: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1715: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;

Line 1712: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;

1708: l_c_attribute16 mtl_lot_numbers.c_attribute16%type;
1709: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1710: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1711: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1712: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1713: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1714: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1715: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1716: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;

Line 1713: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;

1709: l_c_attribute17 mtl_lot_numbers.c_attribute17%type;
1710: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1711: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1712: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1713: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1714: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1715: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1716: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1717: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;

Line 1714: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;

1710: l_c_attribute18 mtl_lot_numbers.c_attribute18%type;
1711: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1712: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1713: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1714: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1715: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1716: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1717: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1718: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;

Line 1715: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;

1711: l_c_attribute19 mtl_lot_numbers.c_attribute19%type;
1712: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1713: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1714: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1715: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1716: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1717: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1718: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1719: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;

Line 1716: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;

1712: l_c_attribute20 mtl_lot_numbers.c_attribute20%type;
1713: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1714: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1715: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1716: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1717: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1718: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1719: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1720: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;

Line 1717: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;

1713: l_d_attribute1 mtl_lot_numbers.d_attribute1%type ;
1714: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1715: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1716: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1717: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1718: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1719: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1720: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1721: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;

Line 1718: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;

1714: l_d_attribute2 mtl_lot_numbers.d_attribute2%type;
1715: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1716: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1717: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1718: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1719: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1720: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1721: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1722: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;

Line 1719: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;

1715: l_d_attribute3 mtl_lot_numbers.d_attribute3%type;
1716: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1717: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1718: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1719: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1720: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1721: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1722: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1723: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;

Line 1720: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;

1716: l_d_attribute4 mtl_lot_numbers.d_attribute4%type;
1717: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1718: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1719: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1720: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1721: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1722: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1723: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1724: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;

Line 1721: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;

1717: l_d_attribute5 mtl_lot_numbers.d_attribute5%type;
1718: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1719: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1720: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1721: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1722: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1723: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1724: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1725: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;

Line 1722: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;

1718: l_d_attribute6 mtl_lot_numbers.d_attribute6%type;
1719: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1720: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1721: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1722: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1723: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1724: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1725: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1726: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;

Line 1723: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;

1719: l_d_attribute7 mtl_lot_numbers.d_attribute7%type;
1720: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1721: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1722: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1723: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1724: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1725: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1726: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1727: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;

Line 1724: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;

1720: l_d_attribute8 mtl_lot_numbers.d_attribute8%type;
1721: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1722: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1723: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1724: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1725: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1726: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1727: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1728: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;

Line 1725: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;

1721: l_d_attribute9 mtl_lot_numbers.d_attribute9%type;
1722: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1723: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1724: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1725: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1726: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1727: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1728: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1729: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;

Line 1726: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;

1722: l_d_attribute10 mtl_lot_numbers.d_attribute10%type;
1723: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1724: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1725: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1726: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1727: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1728: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1729: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;
1730: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;

Line 1727: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;

1723: l_n_attribute1 mtl_lot_numbers.n_attribute1%type ;
1724: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1725: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1726: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1727: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1728: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1729: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;
1730: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;
1731: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;

Line 1728: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;

1724: l_n_attribute2 mtl_lot_numbers.n_attribute2%type ;
1725: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1726: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1727: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1728: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1729: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;
1730: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;
1731: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;
1732: l_n_attribute10 mtl_lot_numbers.n_attribute10%type ;

Line 1729: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;

1725: l_n_attribute3 mtl_lot_numbers.n_attribute3%type ;
1726: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1727: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1728: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1729: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;
1730: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;
1731: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;
1732: l_n_attribute10 mtl_lot_numbers.n_attribute10%type ;
1733: l_source_code mtl_transaction_lots_interface.source_code%TYPE;

Line 1730: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;

1726: l_n_attribute4 mtl_lot_numbers.n_attribute4%type;
1727: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1728: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1729: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;
1730: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;
1731: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;
1732: l_n_attribute10 mtl_lot_numbers.n_attribute10%type ;
1733: l_source_code mtl_transaction_lots_interface.source_code%TYPE;
1734: l_source_line_id mtl_transaction_lots_interface.source_line_id%TYPE;

Line 1731: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;

1727: l_n_attribute5 mtl_lot_numbers.n_attribute5%type;
1728: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1729: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;
1730: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;
1731: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;
1732: l_n_attribute10 mtl_lot_numbers.n_attribute10%type ;
1733: l_source_code mtl_transaction_lots_interface.source_code%TYPE;
1734: l_source_line_id mtl_transaction_lots_interface.source_line_id%TYPE;
1735: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;

Line 1732: l_n_attribute10 mtl_lot_numbers.n_attribute10%type ;

1728: l_n_attribute6 mtl_lot_numbers.n_attribute6%type;
1729: l_n_attribute7 mtl_lot_numbers.n_attribute7%type ;
1730: l_n_attribute8 mtl_lot_numbers.n_attribute8%type;
1731: l_n_attribute9 mtl_lot_numbers.n_attribute9%type;
1732: l_n_attribute10 mtl_lot_numbers.n_attribute10%type ;
1733: l_source_code mtl_transaction_lots_interface.source_code%TYPE;
1734: l_source_line_id mtl_transaction_lots_interface.source_line_id%TYPE;
1735: l_serial_control_code mtl_system_items.serial_number_control_code%TYPE;
1736: