[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT cc_header_id,
cc_type,
cc_state,
cc_ctrl_status,
cc_encmbrnc_status,
cc_apprvl_status,
vendor_id,
vendor_site_id,
vendor_contact_id,
term_id,
location_id,
cc_owner_user_id,
cc_preparer_user_id,
parent_header_id
FROM igc_cc_headers_all
WHERE cc_header_id = p_cc_header_id;
SELECT lkpt.meaning
INTO p_type_desc
FROM fnd_lookups lkpt
WHERE lkpt.lookup_code = l_header_rec.cc_type
AND lkpt.lookup_type = 'IGC_CC_TYPE';
SELECT lkpt.meaning
INTO p_state_desc
FROM fnd_lookups lkpt
WHERE lkpt.lookup_code = l_header_rec.cc_state
AND lkpt.lookup_type = 'IGC_CC_STATE';
SELECT lkpt.meaning
INTO p_apprvl_status_desc
FROM fnd_lookups lkpt
WHERE lkpt.lookup_code = l_header_rec.cc_apprvl_status
AND lkpt.lookup_type = 'IGC_CC_APPROVAL_STATUS';
SELECT lkpt.meaning
INTO p_ctrl_status_desc
FROM fnd_lookups lkpt
WHERE lkpt.lookup_code = l_header_rec.cc_ctrl_status
AND lkpt.lookup_type = 'IGC_CC_CONTROL_STATUS';
SELECT pv.vendor_name,
pv.segment1,
pv.hold_flag,
pvs.vendor_site_code
INTO p_vendor_name,
p_vendor_number,
p_vendor_hold_flag,
p_vendor_site_code
FROM po_vendors pv,
po_vendor_sites_all pvs
WHERE pv.vendor_id = l_header_rec.vendor_id
AND pvs.vendor_site_id = l_header_rec.vendor_site_id
AND pvs.vendor_id = pv.vendor_id;
SELECT pvc.first_name ||' '|| pvc.last_name
INTO p_vendor_contact
FROM po_vendor_contacts pvc
WHERE pvc.vendor_contact_id (+) = l_header_rec.vendor_contact_id;
SELECT fup.user_name
INTO p_cc_preparer_name
FROM fnd_user fup
WHERE fup.user_id = l_header_rec.cc_preparer_user_id;
SELECT fuo.user_name
INTO p_cc_owner_name
FROM fnd_user fuo
WHERE fuo.user_id = l_header_rec.cc_owner_user_id;
SELECT apt.name
INTO p_term_name
FROM ap_terms apt
WHERE apt.term_id = l_header_rec.term_id;
SELECT hrl.location_code
INTO p_bill_to_location
FROM hr_locations hrl
WHERE hrl.location_id = l_header_rec.location_id;
SELECT cch.cc_num
INTO p_parent_cc_num
FROM igc_cc_headers_all cch
WHERE cch.cc_header_id = l_header_rec.parent_header_id;
SELECT CC_acct_LINE_ID
FROM IGC_CC_ACCT_LINES
WHERE cc_header_id = (SELECT cc_header_id
FROM IGC_CC_HEADERS
WHERE CC_NUM = p_cc_num)
AND CC_ACCT_LINE_NUM = x_shipment_num;
SELECT distribution_num
FROM po_distributions
WHERE po_header_id = x_po_header_id
AND po_line_id = x_po_line_id
AND line_location_id = x_line_location_id;
IS SELECT po_line_id
FROM po_lines
WHERE po_header_id = p_po_header_id;
IS SELECT line_location_id, shipment_num
FROM po_line_locations
WHERE po_line_id = p_po_line_id;
IS SELECT cc_acct_line_id
FROM igc_cc_acct_lines
WHERE cc_header_id = (SELECT cc_header_id
FROM IGC_CC_HEADERS
WHERE CC_NUM = l_cc_num)
AND cc_acct_line_num = p_shipment_num;
IS SELECT distribution_num
FROM po_distributions
WHERE po_header_id = x_po_header_id
AND po_line_id = p_po_line_id
AND line_location_id = p_line_location_id;
SELECT segment1
INTO l_cc_num
FROM po_headers
WHERE po_header_id = x_po_header_id;
SELECT CC_STATE,
CC_CTRL_STATUS,
CC_ENCMBRNC_STATUS,
CC_APPRVL_STATUS
INTO l_CC_STATE,
l_CC_CTRL_STATUS,
l_CC_ENCMBRNC_STATUS,
l_CC_APPRVL_STATUS
FROM IGC_CC_HEADERS
WHERE CC_NUM = l_cc_num;
SELECT DISTINCT period_year
INTO l_fiscal_year_invoice
FROM gl_period_statuses
WHERE set_of_books_id = (SELECT set_of_books_id
FROM AP_SYSTEM_PARAMETERS)
AND l_gl_date BETWEEN START_DATE AND END_DATE;
SELECT CC_DET_PF_DATE
INTO l_cc_det_pf_date
FROM IGC_CC_DET_PF
WHERE CC_acct_LINE_ID = c_acct_line1.cc_acct_line_id
AND cc_det_pf_line_num = c_for_each_dist_in_po1.distribution_num;
SELECT DISTINCT period_year
INTO l_fiscal_year_pf
FROM gl_period_statuses
WHERE set_of_books_id = (SELECT set_of_books_id
FROM AP_SYSTEM_PARAMETERS)
AND l_CC_DET_PF_DATE BETWEEN START_DATE AND END_DATE;
SELECT CC_DET_PF_DATE
INTO l_pf_date
FROM IGC_CC_DET_PF
WHERE CC_acct_LINE_ID = (SELECT CC_acct_LINE_ID
FROM IGC_CC_ACCT_LINES
WHERE cc_header_id = (SELECT cc_header_id
FROM IGC_CC_HEADERS
WHERE CC_NUM = l_cc_num)
AND CC_ACCT_LINE_NUM = x_shipment_num)
AND CC_DET_PF_LINE_NUM = x_po_dist_num;
SELECT DISTINCT period_year
INTO l_fiscal_year_pf
FROM gl_period_statuses
WHERE set_of_books_id = (SELECT set_of_books_id
FROM AP_SYSTEM_PARAMETERS)
AND l_pf_date BETWEEN START_DATE AND END_DATE;
SELECT cc_det_pf_date
INTO l_cc_det_pf_date
FROM igc_cc_det_pf
WHERE cc_acct_line_id = c_get_cc_acct_line_id1.cc_acct_line_id
AND cc_det_pf_line_num = c_get_distribution_num1.distribution_num;
SELECT DISTINCT period_year
INTO l_fiscal_year_pf
FROM gl_period_statuses
WHERE set_of_books_id = (SELECT set_of_books_id
FROM AP_SYSTEM_PARAMETERS)
AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
SELECT cc_det_pf_date
INTO l_cc_det_pf_date
FROM igc_cc_det_pf
WHERE cc_acct_line_id = c_get_cc_acct_line_id1.cc_acct_line_id
AND cc_det_pf_line_num = c_get_distribution_num1.distribution_num;
SELECT DISTINCT period_year
INTO l_fiscal_year_pf
FROM gl_period_statuses
WHERE set_of_books_id = (SELECT set_of_books_id
FROM AP_SYSTEM_PARAMETERS)
AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
SELECT cc_det_pf_date
INTO l_cc_det_pf_date
FROM igc_cc_det_pf
WHERE cc_acct_line_id = c_get_cc_acct_line_id1.cc_acct_line_id
AND cc_det_pf_line_num = c_get_distribution_num1.distribution_num;
SELECT DISTINCT period_year
INTO l_fiscal_year_pf
FROM gl_period_statuses
WHERE set_of_books_id = (SELECT set_of_books_id
FROM AP_SYSTEM_PARAMETERS)
AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
SELECT line_location_id
INTO l_line_location_id
FROM po_distributions
WHERE po_distribution_id = x_po_distribution_id;
SELECT shipment_num
INTO l_shipment_num
FROM po_line_locations
WHERE line_location_id = l_line_location_id;
SELECT cc_det_pf_date
INTO l_cc_det_pf_date
FROM igc_cc_det_pf
WHERE cc_acct_line_id = c_get_cc_acct_line_id1.cc_acct_line_id
AND cc_det_pf_line_num = x_po_dist_num;
SELECT DISTINCT period_year
INTO l_fiscal_year_pf
FROM gl_period_statuses
WHERE set_of_books_id = (SELECT set_of_books_id
FROM AP_SYSTEM_PARAMETERS)
AND l_cc_det_pf_date BETWEEN START_DATE AND END_DATE;
SELECT LANGUAGE,
TERRITORY
FROM XDO_LOBS
WHERE LOB_CODE = p_lob_code
AND APPLICATION_SHORT_NAME = p_application_short_name
AND (LOB_TYPE = 'TEMPLATE'
OR LOB_TYPE = 'MLS_TEMPLATE')
AND LANGUAGE = p_lang
AND XDO_FILE_TYPE = 'XSL-FO';
SELECT SUBSTR(userenv('LANG'),1,4) INTO ls_lang FROM dual;
SELECT default_language,
default_territory
INTO l_lang,
p_terr
FROM XDO_TEMPLATES_B
WHERE TEMPLATE_CODE = p_template_code
AND APPLICATION_SHORT_NAME = p_application_short_name ;