Results 1 to 4 of 4

Thread: related to PO

  1. #1
    Junior Member
    Join Date
    Aug 2007
    Answers
    3

    Question related to PO

    how we can find purchase order for particular requisition from backend.

    Last edited by kanti; 02-18-2008 at 04:47 AM.

  2. #2
    Junior Member
    Join Date
    Dec 2007
    Answers
    5

    Re: related to PO

    Try this


    SELECT
    prha.requisition_header_id req_id
    prha.segment1 req_num,
    prha.org_id pr_ou,
    poh.segment1 po_num,
    poh.org_id po_ou
    FROM
    apps.po_requisition_headers_all prha,
    apps.po_requisition_lines_all prla,
    apps.po_req_distributions_all prda,
    apps.po_distributions_all pda,
    apps.po_line_locations_all poll,
    apps.po_lines_all pol,
    apps.po_headers_all poh
    WHERE poh.segment1 = '&po_number'
    AND poh.po_header_id = pol.po_header_id
    AND pol.po_line_id = poll.po_line_id
    AND poll.line_location_id = pda.line_location_id
    AND pda.req_distribution_id = prda.distribution_id
    AND prda.requisition_line_id = prla.requisition_line_id
    AND prla.requisition_header_id = prha.requisition_header_id


  3. #3
    Junior Member
    Join Date
    Aug 2007
    Answers
    3

    Re: related to PO

    hi ashish

    Thank u for reply.

    Chargeaccount where it will store in which table and column.

    As per my knowledge, gl_code_combinations and in segments.

    What is mtl_generic_deposition table. This is account alias.
    What is use of this table.


  4. #4
    Junior Member
    Join Date
    Dec 2007
    Answers
    5

    Re: related to PO

    Hi Kanti,
    Sorry for late reply.....

    MTL_GENERIC_DISPOSITIONS is alias table in whhich disposition_id is PK and by this (SEGMENT1)name we can refer to GL account in transactions.

    Thanks
    Ashish D


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact