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_REQ_LINES_SV dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1566: AND NOT EXISTS ( SELECT 1 FROM po_req_distributions_all prd

1562: FROM po_requisition_lines_all reqline, TABLE(X_entity_id) entity
1563: WHERE (reqline.clm_info_flag = 'Y' OR reqline.clm_option_indicator = 'O'
1564: OR reqLine.par_draft_id IS NOT NULL) --To process PAR lines without any distribution
1565: -- Dod - Exclude Info Funded Slins
1566: AND NOT EXISTS ( SELECT 1 FROM po_req_distributions_all prd
1567: WHERE prd.info_line_id = reqline.requisition_line_id)
1568: AND reqline.po_line_id = entity.column_value;
1569: -- For priced lines.
1570: ELSIF (X_entity = 'DISTRIBUTION') THEN

Line 1576: FROM po_distributions_all pod, po_req_distributions_all reqdist, TABLE(X_entity_id) entity

1572: BEGIN
1573: -- Collect Req lines(Not Info Funded for Dod) which are linked using Autocreate or SoftLink to the Award
1574: SELECT reqdist.requisition_line_id , Count(1)
1575: BULK COLLECT INTO l_non_infofunded_slin_ids, l_non_infofunded_slin_count
1576: FROM po_distributions_all pod, po_req_distributions_all reqdist, TABLE(X_entity_id) entity
1577: WHERE pod.req_distribution_id = reqdist.distribution_id
1578: AND reqdist.info_line_id IS NULL
1579: AND pod.po_distribution_id = entity.column_value
1580: GROUP BY reqdist.requisition_line_id ;

Line 1601: FROM po_distributions_all pod, po_req_distributions_all reqdist, TABLE(X_entity_id) entity

1597: -- Dod , Collect req lines(Info Funded) which are linked using Autocreate or SoftLink to the Award
1598: -- Fecth info_line_id, rather the requisition_line_id, so that we get InfoFundedLineId
1599: SELECT reqdist.info_line_id , Min(reqdist.requisition_line_id), Count(1)
1600: BULK COLLECT INTO l_info_funded_slin_ids, l_infofunded_slin_grp_ids, l_info_funded_slin_count
1601: FROM po_distributions_all pod, po_req_distributions_all reqdist, TABLE(X_entity_id) entity
1602: WHERE pod.req_distribution_id = reqdist.distribution_id
1603: AND reqdist.info_line_id IS NOT NULL
1604: AND pod.po_distribution_id = entity.column_value
1605: GROUP BY reqdist.info_line_id ;

Line 1631: FROM po_distributions_draft_all pod, po_req_distributions_all reqdist, TABLE(X_entity_id) entity

1627: BEGIN
1628: -- Collect Req lines(Not Info Funded for Dod) which are linked using Autocreate or SoftLink to the Modification
1629: SELECT reqdist.requisition_line_id , Count(1)
1630: BULK COLLECT INTO l_non_infofunded_slin_ids, l_non_infofunded_slin_count
1631: FROM po_distributions_draft_all pod, po_req_distributions_all reqdist, TABLE(X_entity_id) entity
1632: WHERE pod.req_distribution_id = reqdist.distribution_id
1633: AND reqdist.info_line_id IS NULL
1634: AND pod.po_distribution_id = entity.column_value
1635: AND change_status = 'NEW'

Line 1657: FROM po_distributions_draft_all pod, po_req_distributions_all reqdist, TABLE(X_entity_id) entity

1653: -- Dod , Collect req lines(Info Funded) which are linked using Autocreate or SoftLink to the Modification
1654: -- Fecth info_line_id, rather the requisition_line_id, so that we get InfoFundedLineId
1655: SELECT reqdist.info_line_id , Min(reqdist.requisition_line_id), Count(1)
1656: BULK COLLECT INTO l_info_funded_slin_ids, l_infofunded_slin_grp_ids, l_info_funded_slin_count
1657: FROM po_distributions_draft_all pod, po_req_distributions_all reqdist, TABLE(X_entity_id) entity
1658: WHERE pod.req_distribution_id = reqdist.distribution_id
1659: AND reqdist.info_line_id IS NOT NULL
1660: AND pod.po_distribution_id = entity.column_value
1661: AND change_status = 'NEW'