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_DRAFTS_PVT dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 5899: po_uda_ag_template_usages uda_usg,

5895: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
5896: AND pogt.index_char2 = G_LOCK_HEADER_ENTITY
5897: AND EXISTS (SELECT draft.attr_group_id
5898: FROM po_headers_all_ext_b draft,
5899: po_uda_ag_template_usages uda_usg,
5900: ego_fnd_dsc_flx_ctx_ext ag
5901: WHERE draft.po_header_id = l_po_header_id
5902: AND draft.draft_id = p_draft_id
5903: AND draft.uda_template_id = uda_usg.template_id

Line 5911: po_uda_ag_template_usages uda_usg,

5907: AND ag.multi_row = 'N'
5908: MINUS
5909: SELECT base.attr_group_id
5910: FROM po_headers_all_ext_b base,
5911: po_uda_ag_template_usages uda_usg,
5912: ego_fnd_dsc_flx_ctx_ext ag
5913: WHERE base.po_header_id = l_po_header_id
5914: AND base.draft_id = -1
5915: AND base.uda_template_id = uda_usg.template_id

Line 6897: FROM po_uda_ag_template_usages puatu,

6893: AND plb.draft_id = G_DRAFT_ID_MINUS_1
6894: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
6895: and pogt.index_char2 = g_lock_line_entity
6896: AND NOT EXISTS (SELECT 'exclude PRICING attribute category'
6897: FROM po_uda_ag_template_usages puatu,
6898: po_lines_all pla
6899: WHERE puatu.template_id = pla.uda_template_id
6900: AND puatu.attribute_category = 'PRICING'
6901: AND pla.po_line_id = plb.po_line_id

Line 7007: FROM po_uda_ag_template_usages puatu,

7003: AND plbd.po_line_id = pogt.char1 -- po_line_id
7004: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
7005: AND pogt.index_char2 = G_LOCK_LINE_ENTITY
7006: AND NOT EXISTS (SELECT 'exclude PRICING attribute category'
7007: FROM po_uda_ag_template_usages puatu,
7008: po_lines_all pla
7009: where puatu.template_id = pla.uda_template_id
7010: AND puatu.attribute_category = 'PRICING'
7011: AND pla.po_line_id = plbd.po_line_id

Line 7052: po_uda_ag_template_usages uda_usg

7048: AND pogt.index_char1 = G_CHANGED_ENTTIES_ID
7049: AND pogt.index_char2 = G_LOCK_LINE_ENTITY
7050: AND EXISTS (SELECT draft.attr_group_id
7051: FROM po_lines_all_ext_b draft,
7052: po_uda_ag_template_usages uda_usg
7053: WHERE draft.po_line_id = plbd.po_line_id
7054: AND draft.draft_id = p_draft_id
7055: AND draft.uda_template_id = uda_usg.template_id
7056: AND draft.attr_group_id = uda_usg.attribute_group_id

Line 7061: po_uda_ag_template_usages uda_usg

7057: AND uda_usg.attribute_category <> 'PRICING'
7058: MINUS
7059: SELECT base.attr_group_id
7060: FROM po_lines_all_ext_b base,
7061: po_uda_ag_template_usages uda_usg
7062: WHERE base.po_line_id = plbd.po_line_id
7063: AND base.draft_id = -1
7064: AND base.uda_template_id = uda_usg.template_id
7065: AND base.attr_group_id = uda_usg.attribute_group_id

Line 7231: FROM po_uda_ag_template_usages agtu,

7227: FROM po_lines_all_ext_b polext_base,
7228: po_lines_all_ext_b polext_draft,
7229: po_session_gt pogt
7230: WHERE EXISTS (SELECT 'Is Complex Pricig Attribute'
7231: FROM po_uda_ag_template_usages agtu,
7232: po_lines_all pol
7233: WHERE polext_base.po_line_id = pol.po_line_id
7234: AND pol.uda_template_id = agtu.template_id
7235: AND polext_base.attr_group_id = agtu.attribute_group_id

Line 7285: FROM po_uda_ag_template_usages agtu,

7281: FROM po_lines_all_ext_b polext_base,
7282: po_lines_all_ext_b polext_draft,
7283: po_session_gt pogt
7284: WHERE EXISTS (SELECT 'Is Complex Pricig Attribute'
7285: FROM po_uda_ag_template_usages agtu,
7286: po_lines_all pol
7287: WHERE polext_base.po_line_id = pol.po_line_id
7288: AND pol.uda_template_id = agtu.template_id
7289: AND polext_base.attr_group_id = agtu.attribute_group_id

Line 7306: po_uda_ag_template_usages agtu,

7302: OR NVL(polext_base.n_ext_attr2, G_NULL_NUM) <> NVL(polext_draft.n_ext_attr2, G_NULL_NUM)
7303: AND EXISTS (SELECT 'n_ext_attr2 used as UNIT_PRICE'
7304: FROM ego_attrs_v attrs,
7305: ego_obj_attr_grp_assocs_v att_assoc,
7306: po_uda_ag_template_usages agtu,
7307: po_lines_all pol
7308: WHERE attrs.attr_group_type = att_assoc.attr_group_type
7309: AND attrs.attr_group_name = att_assoc.attr_group_name
7310: --AND attrs.attr_group_type = 'PO_LINE_EXT_ATTRS'

Line 8905: FROM po_lines_merge_v plm , po_uda_ag_template_usages ptu

8901: WHERE po_header_id = p_po_header_id
8902: AND draft_id = p_draft_id
8903: )
8904: AND EXISTS ( SELECT 1
8905: FROM po_lines_merge_v plm , po_uda_ag_template_usages ptu
8906: WHERE plm.po_line_id = Abs(ple.po_line_id)
8907: AND plm.draft_id = Decode(p_draft_id,
8908: -1,-1,
8909: Abs(ple.draft_id))

Line 8934: FROM po_lines_merge_v plm , po_uda_ag_template_usages ptu

8930: AND draft_id = p_draft_id
8931: )
8932:
8933: AND EXISTS ( SELECT 1
8934: FROM po_lines_merge_v plm , po_uda_ag_template_usages ptu
8935: WHERE plm.po_line_id = Abs(ple.po_line_id)
8936: AND plm.draft_id = Decode(p_draft_id,
8937: -1,-1,
8938: Abs(ple.draft_id))

Line 8959: FROM po_headers_merge_v phm , po_uda_ag_template_usages ptu

8955: where phe.po_header_id = p_po_header_id
8956: AND Nvl(phe.draft_id,-1) = p_draft_id
8957:
8958: AND EXISTS ( SELECT 1
8959: FROM po_headers_merge_v phm , po_uda_ag_template_usages ptu
8960: WHERE phm.po_header_id = phe.po_header_id
8961: AND phm.draft_id = Nvl(phe.draft_id,-1)
8962: AND ptu.attribute_category = 'FORMS'
8963: AND ptu.template_id = phm.uda_template_id

Line 8979: FROM po_headers_merge_v phm , po_uda_ag_template_usages ptu

8975: where phe.po_header_id = p_po_header_id
8976: AND Nvl(phe.draft_id,-1) = p_draft_id
8977:
8978: AND EXISTS ( SELECT 1
8979: FROM po_headers_merge_v phm , po_uda_ag_template_usages ptu
8980: WHERE phm.po_header_id = phe.po_header_id
8981: AND phm.draft_id = Nvl(phe.draft_id,-1)
8982: AND ptu.attribute_category = 'FORMS'
8983: AND ptu.template_id = phm.uda_template_id