DBA Data[Home] [Help]

APPS.OKS_MASS_UPD_PVT dependencies on OKX_SYSTEM_ITEMS_V

Line 2829: OKX_SYSTEM_ITEMS_V SI,

2825: lin.end_date,
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

Line 3040: OKX_SYSTEM_ITEMS_V SI,

3036: END top_lvl_parent,*/
3037:
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

Line 3089: OKX_SYSTEM_ITEMS_V SI,

3085: lin.price_negotiated,
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

Line 3323: OKX_SYSTEM_ITEMS_V SI,

3319: 'N',
3320: 'N'
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