DBA Data[Home] [Help]

APPS.GR_REG_PRINT_DOC dependencies on GR_DISPATCH_HISTORY_V

Line 510: From GR_DISPATCH_HISTORY_V

506:
507: /* Used to get the Latest Dispatch details of the Item Document */
508: Cursor c_get_last_dispatch_date IS
509: Select max(date_sent)
510: From GR_DISPATCH_HISTORY_V
511: Where INVENTORY_ITEM_ID = LocalDeliverydetail.inventory_item_id -- BUG#4431025
512: and ORGANIZATION_ID = LocalDeliverydetail.organization_id -- BUG#4431025
513: and DOCUMENT_CODE = l_territory_details.DOCUMENT_CODE
514: and DOCUMENT_LANGUAGE = l_territory_details.LANGUAGE