DBA Data[Home] [Help]

APPS.ASO_TRADEIN_PVT dependencies on ASO_QUOTE_LINE_DETAILS

Line 456: FROM ASO_QUOTE_LINES_ALL a, ASO_QUOTE_LINE_DETAILS b

452: CONNECT BY object_id = prior subject_id;
453:
454: CURSOR C_Ln_Dtl_Instances(l_instance_id NUMBER, l_header_id NUMBER) IS
455: SELECT 'Y'
456: FROM ASO_QUOTE_LINES_ALL a, ASO_QUOTE_LINE_DETAILS b
457: WHERE a.quote_line_id = b.quote_line_id
458: AND a.quote_header_id = l_header_id
459: AND b.instance_id = l_instance_id;
460:

Line 935: FROM ASO_QUOTE_LINE_DETAILS

931: IS
932:
933: CURSOR C_Get_Dtl_Info(l_line_id NUMBER) IS
934: SELECT instance_id, return_ref_type, return_ref_line_id
935: FROM ASO_QUOTE_LINE_DETAILS
936: WHERE quote_line_id = l_line_id;
937:
938: CURSOR C_Get_Qot_Qty(l_line_id NUMBER) IS
939: SELECT quantity