DBA Data[Home] [Help]

APPS.PO_LINE_LOCATIONS_SV7 dependencies on MTL_ITEM_REVISIONS

Line 673: is defined in mtl_item_revisions table */

669: IF (X_item_id is not NULL) AND (x_ship_to_organization_id is not NULL)
670: THEN
671: IF (X_item_revision is not NULL) THEN
672: /* only allow those org_id when item_id and item_revision
673: is defined in mtl_item_revisions table */
674:
675: X_progress := '090';
676: SELECT count(*)
677: INTO X_temp_count

Line 678: FROM mtl_item_revisions

674:
675: X_progress := '090';
676: SELECT count(*)
677: INTO X_temp_count
678: FROM mtl_item_revisions
679: WHERE inventory_item_id = X_item_id
680: AND organization_id = x_ship_to_organization_id
681: AND revision = X_item_revision;
682: