any code quaries put a mail

apps.rocks33@gmail.com

aol important tables in oracle apps

-- FLEX FIELDS (DFF)

Select * from   FND_DESCR_FLEX_CONTEXTS

Select * from   FND_DESCR_FLEX_COL_USAGE_TL

-- FLEX FIELDS (KFF)

Select * from   FND_ID_FLEX_STRUCTURES

Select * from   FND_ID_FLEX_SEGMENTS

--VALUE SETS

Select * from   FND_FLEX_VALUES

--REGISTRATION  & EXECUTABLES

Select * from   FND_EXECUTABLES

--CONCURRENT PROGRAM

Select * from   FND_CONCURRENT_PROGRAMS

--RESPONSIBILITY

Select * from   FND_RESPONSIBILITY_TL

--USERS

Select * from   FND_USER

--REQUESTS

Select * from   FND_CONCURRENT_REQUESTS

--REQUEST SETS

Select * from   FND_REQUEST_SETS

--MULTI ORG TABLES

--BUSINESS GROUPS

Select * from   PER_BUSINESS_GROUPS

--SET OF BOOKS

Select * from   GL_SETS_OF_BOOKS

--LEGAL ENTITIES

Select * from   HR_LEGAL_ENTITIES

--INVENTORY

Select * from   ORG_ORGANIZATION_DEFINITIONS

--OPERATING UNIT

Select * from   HR_OPERATING_UNITS

general ledger(gl)important tables in oracle apps

GENERAL LEDGER TABLES

--CURRENCY

Select * from   FND_CURRENCIES

---PERIOD TYPES

Select * from   GL_PERIOD_TYPES

--CALENDER

Select * from   GL_PERIOD_SETS

Select * from   GL_PERIODS

--CHART OF ACCOUNTS

Select * from   FND_ID_FLEX_STRUCTURES

Select * from   FND_ID_FLEX_SEGMENTS

--LEDGERS

Select * from   GL_LEDGERS

--JOURNAL SOURCES

Select * from   GL_JE_SOURCES

--JOURNAL CATEGIRIES

Select * from   GL_JE_CATEGORIES

--JOURNALS

Select * from   GL_JE_HEADERS

Select * from   GL_JE_LINES

work in process(wip)important tables in oracle apps

WORK IN PROCESS TABLES

--ACCOUNT CLASSES

Select * from   WIP_ACCOUNTING_CLASSES

--WIP PARAMETERS

Select * from   WIP_PARAMETERS

--JOBS

Select * from   WIP_ENTITIES

Select * from   WIP_DISCRETE_JOBS

--MOVE TRANSACTIONS

Select * from   WIP_MOVE_TRANSACTIONS

--JOB OPERATIONS

Select * from   WIP_OPERATIONS

--JOB DEPARTMENT DETAILS

Select * from   WIP_REQUIREMENT_OPERATIONS

--JOB RESOURCES

Select * from   WIP_OPERATION_RESOURCES

bill of materials(bom)important tables in oracle apps

BILL OF MATERIALS TABLES

--ITEM COST

Select * from   CST_ITEM_COST_DETAILS

--RESOURCES

Select * from   BOM_RESOURCES

--RESOURCE COST

Select * from   CST_RESOURCE_COSTS

--DEPARTMENTS

Select * from   BOM_DEPARTMENTS

--DEPARTMENT RESOURCES

Select * from   BOM_DEPARTMENT_RESOURCES

--ROUTINGS

Select * from   BOM_OPERATIONAL_ROUTINGS

Select * from   BOM_OPERATION_SEQUENCES

Select * from   BOM_OPERATION_RESOURCES

--BILLS

Select * from   BOM_BILL_OF_MATERIALS

Select * from   BOM_INVENTORY_COMPONENTS

account receivable(ar)important tables in oracle apps

--ACCOUNT RECIEVABLES TABLES

--TRANSACTIONS(INVOICES)

Select * from   RA_CUSTOMER_TRX_ALL

Select * from   RA_CUSTOMER_TRX_LINES_ALL

Select * from   RA_CUST_TRX_LINE_GL_DIST_ALL

Select * from   RA_CUST_TRX_LINE_SALESREPS_ALL

--CASH RECIEPTS

Select * from   AR_CASH_RECEIPTS_ALL

--INVOICE TYPES

Select * from   RA_CUST_TRX_TYPES_ALL

--SOURCE

Select * from   RA_BATCH_SOURCES_ALL

--SALES REPS

Select * from   RA_SALESREPS_ALL

--PAYMENT TERMS

Select * from   RA_TERMS_TL

Select * from   RA_TERMS_LINES

--RECEIPT PAYMENT METHOD

Select * from   AR_RECEIPT_METHODS

order management(om)important tables in oracle apps

--ORDER MANAGEMENT IMPORTANT TABLES

--ENTERNED

Select * from   OE_ORDER_HEADERS_ALL

Select * from   OE_ORDER_LINES_ALL

--BOOKED

Select * from   OE_ORDER_HEADERS_ALL

Select * from   OE_ORDER_LINES_ALL

Select * from   WSH_DELIVERY_DETAILS

--AUTO CREATE DELIVERIES

Select * from   WSH_NEW_DELIVERIES

--PICKED

Select * from   WSH_DELIVERY_DETAILS

Select * from   WSH_DELIVERY_ASSIGNMENTS

Select * from   WSH_PICKING_BATCHES

Select * from   MTL_MATERIAL_TRANSACTIONS

Select * from   MTL_RESERVATIONS

Select * from   MTL_TXN_REQUEST_HEADERS

Select * from   MTL_TXN_REQUEST_LINES

--SHIPPED

Select * from   OE_ORDER_LINES_ALL

Select * from   WSH_DELIVERY_DETAILS

Select * from   MTL_MATERIAL_TRANSACTIONS

--CLOSED    --YOU NEED TO RUN WORKFLOW BACKGROUND PROCESS

--ITEM_TYPE:-OM ORDER_LINE-----TO CLOSE THE LINE

--ITEM_TYPE:--OM ORDER_HEADER------TO CLOSE THE HEADER

Select * from   OE_ORDER_HEADERS_ALL  --FLOW_STATUS_CODE-:CLOSED

Select * from   OE_ORDER_LINES_ALL    --FLOW_STATUS_CODE-:CLOSED

Select * from   WSH_DELIVERY_DETAILS    --STATUS:-C

--AR INTERFACE_TABLES        ----->WORKFLOW BACKGROUND PROCESS
--WILL TRANSAFER THE RECORDS FROM OM TO AR INTERFACE TABLES
--SOURCE=ORDER_ENTRY

Select * from   RA_INTERFACE_LINES_ALL

Select * from   RA_INTERFACE_DISTRIBUTIONS_ALL

--AR BASE TABLES   --AUTO INVOICE IMPORT PROGRAM WILL 
--BE RUN THEN RECORDS SHOULD BE PRESENT IN AR BASE TABLES

Select * from   RA_CUSTOMER_TRX_ALL

Select * from   RA_CUSTOMER_TRX_LINES_ALL

Select * from   RA_CUST_TRX_LINE_GL_DIST_ALL

--CUSTOMERS

Select * from   HZ_PARTIES

Select * from   HZ_CUST_ACCOUNTS

--CUSTOMER SITES

Select * from   HZ_PARTY_SITES

Select * from   HZ_LOCATIONS

--SITE PURPOSES

Select * from   HZ_CUST_ACCT_SITES_ALL

Select * from   HZ_CUST_SITE_USES_ALL

--ORDER TYPES

Select * from   OE_TRANSACTION_TYPES_TL

--SALES REPS

Select * from   RA_SALESREPS_ALL

--CHARGES

Select * from   OE_CHARGE_LINES_V

--PRICE LIST

Select * from   QP_LIST_HEADERS

Select * from   QP_LIST_LINES

Select * from   QP_PRICING_ATTRIBUTES

--BANKS

Select * from   AP_BANK_ACCOUNTS_ALL

--BANK BRANCHES

Select * from   AP_BANK_ACCOUNT_USES_ALL

--BANK ACCT USES

Select * from AP_BANK_BRANCHES

  

account paybles(ap)module important tables in oracle apps

--ACCOUNT PAYBLES(AP) IMPORTANT TABLES

--INVOICES

Select * from   AP_INVOICES_ALL --IN 11I

Select * from   AP_INVOICE_DISTRIBUTIONS_ALL  --IN 11I

Select * from   AP_INVOICES_ALL

Select * from   AP_INVOICE_LINES_ALL

Select * from   AP_INVOICE_DISTRIBUTIONS_ALL

--ACCOUNTING

Select * from   AP_AE_HEADERS_ALL

Select * from   AP_AE_LINES_ALL

--JOURNALS

Select * from   GL_JE_HEADERS

Select * from   GL_JE_LINES

--PAYMENTS

Select * from   AP_INVOICE_PAYMENTS_ALL

Select * from   AP_CHECKS_ALL

--DISTRIBUTION SETS

Select * from   AP_DISTRIBUTION_SETS_ALL

Select * from   AP_DISTRIBUTION_SET_LINES_ALL

--PAYMENT TERMS

Select * from   AP_TERMS_TL

Select * from   AP_TERMS_LINES

--SCHEDULE PAYMENTS

Select * from   AP_PAYMENT_SCHEDULES_ALL

--HOLD

Select * from   AP_HOLDS_ALL

--SUPPLIERS

Select * from   PO_VENDORS

Select * from   PO_VENDOR_SITES_ALL

Select * from   PO_VENDOR_CONTACTS

--INVOICE TYPES

Select * from   AP_LOOKUP_CODES  --(LOOKUP_TYPE='INVOICE_TYPE')

--INVOICE DIST TYPES

Select * from   AP_LOOKUP_CODES  --(LOOKUP_TYPE='INVOICE_DISTRIBUTION_TYPE')

Select * from   AP_LOOKUP_CODES  --(LOOKUP_TYPE='SOURCE')

purchasing(po) module important tables

--PURCHASING MODULE IMPORTANT TABLES--------

--REQUISITIONS

Select * from PO_REQUISITION_HEADERS_ALL

Select * from PO_REQUISITION_LINES_ALL

Select * from PO_REQ_DISTRIBUTIONS_ALL

--RFQ

Select * from PO_HEADERS_ALL--(TYPE_LOOKUP_CODE='RFQ')

Select * from PO_LINES_ALL

Select * from PO_LINE_LOCATIONS_ALL

--QUATATIONS

Select * from PO_HEADERS_ALL----(TYPE_LOOKUP_CODE='RQUATAION)

Select * from PO_LINES_ALL

Select * from PO_LINE_LOCATIONS_ALL

--PO AGREEMENTS

--1)STANDARD

Select * from PO_HEADERS_ALL

Select * from PO_LINES_ALL

Select * from PO_LINE_LOCATIONS_ALL

Select * from PO_DISTRIBUTIONS_ALL

--2)PLANNED

Select * from PO_HEADERS_ALL

Select * from PO_LINES_ALL

Select * from PO_LINE_LOCATIONS_ALL

Select * from PO_DISTRIBUTIONS_ALL--(PO_RELEASE_ID IS NULL)

--3)BLANKAT

Select * from PO_HEADERS_ALL

Select * from PO_LINES_ALL

--4)CONTRACT

Select * from PO_HEADERS_ALL

--PORELEASES

--1)PLANNED

Select * from PO_LINE_LOCATIONS_ALL

Select * from PO_DISTRIBUTIONS_ALL--(PO_RELEASE_ID IS NOT NULL)

--2)BLANKAT

Select * from PO_LINE_LOCATIONS_ALL

Select * from PO_DISTRIBUTIONS_ALL

--3)CONTRACT

Select * from PO_HEADERS_ALL

Select * from PO_LINES_ALL--(CONTRACT_ID IS NOT NULL)

Select * from PO_LINE_LOCATIONS_ALL

Select * from PO_DISTRIBUTIONS_ALL

Select * from PO_HEADERS_ALL

--RECIEPT

Select * from RCV_SHIPMENT_HEADERS

Select * from RCV_SHIPMENT_LINES

Select * from RCV_TRANSACTIONS

--EMPLOYEE

Select * from PER_ALL_PEOPLE_F

--JOB

Select * from PER_JOBS

--POSITION

Select * from PER_ALL_POSITIONS

--EMPLOYEE'S JOB AND POSITION

Select * from PER_ALL_ASSIGNMENTS_F

--APPROVAL GROUPS

Select * from PO_CONTROL_GROUPS_ALL

Select * from PO_CONTROL_RULES

--APPROVAL MANAGER

Select * from PO_POSITION_CONTROLS_ALL

--POSITION HIERARCHY

Select * from PER_POSITION_STRUCTURES

Select * from PER_POS_STRUCTURE_ELEMENTS

--PO TYPES

Select * from PO_DOCUMENT_TYPES

Select * from PO_VENDORS --(AP_SUPPLIERS IN R12)

Select * from PO_VENDOR_SITES_ALL --(AP_SUPPLIER_SITES_ALL IN R12)

Select * from PO_VENDOR_CONTACTS --(AP_SUPPLIER_CONTACTS) IN R12

--SHIP TO,BILL TO

Select * from HR_LOCATIONS

--PO LINE TYPES

Select * from PO_LINE_TYPES_TL

--AGENTS

Select * from PO_AGENTS_V

--UOM

Select * from MTL_UNITS_OF_MEASURE_TL

Select * from GL_CODE_COMBINATIONS

drop shipment cycle query

SELECT
     H.ORDER_NUMBER,
     PARTY.PARTY_NAME CUSTOMER_NAME,
     CUST_ACCT.ACCOUNT_NUMBER CUSTOMER_NUMBER,
     TRUNC(H.ORDERED_DATE) ORDERED_DATE,
     PL.NAME PRICELIST_NAME,
     RSA.NAME SALESREP_NAME,
     H.TRANSACTIONAL_CURR_CODE CURRENCY_CODE,
     H.FLOW_STATUS_CODE,
     SHIP_SU.LOCATION SHIP_TO_LOCATION,
     SHIP_LOC.ADDRESS1 SHIP_TO_ADDR1,
     DECODE (ship_loc.city, NULL, NULL,ship_loc.city || ', ')||
     DECODE (ship_loc.state,NULL, ship_loc.province || ', ', ship_loc.state || ', ')||
     DECODE (ship_loc.postal_code,  NULL, NULL, ship_loc.postal_code || ', ')||
     DECODE (ship_loc.country, NULL, NULL, ship_loc.country)
                                                             ship_to_add5,
     BILL_SU.LOCATION BILL_TO_LOCATION,
     BILL_LOC.ADDRESS1 BILL_TO_ADDR1,
     DECODE (bill_loc.city,  NULL, NULL,bill_loc.city || ', ')||
     DECODE (bill_loc.state,NULL, bill_loc.province || ', ',bill_loc.state || ', ')||
     DECODE (bill_loc.postal_code,NULL, NULL,bill_loc.postal_code || ', ')||
     DECODE (bill_loc.country, NULL, NULL, bill_loc.country)
                                                          BILL_to_addr5,
    ----------------------------------------------------------------------
     L.ORDERED_ITEM,
     TRUNC(L.SCHEDULE_ARRIVAL_DATE)SHIPPED_DATE,
     L.UNIT_SELLING_PRICE,
     L.UNIT_LIST_PRICE,
     WHA.ORGANIZATION_CODE WHAREHOUSE,
      ----------REQUITION DETAILS----------
     PRHA.SEGMENT1 REQ_NUMBER ,
     TRUNC(PRHA.CREATION_DATE)REQ_CREATION_DATE,
     PRHA.TYPE_LOOKUP_CODE REQ_TYPE,
      ----------PODEATILS---------------
     PHA.SEGMENT1 PO_NUMBER,
     PHA.CREATION_DATE PO_CREATION_DATE,
     AS1.VENDOR_NAME SUPPLIER_NAME,
     ASA.VENDOR_SITE_CODE,
     PLA.UNIT_PRICE ITEM_PURCHASED_PRICE,
     PLA.QUANTITY PURCHASES_QUANTITY,
     PAV.AGENT_NAME ITEM_PURCHASED_BY, 
      -------RECPT------------------- 
     RSH.RECEIPT_NUM  ,
     RSH.CREATION_DATE RECIEPT_DATE,
     RSL.TO_SUBINVENTORY RECIEVED_LOC                           
 FROM
    OE_ORDER_HEADERS_ALL H,
    HZ_PARTIES PARTY,
    HZ_CUST_ACCOUNTS CUST_ACCT,
    QP_LIST_HEADERS_TL PL,
    RA_SALESREPS_ALL RSA,
    HZ_LOCATIONS SHIP_LOC,
    HZ_CUST_SITE_USES_ALL SHIP_SU,
    HZ_PARTY_SITES SHIP_PS,
    HZ_CUST_ACCT_SITES_ALL SHIP_CAS,
    ---------------------------
    HZ_LOCATIONS BILL_LOC,
    HZ_CUST_SITE_USES_ALL BILL_SU,
    HZ_PARTY_SITES BILL_PS,
    HZ_CUST_ACCT_SITES_ALL BILL_CAS,
     ---------------------------
    OE_ORDER_LINES_ALL L,
    MTL_PARAMETERS WHA,
     ---REQ---------
    PO_REQUISITION_HEADERS_ALL PRHA,
    OE_DROP_SHIP_SOURCES ODSO,
     -------PO----
    PO_HEADERS_ALL PHA,
    PO_REQUISITION_LINES_ALL PRL,
    PO_REQ_DISTRIBUTIONS_ALL PRD,
    PO_DISTRIBUTIONS_ALL PD,
    AP_SUPPLIERS AS1,
    AP_SUPPLIER_SITES_ALL ASA,
    PO_LINES_ALL PLA,
    PO_AGENTS_V PAV,
    ---RECPTS-----------
    RCV_SHIPMENT_HEADERS RSH,
    RCV_SHIPMENT_LINES RSL
 WHERE
 H.ORDER_NUMBER='66436'
    AND H.SOLD_TO_ORG_ID=CUST_ACCT.CUST_ACCOUNT_ID
    AND CUST_ACCT.PARTY_ID=PARTY.PARTY_ID
    -------------------------------------------
    AND H.PRICE_LIST_ID = PL.LIST_HEADER_ID(+)
    AND PL.LANGUAGE(+) = USERENV ('LANG')
    ----------------------------------------
    AND H.SALESREP_ID=RSA.SALESREP_ID
    ---------------------------------
    AND H.SHIP_TO_ORG_ID = SHIP_SU.SITE_USE_ID
    AND SHIP_SU.CUST_ACCT_SITE_ID = SHIP_CAS.CUST_ACCT_SITE_ID
    AND SHIP_CAS.PARTY_SITE_ID = SHIP_PS.PARTY_SITE_ID
    AND SHIP_LOC.LOCATION_ID = SHIP_PS.LOCATION_ID
    ---------------------------------------------
    AND H.INVOICE_TO_ORG_ID = BILL_SU.SITE_USE_ID(+)
    AND BILL_SU.CUST_ACCT_SITE_ID = BILL_CAS.CUST_ACCT_SITE_ID(+)
    AND BILL_CAS.PARTY_SITE_ID = BILL_PS.PARTY_SITE_ID(+)
    AND BILL_LOC.LOCATION_ID(+) = BILL_PS.LOCATION_ID
    -------------------------------
    AND L.HEADER_ID=H.HEADER_ID
    ---------------------------------------
    AND L.ORG_ID=WHA.ORGANIZATION_ID
    ---------------------------------
    AND H.HEADER_ID=ODSO.HEADER_ID
    AND PRHA.REQUISITION_HEADER_ID=ODSO.REQUISITION_HEADER_ID
    AND ODSO.DESTINATION_ORGANIZATION_ID=PRHA.ORG_ID
    --------------------------------------------------
    --AND PRHA.PREPARER_ID=PHA.AGENT_ID
    AND PHA.TYPE_LOOKUP_CODE='STANDARD'
    AND PRHA.ORG_ID=PHA.ORG_ID
    AND PRHA.REQUISITION_HEADER_ID = PRL.REQUISITION_HEADER_ID
    AND PRL.REQUISITION_LINE_ID = PRD.REQUISITION_LINE_ID
    AND PRD.DISTRIBUTION_ID = PD.REQ_DISTRIBUTION_ID(+)
    AND PD.PO_HEADER_ID = PHA.PO_HEADER_ID(+)
    ---------------------------------------------------
    AND PHA.VENDOR_ID=AS1.VENDOR_ID
    ---------------------
    AND PHA.VENDOR_SITE_ID=ASA.VENDOR_SITE_ID
    ----------------------------------------
    AND PHA.PO_HEADER_ID=PLA.PO_HEADER_ID
    ------------------------------------
    AND PHA.AGENT_ID=PAV.AGENT_ID
    ---------------------------------
    AND PHA.PO_HEADER_ID=RSL.PO_HEADER_ID
    AND RSL.SHIPMENT_HEADER_ID=RSH.SHIPMENT_HEADER_ID