712: -- if the line has not been saved, then find all possible
713: -- revisions from within the org in current sob.
714: SELECT 1
715: INTO l_dummy
716: FROM DUAL
717: WHERE EXISTS
718: (SELECT MIR.revision
719: FROM mtl_item_revisions MIR,
720: org_organization_definitions OOD
773: -- If one of the revision counts is the same as the number of shipments,
774: -- it means that all ship to orgs have this revision
775: SELECT 1
776: INTO l_dummy
777: FROM DUAL
778: WHERE EXISTS
779: ( SELECT 1
780: FROM po_session_gt
781: WHERE key = l_key