APPS.PO_EDA_DATATEMPLATE_PKG dependencies on PO_LINE_LOCATIONS_MERGE_V

Line 533: (SELECT DISTINCT UDA_TEMPLATE_ID FROM PO_LINE_LOCATIONS_MERGE_V WHERE PO_HEADER_ID =DOCUMENTID AND DRAFT_ID = DRAFTID)

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
536: AND AG.ATTR_GROUP_ID = POTU.ATTRIBUTE_GROUP_ID
537: AND potu.attribute_group_id in (select distinct attr_group_id

Line 562: FROM po_lines_merge_v pol , po_line_locations_merge_v poll

558:
559:
560: CURSOR C_LINE_LOC IS
561: SELECT poll.LINE_LOCATION_ID
562: FROM po_lines_merge_v pol , po_line_locations_merge_v poll
563: WHERE pol.po_header_id = DOCUMENTID
564: AND poll.po_header_id = DOCUMENTID
565: AND pol.DRAFT_ID = DRAFTID
566: AND poll.DRAFT_ID = pol.DRAFT_ID

Line 983: FROM po_headers_merge_v poh, po_lines_merge_v pol , po_line_locations_merge_v ploc

979: SELECT CASE WHEN poh.start_date IS NULL AND poh.end_date IS NULL AND Min(CLM_PERIOD_PERF_START_DATE) IS NULL AND
980: Max(CLM_PERIOD_PERF_END_DATE) IS NULL THEN 'Delivery Requested By' ELSE NULL END DeliveryDescription,
981: to_char(CASE WHEN poh.start_date IS NULL AND poh.end_date IS NULL AND Min(CLM_PERIOD_PERF_START_DATE) IS NULL AND
982: Max(CLM_PERIOD_PERF_END_DATE) IS NULL THEN ploc.NEED_BY_DATE ELSE NULL END,'CCYY-MM-DD') DateElement
983: FROM po_headers_merge_v poh, po_lines_merge_v pol , po_line_locations_merge_v ploc
984: WHERE
985: ( ( (isMod = 'N') AND (poh.po_header_id = DOCUMENTID AND poh.draft_id = -1 AND poh.change_status is NULL)) OR
986: ( (isMod = 'Y') AND (poh.draft_id = DRAFTID AND poh.change_status IS NOT NULL)) )
987: AND