APPS.PO_CORE_S dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1831: FROM PO_REQ_DISTRIBUTIONS_ALL PORD,

1827: x_base_min_unit) *
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;

Line 4182: , PO_REQ_DISTRIBUTIONS_ALL PRD

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: )
4186: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))

Line 4622: FROM PO_REQ_DISTRIBUTIONS_ALL PRD

4618: UPDATE PO_SESSION_GT
4619: SET num2 =
4620: (
4621: SELECT PRD.requisition_line_id
4622: FROM PO_REQ_DISTRIBUTIONS_ALL PRD
4623: WHERE PRD.distribution_id = p_doc_level_id_tbl(i)
4624: )
4625: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))
4626: RETURNING num2

Line 5108: , PO_REQ_DISTRIBUTIONS_ALL PRD

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
5112: AND IDS.key = l_doc_level_id_key

Line 5127: PO_REQ_DISTRIBUTIONS_ALL PRD

5123:
5124: SELECT PRD.distribution_id
5125: BULK COLLECT INTO x_distribution_id_tbl
5126: FROM
5127: PO_REQ_DISTRIBUTIONS_ALL PRD
5128: , PO_SESSION_GT IDS
5129: WHERE PRD.requisition_line_id = IDS.num1
5130: AND IDS.key = l_doc_level_id_key
5131: ;

Line 6537: PO_REQ_DISTRIBUTIONS_ALL PRD

6533: , x_unreserved_count
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

Line 6547: FROM PO_REQ_DISTRIBUTIONS_ALL PRD1

6543: WHERE p_doc_level = g_doc_level_DISTRIBUTION
6544: UNION ALL
6545: SELECT
6546: PRD1.distribution_id dist_id
6547: FROM PO_REQ_DISTRIBUTIONS_ALL PRD1
6548: WHERE p_doc_level = g_doc_level_LINE
6549: AND PRD1.requisition_line_id = p_doc_level_id
6550: UNION ALL
6551: SELECT

Line 6554: PO_REQ_DISTRIBUTIONS_ALL PRD2

6550: UNION ALL
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