[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Success'
INTO l_dummy_code
FROM hr_organization_units hou,
hr_locations_all hl
WHERE hou.organization_id = p_warehouse_id
AND hl.location_id = hou.location_id
AND hl.global_attribute1 IS NOT NULL;
SELECT global_attribute8, global_attribute9
INTO l_contributor_class, l_use_site_prof
FROM hz_cust_acct_sites
WHERE cust_acct_site_id = p_address_id;
SELECT count(*)
INTO l_count
FROM JL_ZZ_AR_TX_CUS_CLS
WHERE address_id = p_address_id
AND tax_attr_class_code = l_contributor_class;
SELECT count(*)
INTO l_count
FROM JL_ZZ_AR_TX_ATT_CLS
WHERE tax_attr_class_type = 'CONTRIBUTOR_CLASS'
AND tax_attribute_type = 'CONTRIBUTOR_ATTRIBUTE'
AND tax_attr_class_code = l_contributor_class;
SELECT 'Sucess'
INTO l_dummy_code
FROM fnd_lookups
WHERE lookup_code = p_product_fiscal_class
AND lookup_type = 'JLZZ_AR_TX_FISCAL_CLASS_CODE'
AND enabled_flag = 'Y'
AND sysdate between nvl(start_date_active,sysdate)
and nvl(end_date_active,sysdate);
SELECT delimiter
INTO l_delimiter
FROM zx_fc_types_b
WHERE classification_type_code ='TRX_BUSINESS_CATEGORY';
SELECT 'Sucess'
INTO l_dummy_code
FROM fnd_lookups
WHERE lookup_code = l_trx_business_category
AND lookup_type = 'TRANSACTION_CLASS'
AND enabled_flag = 'Y'
AND sysdate BETWEEN nvl(start_date_active,sysdate)
AND nvl(end_date_active,sysdate);
SELECT FND_NUMBER.canonical_to_number (p_line_attribute11)
INTO l_dummy_code
FROM sys.dual;
SELECT FND_NUMBER.canonical_to_number (p_line_attribute12)
INTO l_dummy_code
FROM sys.dual;
SELECT 'Success'
INTO dummy_code
FROM fnd_lookups
WHERE lookup_code = p_header_attribute1
AND lookup_type = 'JLBR_INTEREST_PENALTY_TYPE'
AND enabled_flag = 'Y'
AND nvl(start_date_active,sysdate) <= sysdate
AND nvl(end_date_active,sysdate+1) >= sysdate;
SELECT 'Success'
INTO dummy_code
FROM dual
WHERE to_number (p_header_attribute3) >= 0;
SELECT 'Success'
INTO dummy_code
FROM fnd_lookups
WHERE lookup_code = p_header_attribute4
AND lookup_type = 'JLBR_INTEREST_FORMULA'
AND enabled_flag = 'Y'
AND nvl(start_date_active,sysdate) <= sysdate
AND nvl(end_date_active,sysdate+1) >= sysdate;
SELECT 'Success'
INTO dummy_code
FROM dual
WHERE to_number (p_header_attribute5) >= 0;
SELECT 'Success'
INTO dummy_code
FROM fnd_lookups
WHERE lookup_code = p_header_attribute6
AND lookup_type = 'JLBR_INTEREST_PENALTY_TYPE'
AND enabled_flag = 'Y'
AND nvl(start_date_active,sysdate) <= sysdate
AND nvl(end_date_active,sysdate+1) >= sysdate;
SELECT return_context
INTO x_return_context
FROM oe_order_lines a, ra_interface_lines_gt b
WHERE a.line_id = b.interface_line_attribute6
AND b.interface_line_id = p_interface_line_id;
SELECT to_number (nvl (p_header_attribute9, 999))
INTO dummy_code
FROM sys.dual;
SELECT to_number (nvl (p_header_attribute10, 999))
INTO dummy_code
FROM sys.dual;
SELECT to_number (nvl (p_header_attribute11, 999))
INTO dummy_code
FROM sys.dual;
SELECT to_number (nvl (p_header_attribute13, 999))
INTO dummy_code
FROM sys.dual;
SELECT FND_NUMBER.canonical_to_number(nvl(p_header_attribute16, 999))
INTO dummy_code
FROM sys.dual;
SELECT FND_NUMBER.canonical_to_number(nvl(p_header_attribute17, 999))
INTO dummy_code
FROM sys.dual;
SELECT 'Success'
INTO dummy_code
FROM jl_br_ap_operations
WHERE cfo_code = p_line_attribute1;
SELECT 'Success'
INTO dummy_code
FROM fnd_lookups
WHERE lookup_code = p_line_attribute4
AND lookup_type = 'JLBR_ITEM_ORIGIN'
AND nvl (end_date_active, sysdate + 1) > sysdate;
SELECT 'Success'
INTO dummy_code
FROM fnd_lookups
WHERE lookup_code = p_line_attribute5
AND lookup_type = 'JLBR_ITEM_FISCAL_TYPE'
AND nvl (end_date_active, sysdate + 1) > sysdate;
SELECT 'Success'
INTO dummy_code
FROM fnd_lookups
WHERE lookup_code = p_line_attribute6
AND lookup_type = 'JLBR_ITEM_FEDERAL_SITUATION'
AND nvl (end_date_active, sysdate + 1) > sysdate;
SELECT 'Success'
INTO dummy_code
FROM fnd_lookups
WHERE lookup_code = p_line_attribute7
AND lookup_type = 'JLBR_ITEM_STATE_SITUATION'
AND nvl (end_date_active, sysdate + 1) > sysdate;
SELECT interface_line_id
, cust_trx_type_id trx_type
, trx_date
, nvl(orig_system_ship_address_id , orig_system_bill_address_id)
orig_system_address_id
, line_type
, memo_line_id
, inventory_item_id
, header_gdf_attribute1
, header_gdf_attribute2
, header_gdf_attribute3
, header_gdf_attribute4
, header_gdf_attribute5
, header_gdf_attribute6
, header_gdf_attribute7
, header_gdf_attribute8
, header_gdf_attribute9
, header_gdf_attribute10
, header_gdf_attribute11
, header_gdf_attribute12
, header_gdf_attribute13
, header_gdf_attribute14
, header_gdf_attribute15
, header_gdf_attribute16
, header_gdf_attribute17
, line_gdf_attribute1
, line_gdf_attribute2
, line_gdf_attribute3
-- nipatel commented out because the columns below will not be added to ra_interface_lines
-- , product_fisc_classification
-- , product_category
-- , trx_business_category
, line_gdf_attribute4
, line_gdf_attribute5
, line_gdf_attribute6
, line_gdf_attribute7
, line_gdf_attribute8
, line_gdf_attribute9
, line_gdf_attribute10
, line_gdf_attribute11
, line_gdf_attribute12
, warehouse_id
, batch_source_name
, trx_number
FROM ra_interface_lines_gt
WHERE request_id = c_request_id
ORDER BY trx_date;