APPS.PO_CORE_S dependencies on PO_REQUISITION_LINES_ALL

Line 1675: FROM PO_REQUISITION_LINES_ALL

1671: )
1672: )
1673: , x_base_precision))
1674: INTO x_result_fld
1675: FROM PO_REQUISITION_LINES_ALL
1676: WHERE requisition_header_id = x_object_id
1677: AND nvl(modified_by_agent_flag, 'N') = 'N';
1678:
1679: else

Line 1704: FROM PO_REQUISITION_LINES_ALL

1700: )
1701: /x_base_min_unit)*
1702: x_base_min_unit)
1703: INTO x_result_fld
1704: FROM PO_REQUISITION_LINES_ALL
1705: WHERE requisition_header_id = x_object_id
1706: AND nvl(modified_by_agent_flag, 'N') = 'N';
1707:
1708: end if;

Line 1753: FROM PO_REQUISITION_LINES_ALL

1749: )
1750: )
1751: , x_base_precision))
1752: INTO x_result_fld
1753: FROM PO_REQUISITION_LINES_ALL
1754: WHERE requisition_line_id = x_object_id
1755: AND nvl(modified_by_agent_flag, 'N') = 'N';
1756:
1757: else

Line 1776: FROM PO_REQUISITION_LINES_ALL

1772: )
1773: /x_base_min_unit)*
1774: x_base_min_unit))
1775: INTO x_result_fld
1776: FROM PO_REQUISITION_LINES_ALL
1777: WHERE requisition_line_id = x_object_id
1778: AND nvl(modified_by_agent_flag, 'N') = 'N';
1779:
1780: end if;

Line 1832: PO_REQUISITION_LINES_ALL PORL

1828: x_base_min_unit)
1829: )))
1830: INTO x_result_fld
1831: FROM PO_REQ_DISTRIBUTIONS_ALL PORD,
1832: PO_REQUISITION_LINES_ALL PORL
1833: WHERE PORD.distribution_id = x_object_id
1834: AND PORD.requisition_line_id = PORL.requisition_line_id
1835: AND nvl(PORL.modified_by_agent_flag, 'N') = 'N'; -- Fp of bug 12584086;
1836:

Line 4144: FROM PO_REQUISITION_LINES_ALL PRL

4140: UPDATE PO_SESSION_GT
4141: SET num2 =
4142: (
4143: SELECT PRL.requisition_header_id
4144: FROM PO_REQUISITION_LINES_ALL PRL
4145: WHERE PRL.requisition_line_id = p_doc_level_id_tbl(i)
4146: )
4147: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))
4148: RETURNING num2

Line 4181: PO_REQUISITION_LINES_ALL PRL

4177: SET num2 =
4178: (
4179: SELECT PRL.requisition_header_id
4180: FROM
4181: PO_REQUISITION_LINES_ALL PRL
4182: , PO_REQ_DISTRIBUTIONS_ALL PRD
4183: WHERE PRL.requisition_line_id = PRD.requisition_line_id
4184: AND PRD.distribution_id = p_doc_level_id_tbl(i)
4185: )

Line 4484: PO_REQUISITION_LINES_ALL PRL

4480:
4481: SELECT PRL.requisition_line_id
4482: BULK COLLECT INTO x_line_id_tbl
4483: FROM
4484: PO_REQUISITION_LINES_ALL PRL
4485: , PO_SESSION_GT IDS
4486: WHERE PRL.requisition_header_id = IDS.num1
4487: AND IDS.key = l_id_key
4488: ;

Line 5107: PO_REQUISITION_LINES_ALL PRL

5103:
5104: SELECT PRD.distribution_id
5105: BULK COLLECT INTO x_distribution_id_tbl
5106: FROM
5107: PO_REQUISITION_LINES_ALL PRL
5108: , PO_REQ_DISTRIBUTIONS_ALL PRD
5109: , PO_SESSION_GT IDS
5110: WHERE PRL.requisition_header_id = IDS.num1
5111: AND PRD.requisition_line_id = PRL.requisition_line_id

Line 6538: , PO_REQUISITION_LINES_ALL PRL

6534: , x_prevented_count
6535:
6536: FROM
6537: PO_REQ_DISTRIBUTIONS_ALL PRD
6538: , PO_REQUISITION_LINES_ALL PRL
6539: , (
6540: SELECT
6541: p_doc_level_id dist_id
6542: FROM DUAL

Line 6555: , PO_REQUISITION_LINES_ALL PRL2

6551: SELECT
6552: PRD2.distribution_id dist_id
6553: FROM
6554: PO_REQ_DISTRIBUTIONS_ALL PRD2
6555: , PO_REQUISITION_LINES_ALL PRL2
6556: WHERE p_doc_level = g_doc_level_HEADER
6557: AND PRD2.requisition_line_id = PRL2.requisition_line_id
6558: AND PRL2.requisition_header_id = p_doc_level_id
6559: ) DIST_IDS