DBA Data[Home] [Help]

APPS.OKS_PM_ENTITLEMENTS_PVT dependencies on OKC_STATUSES_B

Line 1385: okc_statuses_b sts

1381: from
1382: okc_k_lines_b cle,
1383: okc_k_lines_b covcle,
1384: oks_k_lines_b cov,
1385: okc_statuses_b sts
1386: where
1387: cle.id=covcle.cle_id
1388: and covcle.id=cov.cle_id
1389: and cle.sts_code=sts.code

Line 1401: okc_statuses_b sts

1397: SELECT sts.ste_code
1398: from
1399: okc_k_lines_b cle,
1400: oks_k_lines_b ksl,
1401: okc_statuses_b sts
1402: where
1403: cle.id = ksl.cle_id
1404: and cle.sts_code=sts.code
1405: and sts.ste_code in ('ACTIVE','ENTERED','HOLD')

Line 1421: okc_statuses_b sts

1417: from
1418: okc_k_lines_b cle,
1419: okc_k_lines_b covcle,
1420: oks_pm_activities act,
1421: okc_statuses_b sts
1422: where
1423: cle.id=covcle.cle_id
1424: and cle.sts_code=sts.code
1425: and covcle.id=act.cle_id

Line 1438: okc_statuses_b sts

1434: sts.ste_code
1435: from
1436: okc_k_lines_b cle,
1437: oks_pm_activities act,
1438: okc_statuses_b sts
1439: where
1440: cle.sts_code = sts.code
1441: and cle.id = act.cle_id
1442: and sts.ste_code in ('ACTIVE','ENTERED','HOLD')