APPS.PO_CORE_S dependencies on PO_REQUISITION_LINES_ALL

Line 1660: FROM PO_REQUISITION_LINES_ALL

1656: )
1657: )
1658: , x_base_precision))
1659: INTO x_result_fld
1660: FROM PO_REQUISITION_LINES_ALL
1661: WHERE requisition_header_id = x_object_id
1662: AND nvl(modified_by_agent_flag, 'N') = 'N';
1663:
1664: else

Line 1689: FROM PO_REQUISITION_LINES_ALL

1685: )
1686: /x_base_min_unit)*
1687: x_base_min_unit)
1688: INTO x_result_fld
1689: FROM PO_REQUISITION_LINES_ALL
1690: WHERE requisition_header_id = x_object_id
1691: AND nvl(modified_by_agent_flag, 'N') = 'N';
1692:
1693: end if;

Line 1738: FROM PO_REQUISITION_LINES_ALL

1734: )
1735: )
1736: , x_base_precision))
1737: INTO x_result_fld
1738: FROM PO_REQUISITION_LINES_ALL
1739: WHERE requisition_line_id = x_object_id
1740: AND nvl(modified_by_agent_flag, 'N') = 'N';
1741:
1742: else

Line 1761: FROM PO_REQUISITION_LINES_ALL

1757: )
1758: /x_base_min_unit)*
1759: x_base_min_unit))
1760: INTO x_result_fld
1761: FROM PO_REQUISITION_LINES_ALL
1762: WHERE requisition_line_id = x_object_id
1763: AND nvl(modified_by_agent_flag, 'N') = 'N';
1764:
1765: end if;

Line 1815: PO_REQUISITION_LINES_ALL PORL

1811: x_base_min_unit)
1812: )))
1813: INTO x_result_fld
1814: FROM PO_REQ_DISTRIBUTIONS_ALL PORD,
1815: PO_REQUISITION_LINES_ALL PORL
1816: WHERE PORD.distribution_id = x_object_id
1817: AND PORD.requisition_line_id = PORL.requisition_line_id;
1818:
1819: elsif (x_object_type = 'C' ) then /* Contract */

Line 3994: FROM PO_REQUISITION_LINES_ALL PRL

3990: UPDATE PO_SESSION_GT
3991: SET num2 =
3992: (
3993: SELECT PRL.requisition_header_id
3994: FROM PO_REQUISITION_LINES_ALL PRL
3995: WHERE PRL.requisition_line_id = p_doc_level_id_tbl(i)
3996: )
3997: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))
3998: RETURNING num2

Line 4031: PO_REQUISITION_LINES_ALL PRL

4027: SET num2 =
4028: (
4029: SELECT PRL.requisition_header_id
4030: FROM
4031: PO_REQUISITION_LINES_ALL PRL
4032: , PO_REQ_DISTRIBUTIONS_ALL PRD
4033: WHERE PRL.requisition_line_id = PRD.requisition_line_id
4034: AND PRD.distribution_id = p_doc_level_id_tbl(i)
4035: )

Line 4318: PO_REQUISITION_LINES_ALL PRL

4314:
4315: SELECT PRL.requisition_line_id
4316: BULK COLLECT INTO x_line_id_tbl
4317: FROM
4318: PO_REQUISITION_LINES_ALL PRL
4319: , PO_SESSION_GT IDS
4320: WHERE PRL.requisition_header_id = IDS.num1
4321: AND IDS.key = l_id_key
4322: ;

Line 4902: PO_REQUISITION_LINES_ALL PRL

4898:
4899: SELECT PRD.distribution_id
4900: BULK COLLECT INTO x_distribution_id_tbl
4901: FROM
4902: PO_REQUISITION_LINES_ALL PRL
4903: , PO_REQ_DISTRIBUTIONS_ALL PRD
4904: , PO_SESSION_GT IDS
4905: WHERE PRL.requisition_header_id = IDS.num1
4906: AND PRD.requisition_line_id = PRL.requisition_line_id

Line 6330: , PO_REQUISITION_LINES_ALL PRL

6326: , x_prevented_count
6327:
6328: FROM
6329: PO_REQ_DISTRIBUTIONS_ALL PRD
6330: , PO_REQUISITION_LINES_ALL PRL
6331: , (
6332: SELECT
6333: p_doc_level_id dist_id
6334: FROM DUAL

Line 6347: , PO_REQUISITION_LINES_ALL PRL2

6343: SELECT
6344: PRD2.distribution_id dist_id
6345: FROM
6346: PO_REQ_DISTRIBUTIONS_ALL PRD2
6347: , PO_REQUISITION_LINES_ALL PRL2
6348: WHERE p_doc_level = g_doc_level_HEADER
6349: AND PRD2.requisition_line_id = PRL2.requisition_line_id
6350: AND PRL2.requisition_header_id = p_doc_level_id
6351: ) DIST_IDS