[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pri.project_id,
pri.task_id,
pri.destination_organization_id,
pri.need_by_date,
pri.transaction_id,
TO_NUMBER(hoi.org_information3)
FROM po_requisitions_interface pri,
hr_organization_information hoi
WHERE pri.project_accounting_context = 'Y'
AND pri.request_id = p_request_id
-- Bug 3043971 We should only perform PJM validation on Inventory and
-- Shop Floor lines (i.e. not Expense):
AND NVL(pri.destination_type_code, 'EXPENSE') IN ('INVENTORY', 'SHOP FLOOR')
AND pri.destination_organization_id = hoi.organization_id
AND hoi.org_information_context = 'Accounting Information';
SELECT d.project_id,
d.task_id,
d.destination_organization_id,
r.need_by_date,
d.transaction_id,
TO_NUMBER(hoi.org_information3)
FROM po_req_dist_interface d,
po_requisitions_interface r,
hr_organization_information hoi
WHERE d.project_accounting_context = 'Y'
AND d.request_id = p_request_id
AND d.dist_sequence_id = r.req_dist_sequence_id
-- Bug 3043971 We should only perform PJM validation on Inventory and
-- Shop Floor lines (i.e. not Expense):
AND NVL(d.destination_type_code, 'EXPENSE') IN ('INVENTORY', 'SHOP FLOOR')
AND d.destination_organization_id = hoi.organization_id
AND hoi.org_information_context = 'Accounting Information';
INSERT INTO po_interface_errors
(interface_type,interface_transaction_id,column_name,
error_message,
creation_date,created_by,last_update_date,last_updated_by,
last_update_login,request_id,program_application_id,program_id,
program_update_date, table_name)
VALUES
('REQIMPORT',l_err_transaction_id_tbl(i),'PROJECT ACCOUNTING COLUMNS',
l_errors_tbl(i),
SYSDATE,p_user_id,SYSDATE,p_user_id,
p_login_id,p_request_id,p_prog_application_id,
p_program_id,SYSDATE,l_interface_table_name);