APPS.PO_CORE_S dependencies on PO_REQ_DISTRIBUTIONS_ALL

Line 1814: FROM PO_REQ_DISTRIBUTIONS_ALL PORD,

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

Line 4032: , PO_REQ_DISTRIBUTIONS_ALL PRD

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

Line 4454: FROM PO_REQ_DISTRIBUTIONS_ALL PRD

4450: UPDATE PO_SESSION_GT
4451: SET num2 =
4452: (
4453: SELECT PRD.requisition_line_id
4454: FROM PO_REQ_DISTRIBUTIONS_ALL PRD
4455: WHERE PRD.distribution_id = p_doc_level_id_tbl(i)
4456: )
4457: WHERE rowid = CHARTOROWID(l_rowid_char_tbl(i))
4458: RETURNING num2

Line 4903: , PO_REQ_DISTRIBUTIONS_ALL PRD

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

Line 4922: PO_REQ_DISTRIBUTIONS_ALL PRD

4918:
4919: SELECT PRD.distribution_id
4920: BULK COLLECT INTO x_distribution_id_tbl
4921: FROM
4922: PO_REQ_DISTRIBUTIONS_ALL PRD
4923: , PO_SESSION_GT IDS
4924: WHERE PRD.requisition_line_id = IDS.num1
4925: AND IDS.key = l_doc_level_id_key
4926: ;

Line 6329: PO_REQ_DISTRIBUTIONS_ALL PRD

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

Line 6339: FROM PO_REQ_DISTRIBUTIONS_ALL PRD1

6335: WHERE p_doc_level = g_doc_level_DISTRIBUTION
6336: UNION ALL
6337: SELECT
6338: PRD1.distribution_id dist_id
6339: FROM PO_REQ_DISTRIBUTIONS_ALL PRD1
6340: WHERE p_doc_level = g_doc_level_LINE
6341: AND PRD1.requisition_line_id = p_doc_level_id
6342: UNION ALL
6343: SELECT

Line 6346: PO_REQ_DISTRIBUTIONS_ALL PRD2

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