Run this script giving inventory org as the parameter

SELECT mp.organization_id,

       MP.ORGANIZATION_CODE,

       hl.address_line_1,

       hl.address_line_2,

       hl.address_line_3,

       hl.town_or_city,

       hl.country,

       hl.postal_code,

       HAOU.NAME,

       HAOUBG.NAME BUSINESS_GROUP,

       GSOB.SET_OF_BOOKS_ID,

       GSOB.NAME SOB_NAME, /*gsob.short_name,*/

       GSOB.CURRENCY_CODE,

       GSOB.PERIOD_SET_NAME,

       (SELECT SEGMENT1 || '.' || SEGMENT2 || '.' || SEGMENT3 || '.' ||

               SEGMENT4 || '.' || SEGMENT5 || '.' || SEGMENT6 || '.' ||

               SEGMENT7 || '.' || SEGMENT8 || '.' || SEGMENT9

          FROM APPS.GL_CODE_COMBINATIONS

         WHERE CODE_COMBINATION_ID = GSOB.CHART_OF_ACCOUNTS_ID) CHART_OF_ACCOUNT,

       HLE.NAME LE_NAME,

       HLE.VAT_REGISTRATION_NUMBER,

       HOU.NAME OU_NAME

  FROM APPS.HR_ALL_ORGANIZATION_UNITS   HAOU,

       APPS.HR_ORGANIZATION_INFORMATION HRI,

       APPS.MTL_PARAMETERS              MP,

       APPS.GL_SETS_OF_BOOKS            GSOB,

       APPS.HR_LEGAL_ENTITIES           HLE,

       APPS.HR_OPERATING_UNITS          HOU,

       APPS.HR_ALL_ORGANIZATION_UNITS   HAOUBG,

       APPS.HR_ORGANIZATION_INFORMATION HRIBG,

       apps.hr_locations                hl

 WHERE HRI.ORGANIZATION_ID = HAOU.ORGANIZATION_ID

   AND HAOU.ORGANIZATION_ID = MP.ORGANIZATION_ID

   AND MP.ORGANIZATION_CODE IN ('V1')

   AND HRI.ORG_INFORMATION_CONTEXT = 'Accounting Information'

   AND GSOB.SET_OF_BOOKS_ID = HRI.ORG_INFORMATION1

   AND HLE.ORGANIZATION_ID = HRI.ORG_INFORMATION2

   AND HOU.ORGANIZATION_ID = HRI.ORG_INFORMATION3

   AND HAOUBG.ORGANIZATION_ID = HLE.BUSINESS_GROUP_ID

   AND HRIBG.ORG_INFORMATION_CONTEXT = 'Business Group Information'

   AND HRIBG.ORGANIZATION_ID = HAOUBG.ORGANIZATION_ID

   and haou.location_id = hl.location_id

;

Read More

Purchasing

Q. What are the approval hierarchy

Q. What approval hierarchy you use in your implementation?

Q. How to check what is the approval hierarchy used in your system?

Ans: If Use Approval Hierarchy option is enabled in the Financial Options form, it will use the position based hierarchy. If it is disabled then it will use the supervisor based hierarchy.

Q. How to send the PO to a person before even approval who has that approval limit not through workflow hierarchy

Q. Where to do the setup for specific approval limit for a person?

Q: What is Charge Account?

A: Charge account in PO distribution is used as a debit account during the PO delivery process(the account to charge for the cost of the item).

If PO is for an inventory item, then mostly the charge account will be defaulted from the subinventory or organization material account.

If it is for an expense item, then the account will be defaulted from the subinventory or organization item expense account

Q: How Charge Acount default?

A: PO Charge account, in fact all purchasing accounts will be derived from the Account generator workflow items

Ref doc: http://docs.oracle.com/cd/A60725_05/html/comnls/us/po/poacgen.htm

Q: Can a PO be created without Item?

A: Yes you can create a purchase order without an item.

in purchase order, you can create different line type as per the types of product or services you want to buy.

Either this can be an inventory item or this can be a consulting service or labor

Ref doc: http://docs.oracle.com/cd/A60725_05/html/comnls/us/po/linety01.htm

Q: Differences between Internal Sales Orders and Inter-Organization transfer
A:  Explore more here

• IR-ISO has approval process whereas there is no approval process for Inter-Org transfer
• The IR cycle useful for more tracking, control (IR, SO), approvals and generating pick slips whereas Inter-Org transfer is a one step transaction, simple flow, more user friendly and no interfaces involved
• RMA is possible in Internal Sales Order whereas in Inter-Org transfer there is no functionality to Cancel, delete or Return or not receive an In-transit Shipment

Q: When Internal Sales Order and Internal Requisition will be picked up by Inter-Company invoicing process?
A: Internal sales order and Internal requisitions will be picked by Inter-company invoice process on the following conditions:

• In shipping method, transfer type should be Intransit
• Profile Option INV:Inter-company Invoice for Internal Orders value is Yes on site level. This will be used for creating Account Payable in the Intercompany Invoice process.

Explore more here

Q: What validations happen for Create Release program for creating a BPA release for a requisition?
A:

1. Sourcing rule exists or not for the item
2. Whether ASL defined or not
3. BPA and Line details mentioned in ASL or not
4. BPA should be approved
5. Corresponding BPA line should not be cancelled
6. BPA terms effective dates should satisfy the date on release creation
7. BPA agreement for qty or amount should satisfy the release qty
8. Rel qty should satisfy the BPA min release qty

Questions will be Answered soon if not answered already. Meanwhile you can post more questions in the comment also you can answer to above questions in the comment.
Please help here to rectify if any of the answers are not correct.

Read More