DBA Data[Home] [Help]

APPS.WSH_SHIP_CONFIRM_ACTIONS dependencies on WSH_DELIVERY_DETAILS

Line 491: source_header_id wsh_delivery_details.source_header_id%TYPE,

487: x_return_status OUT NOCOPY VARCHAR2);
488:
489: --Standalone WMS project changes ,created new record
490: TYPE oe_interface_rec is RECORD (
491: source_header_id wsh_delivery_details.source_header_id%TYPE,
492: source_header_number wsh_delivery_details.source_header_number%TYPE,
493: source_line_set_id wsh_delivery_details.source_line_set_id%TYPE,
494: source_line_id wsh_delivery_details.source_line_id%TYPE,
495: order_line_quantity oe_order_lines_all.ordered_quantity%TYPE,

Line 492: source_header_number wsh_delivery_details.source_header_number%TYPE,

488:
489: --Standalone WMS project changes ,created new record
490: TYPE oe_interface_rec is RECORD (
491: source_header_id wsh_delivery_details.source_header_id%TYPE,
492: source_header_number wsh_delivery_details.source_header_number%TYPE,
493: source_line_set_id wsh_delivery_details.source_line_set_id%TYPE,
494: source_line_id wsh_delivery_details.source_line_id%TYPE,
495: order_line_quantity oe_order_lines_all.ordered_quantity%TYPE,
496: -- muom

Line 493: source_line_set_id wsh_delivery_details.source_line_set_id%TYPE,

489: --Standalone WMS project changes ,created new record
490: TYPE oe_interface_rec is RECORD (
491: source_header_id wsh_delivery_details.source_header_id%TYPE,
492: source_header_number wsh_delivery_details.source_header_number%TYPE,
493: source_line_set_id wsh_delivery_details.source_line_set_id%TYPE,
494: source_line_id wsh_delivery_details.source_line_id%TYPE,
495: order_line_quantity oe_order_lines_all.ordered_quantity%TYPE,
496: -- muom
497: order_line_quantity2 oe_order_lines_all.ordered_quantity%TYPE,

Line 494: source_line_id wsh_delivery_details.source_line_id%TYPE,

490: TYPE oe_interface_rec is RECORD (
491: source_header_id wsh_delivery_details.source_header_id%TYPE,
492: source_header_number wsh_delivery_details.source_header_number%TYPE,
493: source_line_set_id wsh_delivery_details.source_line_set_id%TYPE,
494: source_line_id wsh_delivery_details.source_line_id%TYPE,
495: order_line_quantity oe_order_lines_all.ordered_quantity%TYPE,
496: -- muom
497: order_line_quantity2 oe_order_lines_all.ordered_quantity%TYPE,
498: requested_quantity_uom wsh_delivery_details.requested_quantity_uom%TYPE,

Line 498: requested_quantity_uom wsh_delivery_details.requested_quantity_uom%TYPE,

494: source_line_id wsh_delivery_details.source_line_id%TYPE,
495: order_line_quantity oe_order_lines_all.ordered_quantity%TYPE,
496: -- muom
497: order_line_quantity2 oe_order_lines_all.ordered_quantity%TYPE,
498: requested_quantity_uom wsh_delivery_details.requested_quantity_uom%TYPE,
499: requested_quantity_uom2 wsh_delivery_details.requested_quantity_uom2%TYPE,
500: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
501: order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE,
502: ordered_quantity2 oe_order_lines_all.ordered_quantity2%TYPE,

Line 499: requested_quantity_uom2 wsh_delivery_details.requested_quantity_uom2%TYPE,

495: order_line_quantity oe_order_lines_all.ordered_quantity%TYPE,
496: -- muom
497: order_line_quantity2 oe_order_lines_all.ordered_quantity%TYPE,
498: requested_quantity_uom wsh_delivery_details.requested_quantity_uom%TYPE,
499: requested_quantity_uom2 wsh_delivery_details.requested_quantity_uom2%TYPE,
500: ordered_quantity oe_order_lines_all.ordered_quantity%TYPE,
501: order_quantity_uom oe_order_lines_all.order_quantity_uom%TYPE,
502: ordered_quantity2 oe_order_lines_all.ordered_quantity2%TYPE,
503: ordered_quantity_uom2 oe_order_lines_all.ordered_quantity_uom2%TYPE,

Line 507: ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,

503: ordered_quantity_uom2 oe_order_lines_all.ordered_quantity_uom2%TYPE,
504: model_remnant_flag oe_order_lines_all.model_remnant_flag%TYPE,
505: item_type_code oe_order_lines_all.item_type_code%TYPE,
506: calculate_price_flag oe_order_lines_all.calculate_price_flag%TYPE,
507: ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
508: ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
509: org_id oe_order_lines_all.org_id%TYPE,
510: organization_id wsh_delivery_details.organization_id%TYPE,
511: oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,

Line 508: ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,

504: model_remnant_flag oe_order_lines_all.model_remnant_flag%TYPE,
505: item_type_code oe_order_lines_all.item_type_code%TYPE,
506: calculate_price_flag oe_order_lines_all.calculate_price_flag%TYPE,
507: ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
508: ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
509: org_id oe_order_lines_all.org_id%TYPE,
510: organization_id wsh_delivery_details.organization_id%TYPE,
511: oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
512: initial_pickup_date wsh_new_deliveries.initial_pickup_date%TYPE,

Line 510: organization_id wsh_delivery_details.organization_id%TYPE,

506: calculate_price_flag oe_order_lines_all.calculate_price_flag%TYPE,
507: ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
508: ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
509: org_id oe_order_lines_all.org_id%TYPE,
510: organization_id wsh_delivery_details.organization_id%TYPE,
511: oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
512: initial_pickup_date wsh_new_deliveries.initial_pickup_date%TYPE,
513: top_model_line_id wsh_delivery_details.top_model_line_id%TYPE ,
514: ato_line_id wsh_delivery_details.ato_line_id%TYPE,

Line 511: oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,

507: ship_tolerance_below wsh_delivery_details.ship_tolerance_below%TYPE,
508: ship_tolerance_above wsh_delivery_details.ship_tolerance_above%TYPE,
509: org_id oe_order_lines_all.org_id%TYPE,
510: organization_id wsh_delivery_details.organization_id%TYPE,
511: oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
512: initial_pickup_date wsh_new_deliveries.initial_pickup_date%TYPE,
513: top_model_line_id wsh_delivery_details.top_model_line_id%TYPE ,
514: ato_line_id wsh_delivery_details.ato_line_id%TYPE,
515: ship_set_id wsh_delivery_details.ship_set_id%TYPE,

Line 513: top_model_line_id wsh_delivery_details.top_model_line_id%TYPE ,

509: org_id oe_order_lines_all.org_id%TYPE,
510: organization_id wsh_delivery_details.organization_id%TYPE,
511: oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
512: initial_pickup_date wsh_new_deliveries.initial_pickup_date%TYPE,
513: top_model_line_id wsh_delivery_details.top_model_line_id%TYPE ,
514: ato_line_id wsh_delivery_details.ato_line_id%TYPE,
515: ship_set_id wsh_delivery_details.ship_set_id%TYPE,
516: ship_model_complete_flag wsh_delivery_details.ship_model_complete_flag%TYPE,
517: arrival_set_id wsh_delivery_details.arrival_set_id%TYPE,

Line 514: ato_line_id wsh_delivery_details.ato_line_id%TYPE,

510: organization_id wsh_delivery_details.organization_id%TYPE,
511: oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
512: initial_pickup_date wsh_new_deliveries.initial_pickup_date%TYPE,
513: top_model_line_id wsh_delivery_details.top_model_line_id%TYPE ,
514: ato_line_id wsh_delivery_details.ato_line_id%TYPE,
515: ship_set_id wsh_delivery_details.ship_set_id%TYPE,
516: ship_model_complete_flag wsh_delivery_details.ship_model_complete_flag%TYPE,
517: arrival_set_id wsh_delivery_details.arrival_set_id%TYPE,
518: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,

Line 515: ship_set_id wsh_delivery_details.ship_set_id%TYPE,

511: oe_interfaced_flag wsh_delivery_details.oe_interfaced_flag%TYPE,
512: initial_pickup_date wsh_new_deliveries.initial_pickup_date%TYPE,
513: top_model_line_id wsh_delivery_details.top_model_line_id%TYPE ,
514: ato_line_id wsh_delivery_details.ato_line_id%TYPE,
515: ship_set_id wsh_delivery_details.ship_set_id%TYPE,
516: ship_model_complete_flag wsh_delivery_details.ship_model_complete_flag%TYPE,
517: arrival_set_id wsh_delivery_details.arrival_set_id%TYPE,
518: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,
519: flow_status_code oe_order_lines_all.flow_status_code%TYPE,

Line 516: ship_model_complete_flag wsh_delivery_details.ship_model_complete_flag%TYPE,

512: initial_pickup_date wsh_new_deliveries.initial_pickup_date%TYPE,
513: top_model_line_id wsh_delivery_details.top_model_line_id%TYPE ,
514: ato_line_id wsh_delivery_details.ato_line_id%TYPE,
515: ship_set_id wsh_delivery_details.ship_set_id%TYPE,
516: ship_model_complete_flag wsh_delivery_details.ship_model_complete_flag%TYPE,
517: arrival_set_id wsh_delivery_details.arrival_set_id%TYPE,
518: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,
519: flow_status_code oe_order_lines_all.flow_status_code%TYPE,
520: total_requested_quantity wsh_delivery_details.requested_quantity%TYPE,

Line 517: arrival_set_id wsh_delivery_details.arrival_set_id%TYPE,

513: top_model_line_id wsh_delivery_details.top_model_line_id%TYPE ,
514: ato_line_id wsh_delivery_details.ato_line_id%TYPE,
515: ship_set_id wsh_delivery_details.ship_set_id%TYPE,
516: ship_model_complete_flag wsh_delivery_details.ship_model_complete_flag%TYPE,
517: arrival_set_id wsh_delivery_details.arrival_set_id%TYPE,
518: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,
519: flow_status_code oe_order_lines_all.flow_status_code%TYPE,
520: total_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
521: total_requested_quantity2 wsh_delivery_details.requested_quantity2%TYPE,

Line 518: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,

514: ato_line_id wsh_delivery_details.ato_line_id%TYPE,
515: ship_set_id wsh_delivery_details.ship_set_id%TYPE,
516: ship_model_complete_flag wsh_delivery_details.ship_model_complete_flag%TYPE,
517: arrival_set_id wsh_delivery_details.arrival_set_id%TYPE,
518: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,
519: flow_status_code oe_order_lines_all.flow_status_code%TYPE,
520: total_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
521: total_requested_quantity2 wsh_delivery_details.requested_quantity2%TYPE,
522: total_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,

Line 520: total_requested_quantity wsh_delivery_details.requested_quantity%TYPE,

516: ship_model_complete_flag wsh_delivery_details.ship_model_complete_flag%TYPE,
517: arrival_set_id wsh_delivery_details.arrival_set_id%TYPE,
518: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,
519: flow_status_code oe_order_lines_all.flow_status_code%TYPE,
520: total_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
521: total_requested_quantity2 wsh_delivery_details.requested_quantity2%TYPE,
522: total_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,
523: total_shipped_quantity2 wsh_delivery_details.shipped_quantity2%TYPE,
524: -- muom

Line 521: total_requested_quantity2 wsh_delivery_details.requested_quantity2%TYPE,

517: arrival_set_id wsh_delivery_details.arrival_set_id%TYPE,
518: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,
519: flow_status_code oe_order_lines_all.flow_status_code%TYPE,
520: total_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
521: total_requested_quantity2 wsh_delivery_details.requested_quantity2%TYPE,
522: total_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,
523: total_shipped_quantity2 wsh_delivery_details.shipped_quantity2%TYPE,
524: -- muom
525: total_om_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE);

Line 522: total_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,

518: inventory_item_id wsh_delivery_details.inventory_item_id%TYPE,
519: flow_status_code oe_order_lines_all.flow_status_code%TYPE,
520: total_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
521: total_requested_quantity2 wsh_delivery_details.requested_quantity2%TYPE,
522: total_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,
523: total_shipped_quantity2 wsh_delivery_details.shipped_quantity2%TYPE,
524: -- muom
525: total_om_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE);
526:

Line 523: total_shipped_quantity2 wsh_delivery_details.shipped_quantity2%TYPE,

519: flow_status_code oe_order_lines_all.flow_status_code%TYPE,
520: total_requested_quantity wsh_delivery_details.requested_quantity%TYPE,
521: total_requested_quantity2 wsh_delivery_details.requested_quantity2%TYPE,
522: total_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,
523: total_shipped_quantity2 wsh_delivery_details.shipped_quantity2%TYPE,
524: -- muom
525: total_om_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE);
526:
527:

Line 525: total_om_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE);

521: total_requested_quantity2 wsh_delivery_details.requested_quantity2%TYPE,
522: total_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE,
523: total_shipped_quantity2 wsh_delivery_details.shipped_quantity2%TYPE,
524: -- muom
525: total_om_shipped_quantity wsh_delivery_details.shipped_quantity%TYPE);
526:
527:
528: END WSH_SHIP_CONFIRM_ACTIONS;