DBA Data[Home] [Help]

APPS.OKC_ARTICLES_MIGRATE_GRP dependencies on OKC_STD_ART_INCMPTS

Line 1475: FROM OKC_ARTICLES_ALL SRC, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL TAR,

1471: INC.creation_date,
1472: INC.last_updated_by,
1473: INC.last_update_login,
1474: INC.last_update_date
1475: FROM OKC_ARTICLES_ALL SRC, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL TAR,
1476: HR_ORGANIZATION_INFORMATION ORG
1477: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1478: AND SRC.orig_system_reference_id1 = INC.SAE_ID
1479: AND SRC.orig_system_reference_code in ('OKCMIGNEW' , 'OKCMIGORIG')

Line 1537: FROM OKC_ARTICLES_ALL TAR, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL SRC,

1533: INC.creation_date,
1534: INC.last_updated_by,
1535: INC.last_update_login,
1536: INC.last_update_date
1537: FROM OKC_ARTICLES_ALL TAR, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL SRC,
1538: HR_ORGANIZATION_INFORMATION ORG
1539: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1540: AND SRC.orig_system_reference_id1 = TO_CHAR(INC.SAE_ID)
1541: AND SRC.orig_system_reference_code in ('OKCMIGNEW' , 'OKCMIGORIG')

Line 1599: FROM OKC_ARTICLES_ALL SRC, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL TAR,

1595: INC.creation_date,
1596: INC.last_updated_by,
1597: INC.last_update_login,
1598: INC.last_update_date
1599: FROM OKC_ARTICLES_ALL SRC, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL TAR,
1600: HR_ORGANIZATION_INFORMATION ORG
1601: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1602: AND SRC.orig_system_reference_id1 = INC.SAE_ID
1603: AND SRC.orig_system_reference_code in ('OKCMIGNEW' , 'OKCMIGORIG')

Line 1661: FROM OKC_ARTICLES_ALL TAR, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL SRC,

1657: INC.creation_date,
1658: INC.last_updated_by,
1659: INC.last_update_login,
1660: INC.last_update_date
1661: FROM OKC_ARTICLES_ALL TAR, OKC_STD_ART_INCMPTS INC, OKC_ARTICLES_ALL SRC,
1662: HR_ORGANIZATION_INFORMATION ORG
1663: WHERE ORG_INFORMATION_CONTEXT = 'OKC_TERMS_LIBRARY_DETAILS'
1664: AND SRC.orig_system_reference_id1 = TO_CHAR(INC.SAE_ID)
1665: AND SRC.orig_system_reference_code in ('OKCMIGNEW' , 'OKCMIGORIG')