DBA Data[Home] [Help]

APPS.GR_PROCESS_ORDERS dependencies on GR_GENERIC_ITEMS_B

Line 1887: gr_generic_items_b gi

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;
1891:

Line 2492: FROM gr_generic_items_b gib

2488: CURSOR c_get_master_list
2489: IS
2490: SELECT gib.item_code,
2491: gib.item_no
2492: FROM gr_generic_items_b gib
2493: WHERE gib.item_code = LocalItem.item_code;
2494: /*
2495: ** Get the master item for a specified inventory item
2496: */

Line 2501: FROM gr_generic_items_b gib

2497: CURSOR c_get_invent_items
2498: IS
2499: SELECT gib.item_code,
2500: gib.item_no
2501: FROM gr_generic_items_b gib
2502: WHERE gib.item_no >= p_item_code_from
2503: AND gib.item_no <= p_item_code_to;
2504: LocalInventList c_get_invent_items%ROWTYPE;
2505: