DBA Data[Home] [Help]

APPS.PO_EDA_DATATEMPLATE_PKG dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 395: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU

391: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
392: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
393: AG.MULTI_ROW MULTI_ROW
394: FROM EGO_FND_DSC_FLX_CTX_EXT AG,
395: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
396: WHERE POT.TEMPLATE_ID = POTU.TEMPLATE_ID
397: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE
398: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
399: AND potu.attribute_group_id in (select distinct attr_group_id

Line 457: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU

453: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
454: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
455: AG.MULTI_ROW MULTI_ROW
456: FROM EGO_FND_DSC_FLX_CTX_EXT AG,
457: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
458: WHERE POTU.TEMPLATE_ID IN (SELECT DISTINCT UDA_TEMPLATE_ID FROM PO_LINES_MERGE_V WHERE PO_HEADER_ID = DOCUMENTID AND
459: DRAFT_ID=DRAFTID)
460: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
461: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE

Line 531: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU

527: AG.ATTR_GROUP_ID ATTR_GROUP_ID,
528: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME,
529: AG.MULTI_ROW MULTI_ROW
530: FROM EGO_FND_DSC_FLX_CTX_EXT AG,
531: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
532: WHERE POTU.TEMPLATE_ID IN
533: (SELECT DISTINCT UDA_TEMPLATE_ID FROM PO_LINE_LOCATIONS_MERGE_V WHERE PO_HEADER_ID =DOCUMENTID AND DRAFT_ID = DRAFTID)
534: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
535: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE