eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_ATTRIBUTE_VALUES_PVT dependencies on PO_LINES_DRAFT_ALL

Line 4411: -- present in the PO_LINES_DRAFT_ALL table for a given draft_id.

4407: --Locks:
4408: -- None.
4409: --Function:
4410: -- Create Translations in the TLP table for each of the modified line
4411: -- present in the PO_LINES_DRAFT_ALL table for a given draft_id.
4412: -- (for a Blanket or Quotation).
4413: -- It creates translations from one of the 2 sources:
4414: -- a) INV Item Master (if item_id is not null)
4415: -- b) Copies the TLP row of the created language to all other langs

Line 4452: -- PO_LINES_DRAFT_ALL table would contain only the lines that are

4448: IF (p_doc_type IN ('BLANKET', 'QUOTATION')) THEN
4449:
4450: -- SQL What: Get the PO_LINE_ID's and TLP_ID's for the PO
4451: -- Fetch only the lines that are modified. Since the
4452: -- PO_LINES_DRAFT_ALL table would contain only the lines that are
4453: -- modified, we join to it to get the list of PO_LINE_ID's.
4454: -- SQL Why : To create the TLP translations for each line
4455: -- SQL Join: draft_id, po_header_id, po_line_id, language
4456: SELECT POLD.po_line_id, TLP.attribute_values_tlp_id

Line 4458: FROM PO_LINES_DRAFT_ALL POLD,

4454: -- SQL Why : To create the TLP translations for each line
4455: -- SQL Join: draft_id, po_header_id, po_line_id, language
4456: SELECT POLD.po_line_id, TLP.attribute_values_tlp_id
4457: BULK COLLECT INTO l_po_line_id_list, l_tlp_id_list
4458: FROM PO_LINES_DRAFT_ALL POLD,
4459: PO_ATTRIBUTE_VALUES_TLP TLP,
4460: PO_HEADERS_ALL POH
4461: WHERE POLD.draft_id = p_draft_id
4462: AND NVL(POLD.change_accepted_flag, 'Y') = 'Y'