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

Line 507: from PO_UDA_AG_TEMPLATE_USAGES puatu,

503: l_lookup_code NUMBER;
504:
505: CURSOR C IS
506: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
507: from PO_UDA_AG_TEMPLATE_USAGES puatu,
508: po_uda_ag_templates puat
509: WHERE puat.ENTITY_CODE='PO_REQ_HEADER_EXT_ATTRS'
510: AND puat.document_level='HEADER'
511: AND puat.template_id = puatu.template_id

Line 823: from PO_UDA_AG_TEMPLATE_USAGES puatu,

819: l_where_cls VARCHAR2(100):='';
820:
821: CURSOR C IS
822: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
823: from PO_UDA_AG_TEMPLATE_USAGES puatu,
824: po_uda_ag_templates puat
825: WHERE puat.ENTITY_CODE='PO_REQ_HEADER_EXT_ATTRS'
826: AND puat.document_level='HEADER'
827: AND puat.template_id = puatu.template_id

Line 1017: from PO_UDA_AG_TEMPLATE_USAGES puatu,

1013: l_where_cls VARCHAR2(100):='';
1014:
1015: CURSOR C IS
1016: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
1017: from PO_UDA_AG_TEMPLATE_USAGES puatu,
1018: po_uda_ag_templates puat
1019: WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
1020: AND puat.document_level='HEADER'
1021: AND puat.template_id = puatu.template_id

Line 1311: from PO_UDA_AG_TEMPLATE_USAGES puatu,

1307: l_where_cls VARCHAR2(100):='';
1308:
1309: CURSOR C IS
1310: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
1311: from PO_UDA_AG_TEMPLATE_USAGES puatu,
1312: po_uda_ag_templates puat
1313: WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
1314: AND puat.document_level='HEADER'
1315: AND puat.template_id = puatu.template_id

Line 1485: from PO_UDA_AG_TEMPLATE_USAGES puatu,

1481: l_where_cls VARCHAR2(100):='';
1482:
1483: CURSOR C IS
1484: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
1485: from PO_UDA_AG_TEMPLATE_USAGES puatu,
1486: po_uda_ag_templates puat
1487: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
1488: AND puat.document_level='HEADER'
1489: AND puat.template_id = puatu.template_id

Line 1779: from PO_UDA_AG_TEMPLATE_USAGES puatu,

1775: l_where_cls VARCHAR2(100):='';
1776:
1777: CURSOR C IS
1778: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
1779: from PO_UDA_AG_TEMPLATE_USAGES puatu,
1780: po_uda_ag_templates puat
1781: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
1782: AND puat.document_level='HEADER'
1783: AND puat.template_id = puatu.template_id

Line 1942: from PO_UDA_AG_TEMPLATE_USAGES puatu,

1938: l_num NUMBER;
1939:
1940: CURSOR C IS
1941: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
1942: from PO_UDA_AG_TEMPLATE_USAGES puatu,
1943: po_uda_ag_templates puat
1944: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
1945: AND puat.document_level='HEADER'
1946: AND puat.template_id = puatu.template_id

Line 2078: from PO_UDA_AG_TEMPLATE_USAGES puatu,

2074: l_num NUMBER;
2075:
2076: CURSOR C IS
2077: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
2078: from PO_UDA_AG_TEMPLATE_USAGES puatu,
2079: po_uda_ag_templates puat
2080: WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
2081: AND puat.document_level='HEADER'
2082: AND puat.template_id = puatu.template_id

Line 2221: from PO_UDA_AG_TEMPLATE_USAGES puatu,

2217: l_where_cls VARCHAR2(100):='';
2218:
2219: CURSOR C IS
2220: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
2221: from PO_UDA_AG_TEMPLATE_USAGES puatu,
2222: po_uda_ag_templates puat
2223: WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
2224: AND puat.document_level='HEADER'
2225: AND puat.template_id = puatu.template_id

Line 2765: from PO_UDA_AG_TEMPLATE_USAGES puatu,

2761: l_cur_attr_group_id NUMBER ;
2762:
2763: /*CURSOR C IS
2764: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
2765: from PO_UDA_AG_TEMPLATE_USAGES puatu,
2766: po_uda_ag_templates puat
2767: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
2768: AND puat.document_level='HEADER'
2769: AND puat.template_id = puatu.template_id

Line 3352: from PO_UDA_AG_TEMPLATE_USAGES puatu,

3348: l_where_cls VARCHAR2(100):='';
3349:
3350: CURSOR C IS
3351: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
3352: from PO_UDA_AG_TEMPLATE_USAGES puatu,
3353: po_uda_ag_templates puat
3354: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
3355: AND puat.document_level='HEADER'
3356: AND puat.template_id = puatu.template_id

Line 3829: from PO_UDA_AG_TEMPLATE_USAGES puatu,

3825: l_where_cls VARCHAR2(100):='';
3826:
3827: CURSOR C IS
3828: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
3829: from PO_UDA_AG_TEMPLATE_USAGES puatu,
3830: po_uda_ag_templates puat
3831: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
3832: AND puat.document_level='HEADER'
3833: AND puat.template_id = puatu.template_id

Line 4100: from PO_UDA_AG_TEMPLATE_USAGES puatu,

4096: l_where_cls VARCHAR2(100):='';
4097:
4098: CURSOR C IS
4099: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
4100: from PO_UDA_AG_TEMPLATE_USAGES puatu,
4101: po_uda_ag_templates puat
4102: WHERE puat.ENTITY_CODE='PON_AUC_HDRS_EXT_ATTRS'
4103: AND puat.document_level='HEADER'
4104: AND puat.template_id = puatu.template_id

Line 4295: from PO_UDA_AG_TEMPLATE_USAGES puatu,

4291: l_lookup_const VARCHAR2(50);
4292:
4293: CURSOR C IS
4294: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
4295: from PO_UDA_AG_TEMPLATE_USAGES puatu,
4296: po_uda_ag_templates puat
4297: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
4298: AND puat.document_level='HEADER'
4299: AND puat.template_id = puatu.template_id

Line 4637: from PO_UDA_AG_TEMPLATE_USAGES puatu,

4633: l_lookup_const VARCHAR2(50);
4634:
4635: CURSOR C IS
4636: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
4637: from PO_UDA_AG_TEMPLATE_USAGES puatu,
4638: po_uda_ag_templates puat
4639: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
4640: AND puat.document_level='HEADER'
4641: AND puat.template_id = puatu.template_id

Line 4875: from PO_UDA_AG_TEMPLATE_USAGES puatu,

4871: l_isUCAEnabled VARCHAR2(1);
4872:
4873: CURSOR C IS
4874: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
4875: from PO_UDA_AG_TEMPLATE_USAGES puatu,
4876: po_uda_ag_templates puat
4877: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
4878: AND puat.document_level='HEADER'
4879: AND puat.template_id = puatu.template_id

Line 5027: FROM PO_UDA_AG_TEMPLATE_USAGES puatu,

5023: BEGIN
5024:
5025: SELECT puatu.ATTRIBUTE_GROUP_ID, ags.ATTR_GROUP_NAME
5026: INTO l_attr_group_id, l_attr_group_name
5027: FROM PO_UDA_AG_TEMPLATE_USAGES puatu,
5028: po_uda_ag_templates puat,
5029: ego_attr_groups_v ags,
5030: po_headers_all_ext_b phaeb
5031: WHERE puat.ENTITY_CODE=p_ag_type

Line 5286: FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags

5282: BEGIN
5283:
5284: SELECT usages.ATTRIBUTE_GROUP_ID , ags.ATTR_GROUP_NAME
5285: INTO l_attrb_grp_id, l_attr_group_name
5286: FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags
5287: WHERE usages.template_id = l_template_id
5288: AND usages.ATTRIBUTE1=l_context_usage
5289: AND usages.ATTRIBUTE2=l_source_org_owned
5290: -- bug 13054072 Attribute3 needs to be added here as there may be records that have org_id as well as DEFAULT values in Attribute3 column

Line 5302: FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags

5298: --If there is no org_id fetched from po_headers_all
5299:
5300: SELECT usages.ATTRIBUTE_GROUP_ID , ags.ATTR_GROUP_NAME
5301: INTO l_attrb_grp_id, l_attr_group_name
5302: FROM PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags
5303: WHERE usages.template_id = l_template_id
5304: AND usages.ATTRIBUTE1=l_context_usage
5305: AND usages.ATTRIBUTE2=l_source_org_owned
5306: AND usages.ATTRIBUTE3='DEFAULT'

Line 5477: from PO_UDA_AG_TEMPLATE_USAGES puatu,

5473: l_identifier VARCHAR2(3) := 'PAR';
5474:
5475: CURSOR c_attr_grp_id IS
5476: SELECT DISTINCT puatu.ATTRIBUTE_GROUP_ID
5477: from PO_UDA_AG_TEMPLATE_USAGES puatu,
5478: po_uda_ag_templates puat
5479: WHERE puat.ENTITY_CODE='PO_HEADER_EXT_ATTRS'
5480: AND puat.document_level='HEADER'
5481: AND puat.template_id = puatu.template_id