DBA Data[Home] [Help]

APPS.PO_REQ_LINES_SV dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

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'