Misc Transaction

INSERT
INTO mtl_transactions_interface(
transaction_interface_id
, Source_code
, source_header_id
, source_line_id
, process_flag
, transaction_mode
, item_segment1
, inventory_item_id
, organization_id
, distribution_account_id
, subinventory_code
, transaction_uom
, transaction_date
, transaction_type_id
, transaction_quantity
, creation_date
, created_by
, last_update_date
, last_updated_by
)
SELECT MTL_MATERIAL_TRANSACTIONS_S.nexval transaction_interface_id
, 'Costing/Non-costing adjustment' Source_code
, 199 source_header_id
, 199 source_line_id
, -9 process_flag
, 3 transaction_mode
, msi.segment1 item_segment1
, msi.inventory_item_id inventory_item_id
--, ood.organization_code
, ood.organization_id
, DECODE(ood.set_of_books_id,1,50066,NULL) distribution_account_id
, moq.subinventory_code
, moq.transaction_uom_code transaction_uom
, TRUNC(SYSDATE) transaction_date
, 32 transaction_type_id -- issue 42--receipt
, SUM(moq.transaction_quantity) transaction_quantity
, SYSDATE
, 17879
, SYSDATE
, 17879
FROM mtl_system_items msi
, mtl_onhand_quantities_detail moq
, org_organization_definitions ood
WHERE msi.organization_id = 2
AND moq.inventory_item_id = msi.inventory_item_id
AND ood.organization_id = moq.organization_id
AND msi.segment1 IN ('TSTITM')
GROUP BY msi.segment1
, msi.inventory_item_id
--, ood.organization_code
, ood.organization_id
, ood.set_of_books_id
, moq.subinventory_code
, moq.transaction_uom_code

User Responsibility

SELECT DISTINCT u.user_name, wur.role_orig_system_id responsibility_id
, wura.start_date, wura.end_date end_date, wura.created_by created_by
, wura.creation_date creation_date, wura.last_updated_by last_updated_by
, wura.last_update_date last_update_date
, wura.last_update_login last_update_login
, wura.assignment_reason description
, res.responsibility_name
FROM fnd_user u
, wf_user_role_assignments wura
, wf_all_user_roles wur
, fnd_responsibility_tl res
WHERE u.user_name = wura.user_name
AND wura.relationship_id = -1
AND wur.role_orig_system = 'FND_RESP'
AND NOT wura.role_name LIKE 'FND_RESP|%|ANY'
AND wura.role_name = wur.role_name
AND wura.user_name = wur.user_name
AND res.responsibility_id = wur.role_orig_system_id
AND u.user_id = 17879
--AND wur.role_orig_system_id IN ( 53721, 53741 )

Request Set Details

SELECT rs.request_set_name
, rs.user_request_set_name
, rss.stage_name
, rss.user_stage_name
, rss.display_sequence
, rss.success_link_name
, rss.warning_link_name
, c.concurrent_program_name
, c.user_concurrent_program_name
, e.executable_name
, e.execution_method_code
, e.execution_file_name
FROM fnd_concurrent_programs_vl c
, fnd_executables e
, fnd_request_set_programs rsp
, fnd_req_set_stages_form_v rss
, fnd_request_sets_vl rs
WHERE c.executable_id = e.executable_id
AND rsp.concurrent_program_id = c.concurrent_program_id
AND rsp.request_set_id=rs.request_set_id
AND rsp.request_set_stage_id=rss.request_set_stage_id
AND rss.request_set_id=rs.request_set_id
AND rs.request_set_name = 'FNDRSSUB1128'
ORDER BY rss.display_sequence