related to PO

[kanti]

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

[AshishD]

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

[kanti]

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.

[AshishD]

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