DBA Data[Home] [Help]

APPS.OE_FREIGHT_CHOICES_PVT dependencies on QP_PREQ_LINES_TMP

Line 1163: Select sum(nvl(l.ADJUSTMENT_AMOUNT,0)) into q_Adjusted_amount from QP_ldets_v l,QP_preq_lines_tmp q

1159: K := 1;
1160: K := l_line_tbl.FIRST;
1161: WHILE K IS NOT NULL LOOP
1162:
1163: Select sum(nvl(l.ADJUSTMENT_AMOUNT,0)) into q_Adjusted_amount from QP_ldets_v l,QP_preq_lines_tmp q
1164: where l.line_index = q.line_index
1165: and q.line_id = l_line_tbl(K).line_id
1166: and q.line_type_code = 'LINE'
1167: AND nvl(l.automatic_flag,'N') = 'Y'