APPS.OKC_REP_UTIL_PVT dependencies on OKC_TEMPLATE_USAGES

Line 69: ,okc_template_usages t

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

Line 80: ,okc_template_usages t

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

Line 91: ,okc_template_usages t

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

Line 102: ,okc_template_usages t

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

Line 113: ,okc_template_usages t

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

Line 8331: 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;

8327:
8328: END IF;
8329:
8330:
8331: 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;
8332:
8333:
8334:
8335: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN