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

Line 2544: FROM po_uda_ag_template_usages usg

2540: WHERE phb1.draft_id = -1
2541: AND phb1.po_header_id = l_po_header_id
2542: -- exclude Mod specific and doc numbering attribute groups
2543: AND NOT EXISTS (SELECT 'Mod specific or doc numbering attribute groups'
2544: FROM po_uda_ag_template_usages usg
2545: WHERE usg.template_id = phb1.uda_template_id
2546: AND usg.attribute_group_id = phb1.attr_group_id
2547: AND usg.attribute_category IN ('DOCUMENT_NUMBERING', 'MODIFICATIONS')
2548: )

Line 3487: FROM po_uda_ag_template_usages puatu,

3483: )
3484: WHERE plbd.po_line_id = p_po_line_s_no_lck_tbl(i)
3485: AND plbd.draft_id = p_draft_id
3486: AND NOT EXISTS (SELECT 'exclude PRICING attribute category'
3487: FROM po_uda_ag_template_usages puatu,
3488: po_lines_all pol
3489: WHERE puatu.template_id = pol.uda_template_id
3490: AND plbd.po_line_id = pol.po_line_id
3491: AND puatu.attribute_category = 'PRICING'

Line 3703: FROM po_uda_ag_template_usages puatu,

3699: WHERE plbd.po_line_id = p_po_line_s_no_p_lck_tbl(i)
3700: AND plbd.draft_id = -1
3701: AND plbd.pk1_value = p_draft_id
3702: AND EXISTS (SELECT 'include only PRICING attribute category'
3703: FROM po_uda_ag_template_usages puatu,
3704: po_lines_all pol
3705: WHERE puatu.template_id = pol.uda_template_id
3706: AND plbd.po_line_id = pol.po_line_id
3707: AND puatu.attribute_category = 'PRICING'

Line 3871: FROM po_uda_ag_template_usages puatu,

3867: WHERE plbd.po_line_id = p_po_line_s_no_lck_tbl(i)
3868: AND plbd.draft_id = p_draft_id
3869: AND plbd.pk1_value IS NULL
3870: AND EXISTS (SELECT 'include only PRICING attribute category'
3871: FROM po_uda_ag_template_usages puatu,
3872: po_lines_all pol
3873: WHERE puatu.template_id = pol.uda_template_id
3874: AND plbd.po_line_id = pol.po_line_id
3875: AND puatu.attribute_category = 'PRICING'

Line 3944: FROM po_uda_ag_template_usages puatu,

3940: WHERE plbd.po_line_id = p_po_line_s_no_p_lck_tbl(i)
3941: AND plbd.draft_id = p_draft_id
3942: AND plbd.pk1_value IS NULL
3943: AND EXISTS (SELECT 'include only PRICING attribute category'
3944: FROM po_uda_ag_template_usages puatu,
3945: po_lines_all pol
3946: WHERE puatu.template_id = pol.uda_template_id
3947: AND plbd.po_line_id = pol.po_line_id
3948: AND puatu.attribute_category = 'PRICING'