To find the scheduled reports in oracle apps

SELECT fl.meaning
     , fu.user_name
     , fu.description requestor
     , fu.end_date
     , NVL(fu.email_address, 'n/a') email_address
     , fcr.request_id
     , fcr.number_of_copies
     , fcr.printer
     , fcr.request_date
     , fcr.requested_start_date
     , fcp.description,fcp.user_concurrent_program_name
     , fcr.argument_text
     , frt.responsibility_name
  FROM apps.fnd_concurrent_requests fcr
     , apps.fnd_user fu
     , apps.fnd_lookups fl
     , apps.fnd_concurrent_programs_vl fcp
     , apps.fnd_responsibility_tl frt
 WHERE fcr.requested_by = fu.user_id
   AND fl.lookup_type = 'CP_STATUS_CODE'
   AND fcr.status_code = fl.lookup_code
   AND fcr.program_application_id = fcp.application_id
   AND fcr.concurrent_program_id = fcp.concurrent_program_id
   AND fcr.responsibility_id = frt.responsibility_id
   AND fcr.phase_code = 'P'
   ORDER BY fu.user_name

to count the number of concurrent requests submitted by particular user

Select B.user_concurrent_program_name,C.user_name,D.responsibility_name, A.*
from apps.fnd_concurrent_requests A, apps.fnd_concurrent_programs_tl B, Apps.fnd_user C, apps.fnd_responsibility_tl D
 where 1=1
and  B.user_concurrent_program_name like
 'Test Report'
 and B.concurrent_program_id=A.concurrent_program_id
 and A.requested_by=C.user_id
 and A.responsibility_id=D.responsibility_id
 order by request_date desc

Procedure to get the Concurrent program

DECLARE
CP VARCHAR2(250);
SHORT_NAME VARCHAR2(150);
CP_DESC VARCHAR2(250);
APPL_ID NUMBER(10);
OUTPUT_TYPE VARCHAR2(25);
STATUS VARCHAR2(15);
EX_METHOD VARCHAR2(150);
APPLICATION_NAME VARCHAR2(50);
EX_DESC VARCHAR2(150);
EX_FILE_NAME VARCHAR2(200);
PARAMETER VARCHAR2(200);
PROMPT VARCHAR2(150);
VALUE_SET VARCHAR2(250);
CURSOR REP_CUR IS SELECT USER_CONCURRENT_PROGRAM_NAME FROM FND_CONCURRENT_PROGRAMS_VL
                         WHERE USER_CONCURRENT_PROGRAM_NAME LIKE  'ITW_EX_INVOICE_BR_NEW_CESS'
AND ENABLED_FLAG='Y'
;
  -- ORDER BY CONCURRENT_PROGRAM_ID;
BEGIN
FOR I IN REP_CUR LOOP
--DBMS_OUTPUT.PUT_LINE(I.USER_CONCURRENT_PROGRAM_NAME);
--END LOOP;
--END;
SELECT DISTINCT FCPT.USER_CONCURRENT_PROGRAM_NAME
,FCPT.CONCURRENT_PROGRAM_NAME CP_SHORT_NAME
,FCPT.DESCRIPTION CP_DESC
,FCPT.APPLICATION_ID
--,FCP.CONCURRENT_PROGRAM_NAME SHORT_NAME
,FCP.OUTPUT_FILE_TYPE
,DECODE(FCP.ENABLED_FLAG,'Y','ACTIVE','N','INACTIVE')STATUS
,DECODE(FEX.EXECUTION_METHOD_CODE,'I','PL/SQL Stored Procedure','H','Host','P','Oracle Reports',
                                 'K','Java Concurrernt Program','Q','SQL*Plus','M','Multi Lanuage Function',
'A','Spawned','J','Java Stored Procedure','B','Request Set Stage Function',
'S','Immediate','L','SQL*Loader','P','Perl Concurrent Program')EXECUTION_METHOD
,FEX.APPLICATION_NAME
,FEX.DESCRIPTION EX_DESC
,FEX.EXECUTION_FILE_NAME
,FDP.SRW_PARAM
/*,FORM_LEFT_PROMPT PROMPT
,FFVS.FLEX_VALUE_SET_NAME*/
---
INTO
CP
,SHORT_NAME
,CP_DESC
,APPL_ID
,OUTPUT_TYPE
,STATUS
,EX_METHOD
,APPLICATION_NAME
,EX_DESC
,EX_FILE_NAME
,PARAMETER
/*,PROMPT
,VALUE_SET*/
FROM
--FND_CONCURRENT_PROGRAMS_TL FCPT,
FND_CONCURRENT_PROGRAMS_VL FCPT
,FND_CONCURRENT_PROGRAMS FCP
,FND_EXECUTABLES_FORM_V FEX
,FND_DESCR_FLEX_COL_USAGE_VL FDP
,FND_FLEX_VALUE_SETS FFVS
WHERE
FCPT.CONCURRENT_PROGRAM_ID = FCP.CONCURRENT_PROGRAM_ID
AND FCP.EXECUTABLE_ID = FEX.EXECUTABLE_ID
AND FCPT.APPLICATION_ID = FDP.APPLICATION_ID
AND FCPT.CONCURRENT_PROGRAM_NAME = SUBSTR(FDP.DESCRIPTIVE_FLEXFIELD_NAME,7)    --or FDP.DESCRIPTIVE_FLEXFIELD_NAME = '$SRS$.'||FCPT.CONCURRENT_PROGRAM_NAME)
AND FDP.FLEX_VALUE_SET_ID=FFVS.FLEX_VALUE_SET_ID
AND FCP.ENABLED_FLAG='Y'
AND FCPT.CONCURRENT_PROGRAM_NAME=I.USER_CONCURRENT_PROGRAM_NAME;
--AND FCPT.USER_CONCURRENT_PROGRAM_NAME like 'ITW_EX_INVOICE_BR_NEW_CESS'
--AND FCPT.CONCURRENT_PROGRAM_ID <> 0
DBMS_OUTPUT.PUT_LINE(CP
                     ||CHR(9)||SHORT_NAME||CHR(9)||
          CP_DESC||CHR(9)||
  APPL_ID||CHR(9)||
  OUTPUT_TYPE||CHR(9)||
  STATUS||CHR(9)||
  EX_METHOD||CHR(9)||
  APPLICATION_NAME||CHR(9)||
  EX_DESC||CHR(9)||
  EX_FILE_NAME||CHR(9)||
  PARAMETER||CHR(9)/*||
  PROMPT||CHR(9)||
  VALUE_SET||CHR(9)*/
  );
END LOOP;
--DBMS_OUTPUT.PUT_LINE('HAI'||CP_NAME);
END;

Buyer Address from front end

Standard Purchase Order

select
a.po_header_id,
a.BLANKET_TOTAL_AMOUNT ceiling_of_the_order,
a.end_date valid_till,
a.creation_date,
a.segment1,a.comments,
a.revision_num ,
a.revised_date,
a.APPROVED_DATE,
b.po_line_id pld,
a.ship_to_location_id,a.agent_id ,a.ship_via_lookup_code,A.TERMS_ID,
a.attribute1,A.FREIGHT_TERMS_LOOKUP_CODE FREIGHT,a.fob_lookup_code,
a.bill_to_location_id,b.line_num,b.item_id,b.item_description,b.quantity,
b.unit_price,(b.quantity*b.unit_price) qty_into_rate,fvl.description,
b.unit_meas_lookup_code,c.segment1 vendor_code,c.vendor_name,d.address_line1 vendad1,
d.address_line2 vednad2,d.address_line3 vendad3,
d.city,d.state,d.zip,d.province, fnd.territory_short_name country,
d.area_code, d.phone,d.fax,
d.email_address,
b.po_line_id line_id,
a.bill_to_location_id,
a.ship_to_location_id,
a.attribute4 Attachment,
fvl.description  meaning,
a.attribute3 format,
fvl2.description format_desc,
e.line_location_id,
e.need_by_date ship_need_date,
e.quantity shp_qty,
a.org_id,
b.unit_meas_lookup_code uom_cd
from
po_headers_all a,
po_lines_all b,
po_vendors c,
po_vendor_sites_all d,
fnd_flex_values_vl  fvl,
FND_TERRITORIES_VL fnd,
FND_FLEX_VSET_V ffv,
fnd_flex_values_vl  fvl2,
FND_FLEX_VSET_V ffv2,
po_line_locations_all e
where a.po_header_id=b.po_header_id
and a.vendor_id=c.vendor_id
and nvl(a.cancel_flag,'N') = 'N'
and nvl(b.cancel_flag,'N') = 'N'
and a.vendor_site_id=d.vendor_site_id
and c.vendor_id=d.vendor_id
and
fvl.flex_value=a.attribute1  and  fvl.flex_value_set_id=ffv.flex_value_set_id
and ffv.parent_value_set_name like 'DIV_TEST'
and
fvl2.flex_value=a.attribute3  and  fvl2.flex_value_set_id=ffv2.flex_value_set_id
and ffv2.parent_value_set_name like 'FORMAT_TEST'
and
fnd.territory_code      =   d.country AND
a.segment1  = :purchase_order_from
and a.org_id = :p_org_id
and
b.po_header_id =e.po_header_id and
b.po_line_id =e.po_line_id;

Journal Voucher Query

SELECT A.JE_HEADER_ID,A.JE_BATCH_ID,GJB.ORG_ID,
C.SEGMENT3 LOCATION,
A.DOC_SEQUENCE_VALUE  VOUCHER_NO,
A.JE_CATEGORY CATEGORY,
D.USER_JE_CATEGORY_NAME CATEGORY_NAME,
A.DESCRIPTION,
A.CURRENCY_CODE CUR,
A.DEFAULT_EFFECTIVE_DATE EFFECTIVE_DATE,
C.SEGMENT1||'.'||C.SEGMENT2 ||'.'||C.SEGMENT3||'.'||C.SEGMENT4 ||'.'||C.SEGMENT5||'.'||C.SEGMENT6||'.'||C.SEGMENT7  ACCOUNTING_FLEXFIELD,
C.SEG1_desc||'.'||C.SEG2_desc ||'.'||REPLACE(seg3_desc,'/','') ||'.'||C.SEG4_desc ||'.'||REPLACE(seg5_desc,'/','') ||'.'||C.SEG6_desc||'.'||C.SEG7_desc Des,
C.SEG3_desc SEG2_desc,
B.DESCRIPTION NARRATION,
B.ACCOUNTED_DR ACCOUNTED_DEBIT,
B.ACCOUNTED_CR ACCOUNTED_CREDIT
FROM
GL_JE_HEADERS A,
GL_JE_LINES B,
GL_CODE_COMBINATIONS C,
GL_JE_CATEGORIES_TL D,
GL_JE_BATCHES  GJB
WHERE    
A.JE_HEADER_ID = B.JE_HEADER_ID
AND           B.CODE_COMBINATION_ID = C.CODE_COMBINATION_ID
AND           A.JE_CATEGORY = D.JE_CATEGORY_NAME
AND           A.DOC_SEQUENCE_VALUE between  nvl(:P_VOUCHER_NO_FROM, A.DOC_SEQUENCE_VALUE)  AND nvl(:P_VOUCHER_NO_TO,  A.DOC_SEQUENCE_VALUE)
AND           A.JE_CATEGORY = nvl( :P_CATEGORY,  A.JE_CATEGORY)
AND  A.DEFAULT_EFFECTIVE_DATE BETWEEN to_date('1-APR-'||substr(:P_FIN_YEAR,1,4)) and to_date('31-MAR-'||substr(:P_FIN_YEAR,6,9))
AND   A.JE_BATCH_ID=GJB.JE_BATCH_ID

TABLES---->JOINS

KEY JOINS

GL AND AP
GL_CODE_COMBINATIONS AP_INVOICES_ALL
code_combination_id = acct_pay_code_combination_id
GL_CODE_COMBINATIONS AP_INVOICES_DISTRIBUTIONS_ALL
code_combination_id = dist_code_combination_id
GL_SETS_OF_BOOKS AP_INVOICES_ALL
set_of_books_id = set_of_books_id

GL AND AR
GL_CODE_COMBINATIONS RA_CUST_TRX_LINE__GL_DIST_ALL
code_combination_id = code_combination_id

GL AND INV
GL_CODE_COMBINATIONS MTL_SYSTEM_ITEMS_B
code_combination_id = cost_of_sales_account


GL AND PO
GL_CODE_COMBINATIONS PO_DISTRIBUTIONS_ALL
code_combination_id = code_combination_id


PO AND AP
PO_DISTRIBUTIONS_ALL AP_INVOICE_DISTRIBUTIONS_ALL
Po_distribution_id = po_distribution_id

PO_VENDORS AP_INVOICES_ALL
vendor_id = vendor_id

PO AND SHIPMENTS
PO_HEADERS_ALL RCV_TRANSACTIONS
Po_header_id = po_header_id

PO_DISTRIBUTIONS_ALL RCV_TRANSACTIONS
Po_distribution_id = po_distribution_id

SHIPMENTS AND INVOICE
RCV_TRANSACTIONS AP_INVOICE_DISTRIBUTIONS_ALL
RCV_TRANSACTION_ID = RCV_TRANSACTION_ID


PO AND INV
PO_REQUISITION_LINES_ALL MTL_SYSTEM_ITEMS_B
item_id = inventory_item_id
org_id = organization_id

PO AND HRMS
PO_HEADERS_ALL HR_EMPLOYEES
Agent_id = employee_id

PO AND REQUISITION
PO_DISTRIBUTIONS_ALL PO_REQ_DISTRIBUTIONS_ALL
req_distribution_id = distribution_id


SHIPMENTS AND INV
RCV_TRANSACTIONS MTL_SYSTEM_ITEMS_B
Organization_id = organization_id

INV AND HRMS
MTL_SYSTEM_ITEMS_B HR_EMPLOYEES
buyer_id = employee_id

OM AND AR
OE_ORDER_HEADERS_ALL RA_CUSTOMER_TRX_LINES_ALL
TO_CHAR( Order_number) = interface_line_attribute1
OE_ORDER_LINES_ALL RA_CUSTOMER_TRX_LINES_ALL
TO_CHAR(Line_id) = interface_line_attribute6

OE_ORDER_LINES_ALL RA_CUSTOMER_TRX_LINES_ALL
reference_customer_trx_line_id = customer_trx_line_id

OM AND SHIPPING
OE_ORDER_HEADERS_ALL WSH_DELIVARY_DETAILS

HEADER_ID = SOURCE_HEADER_ID

OE_ORDER_HEADERS_ALL WSH_DELIVARY_DETAILS
LINE_ID = SOURCE_LINE_ID
AP AND AR (BANKS)
AR_CASH_RECEIPTS_ALL AP_BANK_ACCOUNTS
REMITTANCE_BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID
AP AND AR
HZ_PARTIES AP_INVOICES_ALL

PARTY_ID = PARTY_ID

OM AND CRM
OE_ORDER_LINES_ALL CSI_ITEM_INSTANCES(Install Base)

LINE_ID = LAST_OE_ORDER_LINE_ID
Table Name: Po_Requisition_Headers_All A
Column Names Table Name Column Name
A. REQUISITION_HEADER_ID PO_REQUISITION_LINES_ALL REQUISITION_HEADER_ID
A. TYPE_LOOKUP_CODE PO_DOCUMENT_TYPES DOCUMENT_SUBTYPE
A. PREPARER_ID PER_PEOPLE_F PERSON_ID
A. ORG_ID MTL_SYSTEM_ITEMS ORGANIZATION_ID
A. ORG_ID MTL_ORGANIZATIONS ORGANIZATION_ID
Table Name: Po_Requisition_Lines_All B
Column Names Table Name Column Name
B .REQUISITION_HEADER_ID PO_REQUISITION_HEADERS_ALL REQUISITION_HEADER_ID
B .REQUISITION_LINE_ID PO_REQ_DISTRIBUTIONS_ALL REQUISITION_LINE_ID
B .LINE_TYPE_ID PO_LINE_TYPES LINE_TYPE_ID
B .ITEM_ID MTL_SYSTEM_ITEMS INVENTORY_ITEM_ID
B .ORG_ID MTL_SYSTEM_ITEMS ORGANIZATION_ID
Table Name: Po_Requisition_Distributions_All C .
Column Names Table Name Column Name
C .REQUISITION_LINE_ID PO_REQUISITION_LINES_ALL REQUISITION_LINE_ID
C .DISTRIBUTION_ID PO_DISTRIBUTIONS_ALL REQ_DISTRIBUTION_ID
C .SET_OF_BOOKS_ID GL_SETS_OF_BOOKS SET_OF_BOOKS_ID
C .CODE_COMBINATION_ID GL_CODE-COMBINATIONS CODE_COMBINATION_ID
Table Name: Po_Distributions_All D .
Column Names Table Name Column Name
D .PO_LINE_ID PO_LINES PO_LINE_ID
D .REQ_DISTRIBUTION_ID PO_REQ_DISTRIBUTIONS_ALL DISTRIBUTION_ID
D .PO_DISTRIBUTION_ID AP_INVOICE_DISTRIBUTIONS_ALL PO_DISTRIBUTION_ID
Table Name: Po_Headers_All E .
Column Names Table Name Column Name
E .PO_HEADER_ID PO_LINES PO_HEADER_ID
E .PO_HEADER_ID RCV_SHIPMENT_LINES PO_HEADER_ID
E .VENDOR_ID PO_VENDORS VENDOR_ID
E .AGENT_ID PER_PEOPLE PERSON_ID
E .TYPE_LOOK_UP_CODE PO_DOCUMENT_TYPES DOCUMENT_SUBTYPE
Table Name: Po_Lines_All F.
Column Names Table Name Column Name
F.PO_HEADER_ID PO_HEADERS PO_HEADER_ID
F.PO_LINE_ID PO_DISTRIBUTIONS_ALL PO_LINE_ID
F.ITEM_ID MTL_SYSTEM_ITEMS ITEM_ID
Table Name: Rcv_Shipment_Lines G.
Column Names Table Name Column Name
G.PO_HEADER_ID PO_HEADERS PO_HEADER_ID
G.SHIPMENT_HEADER_ID RCV_SHIPMENT_HEADERS SHIPMENT_HEADER_ID
Table Name: Ap_Invoices_All H.
Column Names Table Name Column Name
H. INVOICE_ID AP_INVOICE_DISTRIBUTIONS_ALL INVOICE_ID
Table Name: Oe_Order_Headers_All I.
Column Names Table Name Column Name
I.HEADER_ID OE_ORDER_LINES HEADER_ID
I.SOURCE_HEADER_ID WISH_DELIVERY_DETAILS SOURCE_HEADER_ID
I.PRICE_LIST_ID QP_LIST_HEADERS_TL LIST_HEADER_ID
I.ORG_ID MTL_ORGANIZATIONS ORGANIZATION_ID
I.SALESREP_ID JTF_RS_SALESREPS SALESREP_ID
I.ORDER_TYPE_ID OE_TRANSACTION_TYPES TRANSACTION_TYPE_ID
I.ORDER_SOURCE_ID OE_ORDER_SOURCES ORDER_SOURCE_ID
I.ACCOUNTING_RULE_ID RA_RULES RULE_ID
I.PAYMENT_TERM_ID RA_TERMS TERM_ID
I.SOLD_TO_ORG_ID HZ_CUST_ACCOUNTS CUST_ACCOUNT_ID
I.SHIP_FROM_ORG_ID MTL_PARAMETERS ORGANIZATION_ID
I.SHIP_TO_ORG_ID HZ_CUST_SITE_USES_ALL SITE_USE_ID
Table Name: Oe_Order_Lines_All J.
Column Names Table Name Column Name
J.LINE_TYPE_ID OE_TRANSACTION_TYPES_TL TRANSACTION_TYPE_ID
J.INVOICING_RULE_ID RA_RULES RULE_ID
Table Name: Hz_Parties K.
Column Names Table Name Column Name
K.PATY_ID HZ_CUST_ACCOUNTS PATY_ID
K.CUST_ACCOUNT_ID OE_ORDER_LINES SOLD_TO_ORG_ID
Table Name: Hz_Party_Sites_All L.
Column Names Table Name Column Name
L.PATY_ID HZ_PARTIES PATY_ID
L. LOCATION_ID HZ_LOCATIONS LOCATION_ID
Table Name: Wsh_delivery_details M.
Column Names Table Name Column Name
M.SOURCE_HEADER_ID OE_ORDER_HEADERS SOURCE_HEADER_ID
M.DELIVERY_DETAIL_ID WSH_DELIVERY_ASSIGNMENTS DELIVERY_DETAIL_ID
M.DELIVERY_ID WSH_NEW_DELIVERIES DELIVERY_ID
M.INVENTORY_ITEM_ID MTL_SYSTEM_ITEMS INVENTORY_ITEM_ID
Table Name: RA_CUSTOMER_TRX_ALL N.
Column Names Table Name Column Name
N.CUSTOMER_TRX_ID AR_RECEIVABLE_APPLICATIONS_ALL APPLIED_CUSTOMER_TRX_ID
N.TERM_ID RA_TERMS TERM_ID
N.CUSTOMER_TRX_ID RA_CUST_TRX_LINE_GL_DIST CUSTOMER_TRX_ID
Table Name: AR_CASH_REC EIPTS_ALL O.
Column Names Table Name Column Name
O.CASH_RECEIPT_ID AR_RECEIVABLE_APPLICATIONS_ALL CASH_RECEIPT_ID
O.SET_OF_BOOKS_ID GL_SETS_OF_BOOKS SET_OF_BOOKS_ID


Read more: http://prasanthapps.blogspot.com/2011/05/join-conditions-used-in-oracle.html#ixzz1PFCphsD9

Posted by REDDY at 3:17 AM , 0 comments

Labels: AP, AR, INV ETC), JOIN CONDITIONS USED IN ORACLE APPS(GL

Saturday, April 23, 2011

ORDER MANAGEMENT TABLES

Entered
oe_order_headers_all 1 record created in header table
oe_order_lines_all Lines for particular records
oe_price_adjustments When discount gets applied
oe_order_price_attribs If line has price attributes then populated
oe_order_holds_all If any hold applied for order like credit check etc.
Booked
oe_order_headers_all Booked_flag=Y Order booked.
wsh_delivery_details Released_status Ready to release
Pick Released
wsh_delivery_details Released_status=Y Released to Warehouse (Line has been released to Inventory for processing)
wsh_picking_batches After batch is created for pick release.
mtl_reservations This is only soft reservations. No physical movement of stock
Full Transaction
mtl_material_transactions No records in mtl_material_transactions
mtl_txn_request_headers
mtl_txn_request_lines
wsh_delivery_details Released to warehouse.
wsh_new_deliveries if Auto-Create is Yes then data populated.
wsh_delivery_assignments deliveries get assigned
Pick Confirmed
wsh_delivery_details Released_status=Y Hard Reservations. Picked the stock. Physical movement of stock
Ship Confirmed
wsh_delivery_details Released_status=C Y To C:Shipped ;Delivery Note get printed Delivery assigned to trip stopquantity will be decreased from staged
mtl_material_transactions On the ship confirm form, check Ship all box
wsh_new_deliveries If Defer Interface is checked I.e its deferred then OM & inventory not updated. If Defer Interface is not checked.: Shipped
oe_order_lines_all Shipped_quantity get populated.
wsh_delivery_legs 1 leg is called as 1 trip.1 Pickup & drop up stop for each trip.
oe_order_headers_all If all the lines get shipped then only flag N
Autoinvoice
wsh_delivery_details Released_status=I Need to run workflow background process.
ra_interface_lines_all Data will be populated after wkfw process.
ra_customer_trx_all After running Autoinvoice Master Program for
ra_customer_trx_lines_all specific batch transaction tables get populated
Price Details
qp_list_headers_b To Get Item Price Details.
qp_list_lines
Items On Hand Qty
mtl_onhand_quantities TO check On Hand Qty Items.
Payment Terms
ra_terms Payment terms
AutoMatic Numbering System
ar_system_parametes_all you can chk Automactic Numbering is enabled/disabled.
Customer Information
hz_parties Get Customer information include name,contacts,Address and Phone
hz_party_sites
hz_locations
hz_cust_accounts
hz_cust_account_sites_all
hz_cust_site_uses_all
ra_customers
Document Sequence
fnd_document_sequences Document Sequence Numbers
fnd_doc_sequence_categories
fnd_doc_sequence_assignments
Default rules for Price List
oe_def_attr_def_rules Price List Default Rules
oe_def_attr_condns
ak_object_attributes
End User Details
csi_t_party_details To capture End user Details
Sales Credit Sales Credit Information(How much credit can get)
oe_sales_credits

Attaching Documents
fnd_attached_documents Attched Documents and Text information
fnd_documents_tl
fnd_documents_short_text
Blanket Sales Order
oe_blanket_headers_all Blanket Sales Order Information.
oe_blanket_lines_all

Processing Constraints
oe_pc_assignments Sales order Shipment schedule Processing Constratins
oe_pc_exclusions
Sales Order Holds
oe_hold_definitions Order Hold and Managing Details.
oe_hold_authorizations
oe_hold_sources_all
oe_order_holds_all
Hold Relaese
oe_hold_releases_all Hold released Sales Order.
Credit Chk Details
oe_credit_check_rules To get the Credit Check Againt Customer.
Cancel Orders
oe_order_lines_all Cancel Order Details.

Posted by REDDY at 5:26 AM , 0 comments

Labels: OM

IMPORTANT APPS TABLES

PO Modules:
1. Po_requisition_headers_all -- Req. Header Info
2. Po_requisition_lines_all -- Req. Lines Info
3. Po_req_distributions_all -- Req.Distributions Info
4. PO_HEADERS_ALL -- PO Header Information
5. PO_LINES_AL -- PO Line Information
6. PO_LINE_LOCATIONS_ALL -- PO Line Shipment Info
7. PO_DISTRIBUTIONS_ALL -- PO Accounting Info
8. rcv_shipment_headers -- Receipt Header Info
9. rcv_shipment_lines -- Receipt Line Info
10. rcv_transactions -- Receipt Transactions
11. rcv_routing_headers -- Receipt Routing info
12. po_vendors -- Supplier Header
13. po_vendor_sites_all -- supplier site level info
14. po_vendor_contacts -- Supplier Contacts Info
15. hr_locations -- Supplier Physical address info

Order Management Tables
1. oe_order_headers_all -- Order Header info
2. oe_order_lines_all -- order line info
3. oe_transaction_types_tl -- Order Type
4. hz_cust_accounts -- Customer Info
5. hz_parties -- Party Info
6. hz_cust_site_uses_all -- Customer site info
7. hz_cust_acct_sites_all -- Customer acct
8. hz_party_sites -- customer site level info
9. hz_locations -- Customer Phsyical Location
10.ra_sales_reps_all -- Sales Reps
11.Qp_list_headers_tl -- Pricing info
12.wsh_delivery_detials -- Shipping DElivery details
13.wsh_delivery_assignments --shipping deliver assignments
14.wsh_new_deliveries -- Delivery Header info
15.oe_order_holds -- order hold info
16.oe_hold_sources_all -- hold source
17.oe_hold_releases_ll -- hold releases
18.oe_hold_definitions

General Ledger (GL)
1.gl_je_batches -- Journal Batches
2.gl_je_headers -- Journal Header
3.gl_je_lines -- Jounral Lines
4.gl_je_sources -- Journal Sources
5.gl_je_categories -- Journal Categories
6.gl_code_combinations -- Accounting Info
7.gl_balances -- Journal Balances
8.gl_sets_of_books -- Set of books info
Accounts Payables (AP)

1. ap_invoices_all --- Invoice Header info
2. ap_invoice_distributions_all -- Invoice Line info
3. ap_invoice_payments_All -- Invoice Payment Info
4. ap_payment_schedules_all
5. ap_checks_all -- Check Info
6. ap_banks
7. ap_bank_branches -- bank branches
8. ap_ae_headers_all -- accounting header info
9. ap_ae_lines_all -- accounting lines info
10.ap_Accounting_events_all -- accounting event info
11. po_vendors -- Supplier Header
12. po_vendor_sites_all -- supplier site level info
13. po_vendor_contacts -- Supplier Contacts Info
14. hr_locations -- Supplier Physicaal info

Accounts Receivables (AR)

1. ra_customer_trx_all -- transaction header info
2. ra_customer_trx_lines_all -- transaction lines
3. ra_cust_trx_line_gl_dist_all -- transaction acct info
4. ar_cash_receipts_all -- receipt info
5. ar_receivable_applications_all
6. hz_cust_accounts -- Customer Info
7. hz_parties -- Party Info
8. hz_cust_site_uses_all -- Customer site info
9. hz_cust_acct_sites_all -- Customer acct
10.hz_party_sites -- customer site level info
11.hz_locations -- Customer Phsyical Location
12.ra_cust_trx_types_all -- Transaction Types

General Ledger (GL)

1.gl_je_batches -- Journal Batches
2.gl_je_headers -- Journal Header
3.gl_je_lines -- Jounral Lines
4.gl_je_sources -- Journal Sources
5.gl_je_categories -- Journal Categories
6.gl_code_combinations -- Accounting Info
7.gl_balances -- Journal Balances
8.gl_sets_of_books -- Set of books info
9.gl_charts_of_accounts -- Chart of accounts info



Inventory (Inv)

1.mtl_system_items_b -- item info
2.mtl_onhand_quantities -- Item onhand qty
3.mtl_reservations -- Item Reservations
4.mtl_material_transactions -- Inventory Transaction
5.mtl_txn_request_headers -- Move Order Header Info
6.mtl_txn_request_lines -- Move order line info
7.mtl_item_locations -- Item Physical Locations
8.org_organization_definitions -- Organization info
9.mtl_categories_b -- Item Categories info
10.mtl_transaction_accounts -- Item Tranaction acct
11.mtl_txn_source_types -- Transaction Sources
12.mtl_secondary+inventories -- Subinventory info