Following are the BOM main tables.
bom_bill_of_materials
bom_inventory_components
bom_reference_designators
bom_substitute_components
mtl_item_revisions
bom_operational_routings
bom_operation_sequences
bom_operation_resources
BOM_BILL_OF_MTLS_INTERFACE
BOM_INVENTORY_COMPS_INTERFACE
BOM_REF_DESGS_INTERFACE
BOM_SUB_COMPS_INTERFACE
MTL_ITEM_REVISIONS_INTERFACE
BOM_OP_ROUTINGS_INTERFACE
BOM_OP_SEQUENCES_INTERFACE
BOM_OP_RESOURCES_INTERFACE
MTL_RTG_ITEM_REVS_INTERFACE...
Saturday, November 8, 2014
Tuesday, October 14, 2014
Monday, July 28, 2014
Complete Oracle P2P cycle
Lets do a complete P2P Cycle
Step 1) Create Item
Step 2) Create Requisition and Approve it
Step 3) Auto Create RFQ
Step 4) Create Quotation
Step 5) Auto Create PO and Approve it
Step 6) Receipt
Step...
Tuesday, July 22, 2014
SQL Query to find out Parameters and Value Sets associated with a Concurrent Program
SELECT
fcpl.user_concurrent_program_name "Concurrent Program Name",
fcp.concurrent_program_name "Short Name",
fdfcuv.column_seq_num "Column Seq Number",
fdfcuv.end_user_column_name "Parameter Name",
fdfcuv.form_left_prompt...
Monday, July 21, 2014
How to make a Oracle form 'Query Only'
There are
many ways in which we can make a form Query only. We are going to discuss two
1) Using parameter QUERY_ONLY=YES
2) using Form Personalization
Method 1: Using parameter QUERY_ONLY=YES
Lets...
Important WF tables
WF_USER_ROLE_ASSIGNMENTS stores information about the direct and inherited assignments of users to roles in Oracle .
WF_USER_ROLES stores associations of users with the roles of which they are members.
WF_ROLES...
Friday, July 18, 2014
R12 SQL Query to differentiate Customer and Suppliers Data
select * from (
select hp.party_number,hp.party_name,hp.status,decode(nvl(hpu.party_usage_code,hp.party_type),'ORGANIZATION','CUSTOMER',nvl(hpu.party_usage_code,hp.party_type)) party_type
from...
Important HRMS Tables
per_all_people_f
This table is used to store employee related data.
per_all_assignments_f
This table store employee assignment related information and connected to per_all_people_f...
Tuesday, July 15, 2014
Responsibilites and their associated Menus
SELECT DISTINCT frt.responsibility_name, fmt.user_menu_name FROM apps.fnd_responsibility_tl frt, apps.fnd_responsibility fr, ...
Request Group assigned to Responsibilty
SELECT responsibility_name responsibility,request_group_name,frg.description FROM fnd_request_groups frg, fnd_responsibility_vl frv WHERE ...
Responsibility Assigned to Users
SELECT DISTINCT u.user_id ,SUBSTR (u.user_name, 1, 30) user_name ...
List of Responsibilities in an Instance
SELECT (SELECT application_short_name
FROM fnd_application fa
WHERE fa.application_id = frt.application_id) application,
frt.responsibility_id, frt.responsibility_name
FROM...
Monday, July 14, 2014
How to determine Oracle Database And OS version
You can use following two queries to find out the Apps/Database/OS version
select * from v$version;
select * from product_component_version;
Thanks
Mande...
Thursday, July 10, 2014
Session Timeout in Oracle Apps
This post is about how to increase your session time out for oracle application. Sometime its very annoying that session time out is set at very low value. You can increase it for your login by setting...
Interface Trip Stop Functionality
There are typically four
interface program get triggered at the time of ship confirm. They are
Interface Trip stop
Packing Slip Report
Bill of Lading
Invoice
Interface Trip Stop is one...
Wednesday, July 9, 2014
Shipping Parameters Quick Reference
Lets see Oracle Order Management Shipping parameter setups. Please note shipping parameters are inventory org specific where as Global parameters are not.
1) General Tab
#Weight...
Subscribe to:
Posts (Atom)