The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
chart_of_accounts_id
FROM
gl_sets_of_books
, hr_organization_information
WHERE set_of_books_id = org_information1
AND upper(org_information_context) = upper('Accounting Information')
AND organization_id = c_organization_id;
SELECT
code_combination_id
FROM
gl_code_combinations
WHERE chart_of_accounts_id = c_chart_of_accounts_id
AND code_combination_id = c_code_combination_id
AND nvl(start_date_active,SYSDATE) <= SYSDATE
AND nvl(end_date_active,SYSDATE) >= SYSDATE;
x_valid_org_tbl.DELETE;
SELECT
organization_id
, cost_of_sales_account
, encumbrance_account
, sales_account
, expense_account
, starting_revision
FROM
mtl_parameters
WHERE organization_id = c_organization_id;
x_item_cursor := 'SELECT msi.inventory_item_id' ||
' FROM mtl_system_items_b msi' ||
l_mcat_f ||
' WHERE msi.organization_id = :b_master_org_id ' ||
l_mstk_w ||
l_mcat_w1 ||
l_mcat_w2;
SELECT master_organization_id
INTO l_master_org_id
FROM mtl_parameters
WHERE organization_id = p_org_hier_origin_id;
SELECT mtl_system_items_intf_sets_s.NEXTVAL
INTO l_set_process_id
FROM dual;
SELECT COUNT(*)
INTO l_count
FROM fnd_concurrent_requests
WHERE request_id = p_request_id
AND phase_code = 'C';
x_filtered_org_tbl.DELETE;
SELECT COUNT(*)
INTO l_count
FROM mtl_system_items
WHERE organization_id = p_org_tbl(l_Idx)
AND inventory_item_id = p_inventory_item_id;
SELECT COUNT(*)
INTO l_error_count
FROM mtl_system_items_interface
WHERE request_id = FND_GLOBAL.conc_request_id
/*AND process_flag = 4; Bug 5962957 Changing this to 1 since the records are passed in as process_flag 1*/
SELECT
msib.primary_uom_code primary_uom_code
, msib.primary_unit_of_measure primary_unit_of_measure
FROM
mtl_system_items_b msib
, mtl_units_of_measure muom
WHERE msib.organization_id = c_master_org_id
AND msib.inventory_item_id = c_inventory_item_id
AND msib.primary_unit_of_measure = muom.unit_of_measure
AND SYSDATE < nvl(muom.disable_date,SYSDATE+1);
SELECT
rowid
, inventory_item_id
, organization_id
, transaction_id
, set_process_id
FROM
mtl_system_items_interface
WHERE set_process_id = c_set_process_id
AND inventory_item_id = c_inventory_item_id
AND organization_id = c_organization_id
FOR UPDATE;
SELECT name
INTO l_hierarchy_name
FROM per_organization_structures
WHERE organization_structure_id = p_org_hierarchy_id;
SELECT meaning
INTO l_property
FROM mfg_lookups
WHERE lookup_type = 'INV_MGD_HIER_PROPERTY_TYPE'
AND lookup_code = 1;
INSERT INTO mtl_system_items_interface
( process_flag
, set_process_id
, transaction_type
, inventory_item_id
, organization_id
, primary_uom_code
, primary_unit_of_measure
, cost_of_sales_account
, encumbrance_account
, sales_account
, expense_account
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, request_id
, program_application_id
, program_id
, program_update_date
)
VALUES
( /*4 Bug 5962957 here the validation should happen so changing it to 1*/
1
, l_set_process_id
, 'CREATE'
, l_inventory_item_id
, l_filtered_org_tbl(l_Idx)
, primary_uom_row.primary_uom_code
, primary_uom_row.primary_unit_of_measure
, get_cost_of_sales_account(l_filtered_org_tbl(l_Idx))
, get_encumbrance_account(l_filtered_org_tbl(l_Idx))
, get_sales_account(l_filtered_org_tbl(l_Idx))
, get_expense_account(l_filtered_org_tbl(l_Idx))
, SYSDATE
, FND_GLOBAL.user_id
, SYSDATE
, FND_GLOBAL.user_id
, FND_GLOBAL.login_id
, FND_GLOBAL.conc_request_id
, FND_GLOBAL.prog_appl_id
, FND_GLOBAL.conc_program_id
, SYSDATE
);
INSERT INTO mtl_item_revisions_interface
( inventory_item_id
, organization_id
, revision
, revision_label
, implementation_date
, effectivity_date
, transaction_id
, process_flag
, transaction_type
, set_process_id
, last_update_date
, last_updated_by
, creation_date
, created_by
, last_update_login
, request_id
, program_application_id
, program_id
, program_update_date
, revision_id
)
VALUES
(items_interface_row.inventory_item_id
,items_interface_row.organization_id
,l_rev_label
,l_rev_label
,SYSDATE
,SYSDATE
,MTL_SYSTEM_ITEMS_INTERFACE_S.nextval
,/*4 Bug 5962957 here the validation should happen so changing it to 1*/ 1
,'CREATE'
,l_set_process_id
,SYSDATE
,FND_GLOBAL.user_id
,SYSDATE
,FND_GLOBAL.user_id
,FND_GLOBAL.login_id
,FND_GLOBAL.conc_request_id
,FND_GLOBAL.prog_appl_id
,FND_GLOBAL.conc_program_id
,SYSDATE
,MTL_ITEM_REVISIONS_B_S.nextval
);
, 'Interface records inserted for Item:' || l_inventory_item_id
|| ' '|| 'Process Id:'|| l_set_process_id
);