APPS.ASO_ATP_INT dependencies on ASO_SHIPMENTS

Line 164: from aso_shipments

160: and inventory_item_id = p_inv_item_id;
161:
162: cursor c_request_date_type(p_quote_header_id number) is
163: select nvl(request_date_type,'SHIP'),shipment_id
164: from aso_shipments
165: where quote_header_id = p_quote_header_id;
166:
167: cursor c_request_date_type_meaning(p_lookup_code varchar2) is
168: select l.meaning

Line 184: from aso_shipments

180: and lookup_code = p_error_code;
181:
182: cursor c_get_shipment_id (p_qte_header_id number, p_qte_line_id number) is
183: select shipment_id
184: from aso_shipments
185: where quote_header_id = p_qte_header_id
186: and quote_line_id = p_qte_line_id;
187:
188: BEGIN

Line 459: from aso_quote_line_details a, aso_shipments b

455: where quote_header_id = p_quote_header_id;
456:
457: cursor c_configuration_rows(p_config_header_id number, p_config_revision_num number) is
458: select a.quote_line_id, b.shipment_id
459: from aso_quote_line_details a, aso_shipments b
460: where a.quote_line_id = b.quote_line_id
461: and a.config_header_id = p_config_header_id
462: and a.config_revision_num = p_config_revision_num
463: order by a.bom_sort_order;

Line 467: from aso_quote_line_details a, aso_shipments b

463: order by a.bom_sort_order;
464:
465: cursor c_ato_rows(p_config_header_id number, p_config_revision_num number, p_ato_line_id number) is
466: select a.quote_line_id, b.shipment_id
467: from aso_quote_line_details a, aso_shipments b
468: where a.quote_line_id = b.quote_line_id
469: and a.config_header_id = p_config_header_id
470: and a.config_revision_num = p_config_revision_num
471: and a.ato_line_id = p_ato_line_id

Line 482: select shipment_id from aso_shipments

478: and ref_line_id is null
479: and ref_type_code = 'CONFIG';
480:
481: cursor c_shipment_id(p_quote_line_id number) is
482: select shipment_id from aso_shipments
483: where quote_line_id = p_quote_line_id;
484:
485: cursor c_request_date_type(p_shipment_id number) is
486: select request_date_type from aso_shipments

Line 486: select request_date_type from aso_shipments

482: select shipment_id from aso_shipments
483: where quote_line_id = p_quote_line_id;
484:
485: cursor c_request_date_type(p_shipment_id number) is
486: select request_date_type from aso_shipments
487: where shipment_id = p_shipment_id;
488:
489: -- filtering out the service items and the component models
490: -- before passing the records to ATP

Line 506: from aso_shipments

502: where quote_header_id = p_qte_header_id;
503:
504: cursor c_get_warehouse (p_qte_line_id number, p_qte_header_id number ) is
505: select ship_from_org_id
506: from aso_shipments
507: where quote_line_id = p_qte_line_id
508: and quote_header_id = p_qte_header_id;
509:
510: cursor c_get_ids (p_qte_line_id number) is

Line 517: from aso_shipments

513: where quote_line_id = p_qte_line_id;
514:
515: cursor c_get_request_date (p_qte_line_id number, p_qte_header_id number,p_date_type varchar2 ) is
516: select request_date
517: from aso_shipments
518: where quote_line_id = p_qte_line_id
519: and quote_header_id = p_qte_header_id
520: and nvl(request_date_type,'SHIP') = p_date_type;
521:

Line 524: from aso_shipments

520: and nvl(request_date_type,'SHIP') = p_date_type;
521:
522: cursor c_get_ship_method (p_qte_line_id number, p_qte_header_id number ) is
523: select ship_method_code
524: from aso_shipments
525: where quote_line_id = p_qte_line_id
526: and quote_header_id = p_qte_header_id;
527:
528: cursor c_get_demand_code (p_qte_line_id number, p_qte_header_id number ) is

Line 530: from aso_shipments

526: and quote_header_id = p_qte_header_id;
527:
528: cursor c_get_demand_code (p_qte_line_id number, p_qte_header_id number ) is
529: select demand_class_code
530: from aso_shipments
531: where quote_line_id = p_qte_line_id
532: and quote_header_id = p_qte_header_id;
533:
534: