-
Junior Member
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.
-
Junior Member
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
-
Junior Member
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.
-
Junior Member
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
-
Forum Rules