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 1887: FROM oks_k_sales_credits_v sc,

1883: sc.ctc_id,
1884: sc.sales_credit_type_id1,
1885: sc.PERCENT,
1886: sc.sales_group_id
1887: FROM oks_k_sales_credits_v sc,
1888: oks_instance_k_dtls_temp temp
1889: WHERE sc.chr_id = temp.contract_id
1890: AND sc.cle_id IS NULL
1891: AND temp.new_contract_id IS NOT NULL;

Line 3311: FROM oks_k_sales_credits_v sc,

3307: sc.ctc_id,
3308: sc.sales_credit_type_id1,
3309: sc.PERCENT,
3310: sc.sales_group_id
3311: FROM oks_k_sales_credits_v sc,
3312: oks_instance_k_dtls_temp temp
3313: WHERE sc.cle_id = temp.topline_id
3314: AND temp.new_serviceline_id IS NOT NULL;
3315: