APPS.OKS_MASS_UPDATE_PVT dependencies on OKS_K_SALES_CREDITS

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 75: --| OKS_K_SALES_CREDITS | | X | | | | |

71: --| OKS_K_HEADERS_B | X | X | | | | |
72: --+---------------------------------+---+---+---+---+---+----------------------+
73: --| OKC_K_ACCESSES | | X | | | | |
74: --+---------------------------------+---+---+---+---+---+----------------------+
75: --| OKS_K_SALES_CREDITS | | X | | | | |
76: --+---------------------------------+---+---+---+---+---+----------------------+
77: --| CS_CTR_ASSOCIATIONS | X | | | | | |
78: --+---------------------------------+---+---+---+---+---+----------------------+
79: --| OKS_COVERAGES_PUB | | | | | |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 3165: INSERT INTO oks_k_sales_credits

3161:
3162: IF hdr_id.COUNT > 0
3163: THEN
3164: FORALL i IN 1 .. hdr_id.COUNT
3165: INSERT INTO oks_k_sales_credits
3166: (ID,
3167: PERCENT,
3168: sales_group_id,
3169: chr_id,

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:

Line 3704: INSERT INTO oks_k_sales_credits

3700:
3701: CLOSE get_line_salescredits_csr;
3702: IF srvline_id.count > 0 THEN -- Added for Bug#14183916
3703: FORALL i IN 1 .. srvline_id.COUNT
3704: INSERT INTO oks_k_sales_credits
3705: (ID,
3706: PERCENT,
3707: sales_group_id,
3708: chr_id,