DBA Data[Home] [Help]

APPS.OKS_MASS_UPDATE_PVT dependencies on OKS_K_SALES_CREDITS_V

Line 53: --| OKS_K_SALES_CREDITS_V | X | | | | | |

49: --| HZ_CUST_ACCT_SITES_ALL | X | | | | | |
50: --+---------------------------------+---+---+---+---+---+----------------------+
51: --| OKS_INSTANCE_K_DTLS_TEMP | X | X | | | | |
52: --+---------------------------------+---+---+---+---+---+----------------------+
53: --| OKS_K_SALES_CREDITS_V | X | | | | | |
54: --+---------------------------------+---+---+---+---+---+----------------------+
55: --| OKC_K_ACCESSES_V | X | | | | | |
56: --+---------------------------------+---+---+---+---+---+----------------------+
57: --| OKC_CLASSES_B | X | | | | | |

Line 1883: FROM oks_k_sales_credits_v sc,

1879: sc.ctc_id,
1880: sc.sales_credit_type_id1,
1881: sc.PERCENT,
1882: sc.sales_group_id
1883: FROM oks_k_sales_credits_v sc,
1884: oks_instance_k_dtls_temp temp
1885: WHERE sc.chr_id = temp.contract_id
1886: AND sc.cle_id IS NULL
1887: AND temp.new_contract_id IS NOT NULL;

Line 3306: FROM oks_k_sales_credits_v sc,

3302: sc.ctc_id,
3303: sc.sales_credit_type_id1,
3304: sc.PERCENT,
3305: sc.sales_group_id
3306: FROM oks_k_sales_credits_v sc,
3307: oks_instance_k_dtls_temp temp
3308: WHERE sc.cle_id = temp.topline_id
3309: AND temp.new_serviceline_id IS NOT NULL;
3310: