[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
INSERT INTO pa_transaction_interface_all(
transaction_source,
batch_name,
expenditure_ending_date,
employee_number,
organization_name,
expenditure_item_date,
project_number,
task_number,
expenditure_type,
non_labor_resource,
non_labor_resource_org_name,
quantity,
raw_cost,
expenditure_comment,
transaction_status_code,
transaction_rejection_code,
expenditure_id,
orig_transaction_reference,
attribute_category,
attribute1,
attribute2,
attribute3,
attribute4,
attribute5,
attribute6,
attribute7,
attribute8,
attribute9,
attribute10,
raw_cost_rate,
interface_id,
unmatched_negative_txn_flag,
expenditure_item_id,
org_id,
dr_code_combination_id,
cr_code_combination_id,
cdl_system_reference1,
cdl_system_reference2,
cdl_system_reference3,
cdl_system_reference4,
cdl_system_reference5,
gl_date,
burdened_cost,
burdened_cost_rate,
system_linkage,
txn_interface_id,
user_transaction_source,
created_by,
creation_date,
last_updated_by,
last_update_date,
receipt_currency_amount,
receipt_currency_code,
receipt_exchange_rate,
denom_currency_code,
denom_raw_cost,
denom_burdened_cost,
acct_rate_date,
acct_rate_type,
acct_exchange_rate,
acct_raw_cost,
acct_burdened_cost,
acct_exchange_rounding_limit,
project_currency_code,
project_rate_date,
project_rate_type,
project_exchange_rate,
orig_exp_txn_reference1,
orig_exp_txn_reference2,
orig_exp_txn_reference3,
orig_user_exp_txn_reference,
vendor_number,
override_to_organization_name,
reversed_orig_txn_reference,
billable_flag,
person_business_group_name,
net_zero_adjustment_flag,
adjusted_expenditure_item_id,
organization_id,
inventory_item_id,
po_number,
po_header_id,
po_line_num,
po_line_id,
vendor_id,
project_id,
task_id,
document_type,
document_distribution_type)
VALUES(
p_nl_pa_interface_tbl(i).transaction_source,
p_nl_pa_interface_tbl(i).batch_name,
p_nl_pa_interface_tbl(i).expenditure_ending_date,
p_nl_pa_interface_tbl(i).employee_number,
p_nl_pa_interface_tbl(i).organization_name,
p_nl_pa_interface_tbl(i).expenditure_item_date,
p_nl_pa_interface_tbl(i).project_number,
p_nl_pa_interface_tbl(i).task_number,
p_nl_pa_interface_tbl(i).expenditure_type,
p_nl_pa_interface_tbl(i).non_labor_resource,
p_nl_pa_interface_tbl(i).non_labor_resource_org_name,
p_nl_pa_interface_tbl(i).quantity,
p_nl_pa_interface_tbl(i).raw_cost,
p_nl_pa_interface_tbl(i).expenditure_comment,
p_nl_pa_interface_tbl(i).transaction_status_code,
p_nl_pa_interface_tbl(i).transaction_rejection_code,
p_nl_pa_interface_tbl(i).expenditure_id,
p_nl_pa_interface_tbl(i).orig_transaction_reference,
p_nl_pa_interface_tbl(i).attribute_category,
p_nl_pa_interface_tbl(i).attribute1,
p_nl_pa_interface_tbl(i).attribute2,
p_nl_pa_interface_tbl(i).attribute3,
p_nl_pa_interface_tbl(i).attribute4,
p_nl_pa_interface_tbl(i).attribute5,
p_nl_pa_interface_tbl(i).attribute6,
p_nl_pa_interface_tbl(i).attribute7,
p_nl_pa_interface_tbl(i).attribute8,
p_nl_pa_interface_tbl(i).attribute9,
p_nl_pa_interface_tbl(i).attribute10,
p_nl_pa_interface_tbl(i).raw_cost_rate,
p_nl_pa_interface_tbl(i).interface_id,
p_nl_pa_interface_tbl(i).unmatched_negative_txn_flag,
p_nl_pa_interface_tbl(i).expenditure_item_id,
p_nl_pa_interface_tbl(i).org_id,
p_nl_pa_interface_tbl(i).dr_code_combination_id,
p_nl_pa_interface_tbl(i).cr_code_combination_id,
p_nl_pa_interface_tbl(i).cdl_system_reference1,
p_nl_pa_interface_tbl(i).cdl_system_reference2,
p_nl_pa_interface_tbl(i).cdl_system_reference3,
p_nl_pa_interface_tbl(i).cdl_system_reference4,
p_nl_pa_interface_tbl(i).cdl_system_reference5,
p_nl_pa_interface_tbl(i).gl_date,
p_nl_pa_interface_tbl(i).burdened_cost,
p_nl_pa_interface_tbl(i).burdened_cost_rate,
p_nl_pa_interface_tbl(i).system_linkage,
p_nl_pa_interface_tbl(i).txn_interface_id,
p_nl_pa_interface_tbl(i).user_transaction_source,
p_nl_pa_interface_tbl(i).created_by,
p_nl_pa_interface_tbl(i).creation_date,
p_nl_pa_interface_tbl(i).last_updated_by,
p_nl_pa_interface_tbl(i).last_update_date,
p_nl_pa_interface_tbl(i).receipt_currency_amount,
p_nl_pa_interface_tbl(i).receipt_currency_code,
p_nl_pa_interface_tbl(i).receipt_exchange_rate,
p_nl_pa_interface_tbl(i).denom_currency_code,
p_nl_pa_interface_tbl(i).denom_raw_cost,
p_nl_pa_interface_tbl(i).denom_burdened_cost,
p_nl_pa_interface_tbl(i).acct_rate_date,
p_nl_pa_interface_tbl(i).acct_rate_type,
p_nl_pa_interface_tbl(i).acct_exchange_rate,
p_nl_pa_interface_tbl(i).acct_raw_cost,
p_nl_pa_interface_tbl(i).acct_burdened_cost,
p_nl_pa_interface_tbl(i).acct_exchange_rounding_limit,
p_nl_pa_interface_tbl(i).project_currency_code,
p_nl_pa_interface_tbl(i).project_rate_date,
p_nl_pa_interface_tbl(i).project_rate_type,
p_nl_pa_interface_tbl(i).project_exchange_rate,
p_nl_pa_interface_tbl(i).orig_exp_txn_reference1,
p_nl_pa_interface_tbl(i).orig_exp_txn_reference2,
p_nl_pa_interface_tbl(i).orig_exp_txn_reference3,
p_nl_pa_interface_tbl(i).orig_user_exp_txn_reference,
p_nl_pa_interface_tbl(i).vendor_number,
p_nl_pa_interface_tbl(i).override_to_organization_name,
p_nl_pa_interface_tbl(i).reversed_orig_txn_reference,
p_nl_pa_interface_tbl(i).billable_flag,
p_nl_pa_interface_tbl(i).person_business_group_name,
p_nl_pa_interface_tbl(i).net_zero_adjustment_flag,
p_nl_pa_interface_tbl(i).adjusted_expenditure_item_id,
p_nl_pa_interface_tbl(i).organization_id,
p_nl_pa_interface_tbl(i).inventory_item_id,
p_nl_pa_interface_tbl(i).po_number,
p_nl_pa_interface_tbl(i).po_header_id,
p_nl_pa_interface_tbl(i).po_line_num,
p_nl_pa_interface_tbl(i).po_line_id,
p_nl_pa_interface_tbl(i).vendor_id,
p_nl_pa_interface_tbl(i).project_id,
p_nl_pa_interface_tbl(i).task_id,
p_nl_pa_interface_tbl(i).document_type,
p_nl_pa_interface_tbl(i).document_distribution_type);
SELECT asset_category_id
INTO l_asset_category_id
FROM mtl_system_items
WHERE inventory_item_id = p_item_id
AND organization_id = p_inv_master_org_id;
SELECT 'Y' INTO l_cat_book_assigned
FROM sys.dual
WHERE EXISTS (
SELECT 1 FROM fa_category_books
WHERE category_id = l_asset_category_id
AND book_type_code = l_book_type_code);
SELECT class_code
FROM pa_project_classes
WHERE project_id = p_project_id
AND class_category = 'Product';
SELECT asset_location, asset_category
INTO l_grp_asset_location, l_grp_asset_category
FROM ipa_asset_naming_convents_all
WHERE org_id = p_org_id;