APPS.OKC_REP_UTIL_PVT dependencies on OKC_TEMPLATE_USAGES

Line 67: ,okc_template_usages t

63: SELECT
64: h.org_id
65: FROM
66: po_headers_all h
67: ,okc_template_usages t
68: WHERE h.po_header_id = t.document_id
69: AND t.document_type IN ('PA_BLANKET','PA_CONTRACT','PO_STANDARD')
70: AND t.document_type = p_contract_type
71: AND h.po_header_id = p_contract_id;

Line 78: ,okc_template_usages t

74: SELECT
75: h.org_id
76: FROM
77: pon_auction_headers_all h
78: ,okc_template_usages t
79: WHERE h.auction_header_id = t.document_id
80: AND t.document_type IN ('AUCTION','RFI','RFQ')
81: AND t.document_type = p_contract_type
82: AND h.auction_header_id = p_contract_id;

Line 89: ,okc_template_usages t

85: SELECT
86: h.org_id
87: FROM
88: oe_blanket_headers_all h
89: ,okc_template_usages t
90: WHERE h.header_id = t.document_id
91: AND t.document_type = 'B'
92: AND t.document_type = p_contract_type
93: AND h.header_id = p_contract_id;

Line 100: ,okc_template_usages t

96: SELECT
97: h.org_id
98: FROM
99: oe_order_headers_all h
100: ,okc_template_usages t
101: WHERE h.header_id = t.document_id
102: AND t.document_type = 'O'
103: AND t.document_type = p_contract_type
104: AND h.header_id = p_contract_id;

Line 111: ,okc_template_usages t

107: SELECT
108: h.org_id
109: FROM
110: aso_quote_headers_all h
111: ,okc_template_usages t
112: WHERE h.quote_header_id = t.document_id
113: AND t.document_type = 'QUOTE'
114: AND t.document_type = p_contract_type
115: AND h.quote_header_id = p_contract_id;

Line 7429: SELECT Nvl((SELECT 'Y' FROM okc_template_usages WHERE document_type = p_contract_type AND ROWNUM =1),'N') INTO x_disable_contract_terms_yn FROM dual;

7425:
7426: END IF;
7427:
7428:
7429: SELECT Nvl((SELECT 'Y' FROM okc_template_usages WHERE document_type = p_contract_type AND ROWNUM =1),'N') INTO x_disable_contract_terms_yn FROM dual;
7430:
7431:
7432:
7433: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN