APPS.GR_PROCESS_ORDERS dependencies on GR_ITEM_DOC_STATUSES

Line 2472: FROM gr_item_doc_statuses ids

2468: CURSOR c_get_item_range
2469: IS
2470: SELECT ids.item_code,
2471: ids.last_doc_update_date
2472: FROM gr_item_doc_statuses ids
2473: WHERE ids.item_code = LocalItemRec.item_code
2474: AND ids.document_code = g_default_document;
2475: LocalItem c_get_item_range%ROWTYPE;
2476: /*

Line 3957: gr_item_doc_statuses ids

3953: SELECT ids.rebuild_item_doc_flag,
3954: ids.last_doc_update_date,
3955: dh.date_msds_sent
3956: FROM gr_dispatch_histories dh,
3957: gr_item_doc_statuses ids
3958: WHERE ids.item_code = g_item_code
3959: /* Fix for B1255401 */
3960: AND dh.dispatch_method_code <> 99
3961: AND ids.document_code = GlobalRecipient.document_code