DBA Data[Home] [Help]

APPS.CSP_PART_SEARCH_PVT dependencies on CSP_REQUIREMENT_LINES

Line 953: from csp_requirement_lines crl,

949: crh.destination_subinventory,
950: crh.need_by_date,
951: crh.timezone_id,
952: crh.ship_to_location_id
953: from csp_requirement_lines crl,
954: csp_requirement_headers crh
955: where crh.requirement_header_id = p_search_params.requirement_header_id
956: and crl.requirement_header_id = crh.requirement_header_id;
957:

Line 1251: from csp_requirement_lines crl

1247: l_total_quantity number := 0;
1248:
1249: cursor c_requirement is
1250: select inventory_item_id,revision,required_quantity, requirement_line_id
1251: from csp_requirement_lines crl
1252: where requirement_header_id = p_search_params.requirement_header_id;
1253:
1254: cursor c_req_line_details(p_requirement_line_id number) is
1255: select source_type, source_id