APPS.AHL_OSP_SHIPMENT_PUB dependencies on AHL_OSP_ORDERS_B

Line 1603: FROM ahl_osp_orders_b osp,

1599: osp.vendor_contact_id,
1600: osp.osp_order_number,
1601: cust.customer_site_id,
1602: cust.customer_id
1603: FROM ahl_osp_orders_b osp,
1604: ahl_vendor_customer_rels_v cust
1605: WHERE osp.osp_order_id = p_osp_order_id
1606: AND osp.vendor_site_id = cust.vendor_site_id;
1607:

Line 2206: SELECT order_type_code from ahl_osp_orders_b

2202: AND NVL(a.serial_number, 'X') = NVL(p_serial_number, 'X')
2203: AND NVL(a.lot_number, 'X') = NVL(p_lot_number, 'X');
2204:
2205: CURSOR get_osp_order_type_csr(c_osp_id IN NUMBER) IS
2206: SELECT order_type_code from ahl_osp_orders_b
2207: where osp_order_id = c_osp_id;
2208:
2209: CURSOR osp_order_header_csr(p_osp_order_id IN NUMBER) IS
2210: SELECT *

Line 2211: from ahl_osp_orders_b

2207: where osp_order_id = c_osp_id;
2208:
2209: CURSOR osp_order_header_csr(p_osp_order_id IN NUMBER) IS
2210: SELECT *
2211: from ahl_osp_orders_b
2212: where osp_order_id = p_osp_order_id;
2213:
2214: l_osp_header_det osp_order_header_csr%ROWTYPE;
2215:

Line 2500: l_curr_osp_type AHL_OSP_ORDERS_B.order_type_code%type;

2496: /*
2497: mpothuku updated on 06-Mar-06 to remove the ref to l_wo_rec as its not being used
2498: l_wo_rec ahl_osp_wo_csr%ROWTYPE;
2499: */
2500: l_curr_osp_type AHL_OSP_ORDERS_B.order_type_code%type;
2501: l_osp_line_det_type osp_line_details_csr%rowtype;
2502: l_index NUMBER;
2503: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Process_Line_Tbl';
2504: --Jerry added on 11/01/05 in order to fix bug 4580226

Line 4150: FROM ahl_osp_orders_b

4146: ) IS
4147: --
4148: CURSOR ahl_osp_order_id_csr(p_header_id IN NUMBER) IS
4149: SELECT osp_order_id
4150: FROM ahl_osp_orders_b
4151: WHERE oe_header_id = p_header_id;
4152:
4153: --
4154: CURSOR ahl_osp_order_line_csr(p_order_id IN NUMBER) IS

Line 5496: SELECT 'X' from ahl_osp_orders_b where

5492: x_msg_count OUT NOCOPY NUMBER,
5493: x_msg_data OUT NOCOPY VARCHAR2) IS
5494:
5495: CURSOR validate_osp_id_csr (p_osp_order_id IN NUMBER) IS
5496: SELECT 'X' from ahl_osp_orders_b where
5497: OSP_ORDER_ID = p_osp_order_id and
5498: status_code <> AHL_OSP_ORDERS_PVT.G_OSP_CLOSED_STATUS and
5499: ORDER_TYPE_CODE IN (AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE,
5500: AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE);

Line 6067: FROM AHL_OSP_ORDERS_B

6063:
6064: CURSOR get_shipment_det_csr
6065: IS
6066: SELECT OE_HEADER_ID
6067: FROM AHL_OSP_ORDERS_B
6068: WHERE OSP_ORDER_ID = p_osp_order_id;
6069:
6070: CURSOR check_vendor_site_valid_csr
6071: IS

Line 6090: FROM ahl_osp_orders_b osp,

6086: osp.vendor_contact_id,
6087: osp.osp_order_number,
6088: cust.customer_site_id,
6089: cust.customer_id
6090: FROM ahl_osp_orders_b osp,
6091: ahl_vendor_customer_rels_v cust
6092: WHERE osp.osp_order_id = p_osp_order_id
6093: AND osp.vendor_site_id = cust.vendor_site_id;
6094:

Line 6395: ahl_osp_orders_b osph,

6391: ospl.status_code osp_line_status_code,
6392: osph.status_code osp_header_status_code,
6393: osph.order_type_code
6394: FROM ahl_osp_order_lines ospl,
6395: ahl_osp_orders_b osph,
6396: oe_order_lines_all oesh,
6397: oe_order_lines_all oert
6398: WHERE ospl.osp_order_line_id = c_osp_order_line_id
6399: AND ospl.osp_order_id = osph.osp_order_id