DBA Data[Home] [Help]

APPS.PO_PDOI_MAINPROC_UTL_PVT dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

Line 1087: FROM po_distributions_draft_all

1083: SELECT l_key,
1084: p_line_loc_id_tbl(i),
1085: v.max_dist_num
1086: FROM (SELECT max(distribution_num) AS max_dist_num
1087: FROM po_distributions_draft_all
1088: WHERE draft_id = p_draft_id_tbl(i)
1089: AND line_location_id = p_line_loc_id_tbl(i)) v
1090: WHERE v.max_dist_num IS NOT NULL;
1091:

Line 1345: FROM po_distributions_draft_all

1341: FORALL i IN 1..l_index_tbl.COUNT
1342: INSERT INTO po_session_gt(key, num1)
1343: SELECT l_key,
1344: l_index_tbl(i)
1345: FROM po_distributions_draft_all
1346: WHERE line_location_id = p_line_loc_id_tbl(i)
1347: AND draft_id = p_draft_id_tbl(i)
1348: AND distribution_num = p_dist_num_tbl(i);
1349: