APPS.PO_DOCUMENT_CHECKS_PVT dependencies on PO_LINE_UCAS

Line 25304: FROM po_line_ucas uc,

25300: po_core_s.Get_translated_text('PO_UCA_PDD_PAST_DATE',
25301: 'LINE_NUM', pol.line_num_display),
25302: 'PO_UCA_PDD_PAST_DATE',
25303: 'W'
25304: FROM po_line_ucas uc,
25305: po_lines_gt pol,
25306: po_headers_gt poh
25307: WHERE Nvl(pol.clm_undef_flag, 'N') = 'Y'
25308: AND uc.planned_def_date IS NOT NULL

Line 25354: FROM po_line_ucas uc,

25350: po_core_s.Get_translated_text('PO_UCA_UNDEF_INCOMPLETE', 'LINE_NUM',
25351: pol.line_num_display),
25352: 'PO_UCA_UNDEF_INCOMPLETE',
25353: 'E'
25354: FROM po_line_ucas uc,
25355: po_lines_gt pol,
25356: po_headers_gt poh
25357: WHERE Nvl(pol.clm_undef_flag, 'N') = 'Y'
25358: AND ( NOT ( ( uc.planned_def_date IS NOT NULL

Line 25409: FROM po_line_ucas uc,

25405: po_core_s.Get_translated_text('PO_UCA_DEF_DESC_ERR', 'DOC_NUM',
25406: uc.undef_clm_document_number, 'LINE_NUM', pol.line_num_display),
25407: 'PO_UCA_DEF_DESC_ERR',
25408: 'E'
25409: FROM po_line_ucas uc,
25410: po_lines_gt pol,
25411: po_headers_gt poh
25412: WHERE Nvl(pol.clm_undef_action_code, 'X') = 'DEF'
25413: AND uc.undef_amount IS NULL

Line 25477: FROM po_line_ucas uc

25473: change_in_ext_price,
25474: Nvl((SELECT SUM(Nvl(not_to_exceed_amount, 0)) -
25475: SUM(Nvl(undef_amount, 0))
25476: max_all_change
25477: FROM po_line_ucas uc
25478: WHERE pol.po_line_id = uc.po_line_id
25479: AND ph.po_header_id = uc.po_header_id
25480: AND (uc.def_draft_id = ph.draft_id
25481: OR uc.def_par_draft_id = ph.draft_id)), 0) max_change,

Line 25535: FROM po_line_ucas ucas

25531: WHERE ph.po_header_id = p_document_id
25532: AND ph.po_header_id = pol.po_header_id
25533: AND Nvl(pol.clm_undef_action_code,'X') = 'DEF'
25534: AND NOT EXISTS (SELECT 1
25535: FROM po_line_ucas ucas
25536: WHERE ucas.po_line_id = pol.po_line_id
25537: AND ucas.po_header_id = p_document_id
25538: AND ( ucas.def_draft_id = Ph.draft_id
25539: OR ucas.def_par_draft_id = ph.draft_id ));