DBA Data[Home] [Help]

APPS.PO_POXPRCLM_PKG dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 27: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU

23: ATTR_GROUP_ID,
24: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW
25: MULTI_ROW
26: FROM EGO_FND_DSC_FLX_CTX_EXT AG, po_requisition_headers_all H,
27: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
28: WHERE H.requisition_header_id = p_req_header_id
29: AND H.UDA_TEMPLATE_ID = POT.TEMPLATE_ID
30: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
31: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE

Line 173: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU

169: ATTR_GROUP_ID,
170: AG.DESCRIPTIVE_FLEXFIELD_NAME DESC_FLEXFLD_NAME, AG.MULTI_ROW
171: MULTI_ROW
172: FROM EGO_FND_DSC_FLX_CTX_EXT AG, po_requisition_lines_all L,
173: PO_UDA_AG_TEMPLATES POT, PO_UDA_AG_TEMPLATE_USAGES POTU
174: WHERE L.requisition_line_id = p_req_line_id
175: AND L.UDA_TEMPLATE_ID = POT.TEMPLATE_ID
176: AND POT.TEMPLATE_ID = POTU.TEMPLATE_ID
177: AND AG.DESCRIPTIVE_FLEXFIELD_NAME = POT.ENTITY_CODE