DBA Data[Home] [Help]

APPS.OKC_CREATE_PO_FROM_K_PVT dependencies on OKC_CONVERSION_ATTRIBS_V

Line 182: rate_type_code okc_conversion_attribs_v.conversion_type%type,

178: document_type_code po_headers_interface.document_type_code%type,
179: document_num po_headers_interface.document_num%type,
180: po_header_id po_headers_interface.po_header_id%type,
181: currency_code okc_k_headers_b.currency_code%type,
182: rate_type_code okc_conversion_attribs_v.conversion_type%type,
183: rate_date okc_conversion_attribs_v.conversion_date%type,
184: rate okc_conversion_attribs_v.conversion_rate%type,
185: agent_id okx_buyers_v.id1%type,
186: vendor_id okx_vendors_v.id1%type,

Line 183: rate_date okc_conversion_attribs_v.conversion_date%type,

179: document_num po_headers_interface.document_num%type,
180: po_header_id po_headers_interface.po_header_id%type,
181: currency_code okc_k_headers_b.currency_code%type,
182: rate_type_code okc_conversion_attribs_v.conversion_type%type,
183: rate_date okc_conversion_attribs_v.conversion_date%type,
184: rate okc_conversion_attribs_v.conversion_rate%type,
185: agent_id okx_buyers_v.id1%type,
186: vendor_id okx_vendors_v.id1%type,
187: vendor_site_id okx_vendor_sites_v.id1%type,

Line 184: rate okc_conversion_attribs_v.conversion_rate%type,

180: po_header_id po_headers_interface.po_header_id%type,
181: currency_code okc_k_headers_b.currency_code%type,
182: rate_type_code okc_conversion_attribs_v.conversion_type%type,
183: rate_date okc_conversion_attribs_v.conversion_date%type,
184: rate okc_conversion_attribs_v.conversion_rate%type,
185: agent_id okx_buyers_v.id1%type,
186: vendor_id okx_vendors_v.id1%type,
187: vendor_site_id okx_vendor_sites_v.id1%type,
188: vendor_contact_id okc_contacts.object1_id1%type,

Line 690: FROM okc_conversion_attribs_v

686: CURSOR c_conv_type (b_id1 VARCHAR2) IS
687: SELECT conversion_type,
688: conversion_rate,
689: conversion_date
690: FROM okc_conversion_attribs_v
691: WHERE conversion_type = b_id1
692: AND dnz_chr_id = p_chr_id;
693:
694: