DBA Data[Home] [Help]

APPS.OE_BULK_PRICEORDER_PVT dependencies on QP_LIST_LINES

Line 1097: from qp_list_headers_vl a,qp_list_lines b where

1093: FND_MESSAGE.SET_NAME('ONT','ONT_PRC_DUPLICATE_PRICE_LIST');
1094:
1095: Begin
1096: Select name into l_price_list
1097: from qp_list_headers_vl a,qp_list_lines b where
1098: b.list_line_id = to_number(substr(wrong_line.status_text,1,
1099: instr(wrong_line.status_text,',')-1))
1100: and a.list_header_id=b.list_header_id
1101: ;

Line 1119: from qp_list_headers_vl a,qp_list_lines b where

1115:
1116:
1117: Begin
1118: Select name into l_price_list
1119: from qp_list_headers_vl a,qp_list_lines b where
1120: b.list_line_id =
1121: to_number(substr(wrong_line.status_text,
1122: instr(wrong_line.status_text,',')+1))
1123: and a.list_header_id=b.list_header_id ;