APPS.GR_PROCESS_ORDERS dependencies on GR_ITEM_GENERAL

Line 1872: v_item_code GR_ITEM_GENERAL.ITEM_CODE%TYPE;

1868: /*
1869: ** Bug 2342375 Mercy Thomas 08/15/2002 End the code changes
1870: */
1871:
1872: v_item_code GR_ITEM_GENERAL.ITEM_CODE%TYPE;
1873:
1874: CURSOR c_get_item
1875: IS
1876: SELECT item_code

Line 1877: FROM gr_item_general

1873:
1874: CURSOR c_get_item
1875: IS
1876: SELECT item_code
1877: FROM gr_item_general
1878: WHERE item_code = v_item_code;
1879: ItemRecord c_get_item%ROWTYPE;
1880:
1881: /* Get the generic item information */

Line 1886: FROM gr_item_general ig1,

1882: CURSOR c_get_generic_item
1883: IS
1884: SELECT ig1.item_code,
1885: gi.item_no
1886: FROM gr_item_general ig1,
1887: gr_generic_items_b gi
1888: WHERE gi.item_no = v_item_code
1889: AND gi.item_code = ig1.item_code;
1890: GenericRecord c_get_generic_item%ROWTYPE;

Line 1892: l_item_code GR_ITEM_GENERAL.ITEM_CODE%TYPE;

1888: WHERE gi.item_no = v_item_code
1889: AND gi.item_code = ig1.item_code;
1890: GenericRecord c_get_generic_item%ROWTYPE;
1891:
1892: l_item_code GR_ITEM_GENERAL.ITEM_CODE%TYPE;
1893: t_item_code GR_ITEM_GENERAL.ITEM_CODE%TYPE;
1894: t_recipient_code GR_RECIPIENT_INFO.RECIPIENT_CODE%TYPE;
1895:
1896: /*

Line 1893: t_item_code GR_ITEM_GENERAL.ITEM_CODE%TYPE;

1889: AND gi.item_code = ig1.item_code;
1890: GenericRecord c_get_generic_item%ROWTYPE;
1891:
1892: l_item_code GR_ITEM_GENERAL.ITEM_CODE%TYPE;
1893: t_item_code GR_ITEM_GENERAL.ITEM_CODE%TYPE;
1894: t_recipient_code GR_RECIPIENT_INFO.RECIPIENT_CODE%TYPE;
1895:
1896: /*
1897: ** Bug 2342375 Mercy Thomas 08/15/2002 End the code changes

Line 2457: FROM gr_item_general ig1

2453: */
2454: CURSOR c_get_item
2455: IS
2456: SELECT ig1.item_code
2457: FROM gr_item_general ig1
2458: WHERE ig1.item_code >= p_item_code_from
2459: AND ig1.item_code <= p_item_code_to
2460: AND (ig1.ingredient_flag = 'N'
2461: OR (ig1.ingredient_flag = 'Y'