eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PO_CORE_S3 dependencies on PO_DISTRIBUTIONS_ALL

Line 318: FROM po_distributions_all pd,

314: num2)-- payment_sequence_num
315: SELECT l_key,
316: pd.po_distribution_id,
317: rec.seq_num
318: FROM po_distributions_all pd,
319: (SELECT acrn,
320: rownum AS seq_num
321: FROM (SELECT DISTINCT acrn
322: FROM po_distributions_all

Line 322: FROM po_distributions_all

318: FROM po_distributions_all pd,
319: (SELECT acrn,
320: rownum AS seq_num
321: FROM (SELECT DISTINCT acrn
322: FROM po_distributions_all
323: WHERE po_header_id = p_po_header_id
324: ORDER BY acrn)) rec
325: WHERE pd.acrn = rec.acrn
326: AND pd.po_header_id = p_po_header_id;

Line 337: FROM po_distributions_all pd

333: num2)-- payment_sequence_num
334: SELECT l_key,
335: pd.po_distribution_id,
336: 1
337: FROM po_distributions_all pd
338: WHERE pd.po_header_id = p_po_header_id;
339:
340: ELSIF p_payment_instr_code = 'BY_FISCAL_YR' THEN
341:

Line 349: FROM po_distributions_all pd,

345: num2)-- payment_sequence_num
346: SELECT l_key,
347: pd.po_distribution_id,
348: rec.seq_num
349: FROM po_distributions_all pd,
350: (SELECT fiscal_year,
351: rownum AS seq_num
352: FROM (SELECT DISTINCT PO_CORE_S3.get_fiscal_year_from_ccid(set_of_books_id, code_combination_id) as fiscal_year
353: FROM po_distributions_all

Line 353: FROM po_distributions_all

349: FROM po_distributions_all pd,
350: (SELECT fiscal_year,
351: rownum AS seq_num
352: FROM (SELECT DISTINCT PO_CORE_S3.get_fiscal_year_from_ccid(set_of_books_id, code_combination_id) as fiscal_year
353: FROM po_distributions_all
354: WHERE po_header_id = p_po_header_id
355: ORDER BY fiscal_year)) rec
356: WHERE PO_CORE_S3.get_fiscal_year_from_ccid(pd.set_of_books_id, pd.code_combination_id) = rec.fiscal_year
357: AND pd.po_header_id = p_po_header_id;

Line 368: FROM po_distributions_all pd,

364: num2)-- payment_sequence_num
365: SELECT l_key,
366: pd.po_distribution_id,
367: rec.seq_num
368: FROM po_distributions_all pd,
369: (SELECT cancellation_date,
370: rownum AS seq_num
371: FROM (SELECT DISTINCT PO_CORE_S3.get_ccid_cancellation_date(set_of_books_id, code_combination_id) as cancellation_date
372: FROM po_distributions_all

Line 372: FROM po_distributions_all

368: FROM po_distributions_all pd,
369: (SELECT cancellation_date,
370: rownum AS seq_num
371: FROM (SELECT DISTINCT PO_CORE_S3.get_ccid_cancellation_date(set_of_books_id, code_combination_id) as cancellation_date
372: FROM po_distributions_all
373: WHERE po_header_id = p_po_header_id
374: ORDER BY cancellation_date)) rec
375: WHERE PO_CORE_S3.get_ccid_cancellation_date(pd.set_of_books_id, pd.code_combination_id)= rec.cancellation_date
376: AND pd.po_header_id = p_po_header_id;

Line 390: FROM po_distributions_all pd,

386: num2)-- payment_sequence_num
387: SELECT l_key,
388: pd.po_distribution_id,
389: rec.seq_num
390: FROM po_distributions_all pd,
391: (SELECT acrn,
392: rownum AS seq_num
393: FROM (SELECT DISTINCT acrn
394: FROM po_distributions_all

Line 394: FROM po_distributions_all

390: FROM po_distributions_all pd,
391: (SELECT acrn,
392: rownum AS seq_num
393: FROM (SELECT DISTINCT acrn
394: FROM po_distributions_all
395: WHERE po_header_id = p_po_header_id
396: AND po_line_id = p_line_id
397: ORDER BY acrn)) rec
398: WHERE pd.acrn = rec.acrn

Line 411: FROM po_distributions_all pd

407: num2)-- payment_sequence_num
408: SELECT l_key,
409: pd.po_distribution_id,
410: 1
411: FROM po_distributions_all pd
412: WHERE pd.po_header_id = p_po_header_id
413: AND pd.po_line_id = p_line_id;
414:
415: ELSIF p_payment_instr_code = 'BY_FISCAL_YR' THEN

Line 424: FROM po_distributions_all pd,

420: num2)-- payment_sequence_num
421: SELECT l_key,
422: pd.po_distribution_id,
423: rec.seq_num
424: FROM po_distributions_all pd,
425: (SELECT fiscal_year,
426: rownum AS seq_num
427: FROM (SELECT DISTINCT PO_CORE_S3.get_fiscal_year_from_ccid(set_of_books_id, code_combination_id) as fiscal_year
428: FROM po_distributions_all

Line 428: FROM po_distributions_all

424: FROM po_distributions_all pd,
425: (SELECT fiscal_year,
426: rownum AS seq_num
427: FROM (SELECT DISTINCT PO_CORE_S3.get_fiscal_year_from_ccid(set_of_books_id, code_combination_id) as fiscal_year
428: FROM po_distributions_all
429: WHERE po_header_id = p_po_header_id
430: AND po_line_id = p_line_id
431: ORDER BY fiscal_year )) rec
432: WHERE PO_CORE_S3.get_fiscal_year_from_ccid(pd.set_of_books_id, pd.code_combination_id) = rec.fiscal_year

Line 445: FROM po_distributions_all pd,

441: num2)-- payment_sequence_num
442: SELECT l_key,
443: pd.po_distribution_id,
444: rec.seq_num
445: FROM po_distributions_all pd,
446: (SELECT cancellation_date,
447: rownum AS seq_num
448: FROM (SELECT DISTINCT PO_CORE_S3.get_ccid_cancellation_date(set_of_books_id, code_combination_id) as cancellation_date
449: FROM po_distributions_all

Line 449: FROM po_distributions_all

445: FROM po_distributions_all pd,
446: (SELECT cancellation_date,
447: rownum AS seq_num
448: FROM (SELECT DISTINCT PO_CORE_S3.get_ccid_cancellation_date(set_of_books_id, code_combination_id) as cancellation_date
449: FROM po_distributions_all
450: WHERE po_header_id = p_po_header_id
451: AND po_line_id = p_line_id
452: ORDER BY cancellation_date)) rec
453: WHERE PO_CORE_S3.get_ccid_cancellation_date(pd.set_of_books_id, pd.code_combination_id) = rec.cancellation_date

Line 461: UPDATE po_distributions_all pda

457:
458: END IF; -- payment instr code
459: END IF; -- end if for po_line_id is NULL
460: -- Update distributions with fetched sequence.
461: UPDATE po_distributions_all pda
462: SET pda.clm_payment_sequence_num = (SELECT gt.num2
463: FROM po_session_gt gt
464: WHERE gt.KEY = l_key
465: AND gt.num1 = pda.po_distribution_id)

Line 524: UPDATE po_distributions_all pod

520: FOR i in 1..l_po_line_id_tbl.COUNT LOOP
521:
522: IF l_payment_instr_code_tbl(i) IS NULL THEN
523: -- Clear out payment sequence num if at all left any due to revert even when instruction is not specified.
524: UPDATE po_distributions_all pod
525: SET pod.clm_payment_sequence_num = NULL
526: WHERE pod.po_header_id = p_po_header_id
527: AND pod.po_line_id = l_po_line_id_tbl(i)
528: AND pod.clm_payment_sequence_num IS NOT NULL;

Line 614: FUNCTION is_non_annual_fund(ccid IN po_distributions_all.CODE_COMBINATION_ID%TYPE,

610: END IF;
611: RETURN null;
612: END get_ccid_cancellation_date;
613:
614: FUNCTION is_non_annual_fund(ccid IN po_distributions_all.CODE_COMBINATION_ID%TYPE,
615: p_ledger_id IN NUMBER)
616: RETURN VARCHAR2
617:
618: IS