DBA Data[Home] [Help]

APPS.PO_PDOI_MAINPROC_UTL_PVT dependencies on PO_DISTRIBUTIONS_DRAFT_ALL

Line 1084: FROM po_distributions_draft_all

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

Line 1342: FROM po_distributions_draft_all

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