[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
/* Select all cross references having the cross reference type
** identified in the PO: Item Cross Reference Type profile
** option (this is passed in to get_disposition_message as
** an argument.) This SELECCT will look for messages either having an
** exact match with the specified organizaiton, or messages that
** are applicable to all organizations. If > 1 message is
** selected, the when TOO_MANY_ROWS exception handler will
** set the x_multiple_flag to 'Y' and return TRUE.
*/
x_progress := '010';
SELECT mcr.cross_reference
INTO x_message
FROM mtl_cross_references mcr
WHERE mcr.inventory_item_id = x_item_id
AND mcr.cross_reference_type = x_cross_ref_type
AND (mcr.organization_id = x_org_id
OR
mcr.org_independent_flag = 'Y');