DBA Data[Home] [Help]

APPS.INV_RCV_COMMON_APIS dependencies on MTL_CROSS_REFERENCES

Line 7027: FROM mtl_cross_references

7023: -- Make sure that cross_ref_item does not already exist.
7024: BEGIN
7025: SELECT cross_reference
7026: INTO l_cross_reference
7027: FROM mtl_cross_references
7028: WHERE cross_reference = p_cross_reference
7029: AND cross_reference_type = p_cross_reference_type
7030: AND organization_id = p_organization_id;
7031:

Line 7050: -- Insert the record in mtl_cross_references

7046: l_user_id := fnd_global.user_id;
7047: l_login_id := fnd_global.login_id;
7048: l_progress := '30';
7049:
7050: -- Insert the record in mtl_cross_references
7051: INSERT INTO mtl_cross_references
7052: (
7053: inventory_item_id
7054: , organization_id

Line 7051: INSERT INTO mtl_cross_references

7047: l_login_id := fnd_global.login_id;
7048: l_progress := '30';
7049:
7050: -- Insert the record in mtl_cross_references
7051: INSERT INTO mtl_cross_references
7052: (
7053: inventory_item_id
7054: , organization_id
7055: , cross_reference_type