APPS.OKI_REFRESH_PVT dependencies on OKC_STATUSES_B

Line 1155: ,okc_statuses_b sts

1151: FROM okc_k_headers_b khr
1152: ,okc_k_vers_numbers vnm
1153: ,hr_organization_information oin
1154: ,gl_sets_of_books sob
1155: ,okc_statuses_b sts
1156: WHERE 1 = 1
1157: AND khr.buy_or_sell = 'S'
1158: AND khr.template_yn = 'N'
1159: AND khr.application_id = 515

Line 1261: okc_statuses_b sts,

1257: vnm.minor_version
1258: FROM
1259: okc_k_headers_b khr,
1260: okc_k_vers_numbers vnm,
1261: okc_statuses_b sts,
1262: gl_sets_of_books sob,
1263: hr_organization_information oin
1264: WHERE 1 = 1
1265: AND khr.buy_or_sell = 'S'

Line 1312: okc_statuses_b sts,

1308:
1309: SELECT count(*) INTO l_remainder
1310: FROM
1311: okc_k_headers_b khr,
1312: okc_statuses_b sts,
1313: gl_sets_of_books sob,
1314: hr_organization_information oin
1315: WHERE 1 = 1
1316: AND khr.buy_or_sell = 'S'

Line 2650: , okc_statuses_b sts

2646: okc_k_headers_b khr
2647: , oks_k_headers_b hoks -- 11510 Changes
2648: , oki_job_run_dtl jrd -- 11510 Changes
2649: , okc_k_party_roles_b cpl
2650: , okc_statuses_b sts
2651: , gl_periods spd
2652: , gl_periods spd1 -- 11510 Changes
2653: , okc_k_rel_objs ro
2654: , okx_order_headers_v oh

Line 3108: , okc_statuses_b sts

3104: oki_job_run_dtl jrd
3105: , okc_k_headers_b khr
3106: , oks_k_headers_b hoks -- 11510 Changes
3107: , okc_k_party_roles_b cpl
3108: , okc_statuses_b sts
3109: , gl_periods spd
3110: , gl_periods spd1 -- 11510 Changes
3111: , okc_k_rel_objs ro
3112: , okx_order_headers_v oh

Line 3526: ,okc_statuses_b sts

3522: FROM
3523: okc_k_lines_b cle
3524: ,oki_sales_k_hdrs shd
3525: ,okc_k_items cim
3526: ,okc_statuses_b sts
3527: ,oki_job_run_dtl jrd -- 11510 Changes
3528: WHERE 1=1
3529: and cim.cle_id = cle.id
3530: and sts.code = cle.sts_code

Line 3818: , okc_statuses_b sts

3814: FROM
3815: okc_k_lines_b cle
3816: , oki_sales_k_hdrs shd
3817: , okc_k_items cim
3818: , okc_statuses_b sts
3819: , oki_job_run_dtl jrd
3820: WHERE 1=1
3821: AND cim.cle_id = cle.id
3822: and sts.code = cle.sts_code

Line 4156: ,okc_statuses_b sts

4152: ,oki_job_run_dtl jrd
4153: ,okc_k_lines_b cle
4154: ,okc_k_items cim
4155: ,csi_item_instances cii
4156: ,okc_statuses_b sts
4157: /*11510 changes added*/
4158: ,gl_periods epd
4159: ,(select distinct object_cle_id cle_id from okc_operation_lines
4160: where active_yn = 'Y' ) exp

Line 4542: , okc_statuses_b sts

4538: okc_k_lines_b cle
4539: , oki_sold_itm_lines sil
4540: , okc_k_items cim
4541: , csi_item_instances cii
4542: , okc_statuses_b sts
4543: , oki_job_run_dtl jrd
4544: /*11510 changes added*/
4545: , gl_periods epd
4546: ,(select distinct object_cle_id cle_id from okc_operation_lines