APPS.OKS_MASS_UPD_PVT dependencies on OKC_STATUSES_B

Line 44: select ste_code from okc_statuses_b where code = p_sts_code;

40:
41: l_mass_update_status_tbl oks_mass_upd_pvt.mass_update_status_tbl;
42:
43: CURSOR get_stecode(p_sts_code VARCHAR2) IS
44: select ste_code from okc_statuses_b where code = p_sts_code;
45:
46: l_return_status VARCHAR2(10);
47: l_old_ste_code VARCHAR2(100);
48: l_new_ste_code VARCHAR2(100);

Line 1309: select ste_code from okc_statuses_b where code = p_sts_code;

1305: FROM okc_k_headers_all_b
1306: WHERE id = p_contract_id;
1307:
1308: Cursor ste_code_csr(p_sts_code in varchar2) is
1309: select ste_code from okc_statuses_b where code = p_sts_code;
1310:
1311:
1312: TYPE err_mu_status_rec IS RECORD
1313: (

Line 2830: okc_statuses_b sts

2826: Price_negotiated
2827: FROM okc_k_lines_b lin,
2828: okc_k_items itm,
2829: OKX_SYSTEM_ITEMS_V SI,
2830: okc_statuses_b sts
2831: WHERE lin.id = itm.cle_id
2832: AND itm.object1_id1 = SI.id1
2833: AND SI.organization_id = itm.object1_id2
2834: AND lin.sts_code = sts.code

Line 3042: okc_statuses_b sts,

3038: FROM okc_k_items itm,
3039: okc_k_lines_b lin,
3040: OKX_SYSTEM_ITEMS_V SI,
3041: oks_ib_config_v cs_item,
3042: okc_statuses_b sts,
3043: CSI_SYSTEMS_TL CSTL
3044: WHERE itm.object1_id1 = cs_item.customer_product_id
3045: AND cs_item.system_id = cstl.system_id(+)
3046: AND CSTL.LANGUAGE(+) = UserEnv('LANG')

Line 3090: okc_statuses_b sts

3086: -99 "top_lvl_parent"
3087: FROM okc_k_items itm,
3088: okc_k_lines_b lin,
3089: OKX_SYSTEM_ITEMS_V SI,
3090: okc_statuses_b sts
3091: WHERE lin.id = itm.cle_id
3092: AND lin.dnz_chr_id = p_contract_id
3093: AND itm.object1_id1 = SI.id1
3094: AND SI.id2 = itm.object1_id2

Line 3134: okc_statuses_b sts

3130: -99 "top_lvl_parent"
3131: FROM okc_k_items itm,
3132: okc_k_lines_b lin,
3133: okx_parties_v SI,
3134: okc_statuses_b sts
3135: WHERE lin.id = itm.cle_id
3136: AND lin.dnz_chr_id = p_contract_id
3137: AND itm.object1_id1 = SI.id1
3138: AND SI.id2 = '#'

Line 3178: okc_statuses_b sts

3174: -99 "top_lvl_parent"
3175: FROM okc_k_items itm,
3176: okc_k_lines_b lin,
3177: okx_party_sites_v SI,
3178: okc_statuses_b sts
3179: WHERE lin.id = itm.cle_id
3180: AND lin.dnz_chr_id = p_contract_id
3181: AND itm.object1_id1 = SI.id1
3182: AND SI.id2 = '#'

Line 3222: okc_statuses_b sts,

3218: -99 "top_lvl_parent"
3219: FROM okc_k_items itm,
3220: okc_k_lines_b lin,
3221: okx_systems_v SI,
3222: okc_statuses_b sts,
3223: CSI_SYSTEMS_TL CSTL
3224: WHERE lin.id = itm.cle_id
3225: AND lin.dnz_chr_id = p_contract_id
3226: AND itm.object1_id1 = SI.id1

Line 3270: okc_statuses_b sts

3266: FROM okc_k_items itm,
3267: okc_k_lines_b lin,
3268: hz_cust_accounts c,
3269: hz_parties p,
3270: okc_statuses_b sts
3271: WHERE p.party_id = c.party_id
3272: AND c.cust_account_id = itm.object1_id1
3273: AND lin.id = itm.cle_id
3274: AND lin.dnz_chr_id = p_contract_id

Line 3325: okc_statuses_b sts

3321: FROM okc_k_items itm,
3322: okc_k_lines_b lin,
3323: OKX_SYSTEM_ITEMS_V SI,
3324: oks_ib_config_v cs_item,
3325: okc_statuses_b sts
3326: WHERE itm.object1_id1 = cs_item.customer_product_id
3327: AND lin.id = itm.cle_id
3328: AND lin.dnz_chr_id = p_contract_id
3329: AND SI.id1 = cs_item.INVENTORY_ITEM_ID

Line 3452: FROM okc_statuses_b sts

3448: Decode(tmp.end_date, lin.end_date, 'N', 'Y') end_date_change,
3449: Decode(Round(tmp.price_negotiated,(SELECT prc FROM a)), Round(lin.price_negotiated,(SELECT prc FROM a)), 'N', 'Y') Price_change,
3450: Decode(tmp.new_status,
3451: (SELECT sts.code
3452: FROM okc_statuses_b sts
3453: WHERE sts.code = lin.sts_code),
3454: 'N',
3455: 'Y') status_change
3456: FROM oks_sublines_temp tmp, okc_k_lines_b lin

Line 3467: FROM okc_statuses_b sts

3463: Decode(tmp.start_date, lin.start_date, 'N', 'Y') start_date_change,
3464: Decode(tmp.end_date, lin.end_date, 'N', 'Y') end_date_change,
3465: Decode(tmp.new_status,
3466: (SELECT sts.code
3467: FROM okc_statuses_b sts
3468: WHERE sts.code = lin.sts_code),
3469: 'N',
3470: 'Y') status_change
3471: FROM oks_lines_temp tmp, okc_k_lines_b lin