DBA Data[Home] [Help]

APPS.PO_CLM_COLS_SUB_CHECK dependencies on PO_LINE_LOCATIONS_GT

Line 665: FROM PO_HEADERS_GT POH,PO_LINES_GT POL,PO_LINE_LOCATIONS_GT PLL

661: p_sequence,
662: FND_MESSAGE.GET_STRING('PO','PO_EFFECT_DT_INVALID') || ' for Line '||POL.LINE_NUM_DISPLAY,
663: 'Effective date Invalid',
664: 'E'
665: FROM PO_HEADERS_GT POH,PO_LINES_GT POL,PO_LINE_LOCATIONS_GT PLL
666: WHERE POH.PO_HEADER_ID = POL.PO_HEADER_ID
667: AND POL.PO_LINE_ID=PLL.PO_LINE_ID
668: -- AND POH.draft_id = p_draft_id
669: AND POH.PO_HEADER_ID = p_document_id