APPS.AHL_OSP_SHIPMENT_PUB dependencies on AHL_OSP_ORDERS_B

Line 1638: FROM ahl_osp_orders_b osp,

1634: osp.vendor_contact_id,
1635: osp.osp_order_number,
1636: cust.customer_site_id,
1637: cust.customer_id
1638: FROM ahl_osp_orders_b osp,
1639: ahl_vendor_customer_rels_v cust
1640: WHERE osp.osp_order_id = p_osp_order_id
1641: AND osp.vendor_site_id = cust.vendor_site_id;
1642:

Line 2241: SELECT order_type_code from ahl_osp_orders_b

2237: AND NVL(a.serial_number, 'X') = NVL(p_serial_number, 'X')
2238: AND NVL(a.lot_number, 'X') = NVL(p_lot_number, 'X');
2239:
2240: CURSOR get_osp_order_type_csr(c_osp_id IN NUMBER) IS
2241: SELECT order_type_code from ahl_osp_orders_b
2242: where osp_order_id = c_osp_id;
2243:
2244: CURSOR osp_order_header_csr(p_osp_order_id IN NUMBER) IS
2245: SELECT *

Line 2246: from ahl_osp_orders_b

2242: where osp_order_id = c_osp_id;
2243:
2244: CURSOR osp_order_header_csr(p_osp_order_id IN NUMBER) IS
2245: SELECT *
2246: from ahl_osp_orders_b
2247: where osp_order_id = p_osp_order_id;
2248:
2249: l_osp_header_det osp_order_header_csr%ROWTYPE;
2250:

Line 2535: l_curr_osp_type AHL_OSP_ORDERS_B.order_type_code%type;

2531: /*
2532: mpothuku updated on 06-Mar-06 to remove the ref to l_wo_rec as its not being used
2533: l_wo_rec ahl_osp_wo_csr%ROWTYPE;
2534: */
2535: l_curr_osp_type AHL_OSP_ORDERS_B.order_type_code%type;
2536: l_osp_line_det_type osp_line_details_csr%rowtype;
2537: l_index NUMBER;
2538: L_DEBUG_KEY CONSTANT VARCHAR2(150) := G_LOG_PREFIX || '.Process_Line_Tbl';
2539: --Jerry added on 11/01/05 in order to fix bug 4580226

Line 4134: FROM ahl_osp_orders_b

4130: ) IS
4131: --
4132: CURSOR ahl_osp_order_id_csr(p_header_id IN NUMBER) IS
4133: SELECT osp_order_id
4134: FROM ahl_osp_orders_b
4135: WHERE oe_header_id = p_header_id;
4136:
4137: --
4138: CURSOR ahl_osp_order_line_csr(p_order_id IN NUMBER) IS

Line 5541: SELECT 'X' from ahl_osp_orders_b where

5537: x_msg_count OUT NOCOPY NUMBER,
5538: x_msg_data OUT NOCOPY VARCHAR2) IS
5539:
5540: CURSOR validate_osp_id_csr (p_osp_order_id IN NUMBER) IS
5541: SELECT 'X' from ahl_osp_orders_b where
5542: OSP_ORDER_ID = p_osp_order_id and
5543: status_code <> AHL_OSP_ORDERS_PVT.G_OSP_CLOSED_STATUS and
5544: ORDER_TYPE_CODE IN (AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_SERVICE,
5545: AHL_OSP_ORDERS_PVT.G_OSP_ORDER_TYPE_EXCHANGE);

Line 6112: FROM AHL_OSP_ORDERS_B

6108:
6109: CURSOR get_shipment_det_csr
6110: IS
6111: SELECT OE_HEADER_ID
6112: FROM AHL_OSP_ORDERS_B
6113: WHERE OSP_ORDER_ID = p_osp_order_id;
6114:
6115: CURSOR check_vendor_site_valid_csr
6116: IS

Line 6135: FROM ahl_osp_orders_b osp,

6131: osp.vendor_contact_id,
6132: osp.osp_order_number,
6133: cust.customer_site_id,
6134: cust.customer_id
6135: FROM ahl_osp_orders_b osp,
6136: ahl_vendor_customer_rels_v cust
6137: WHERE osp.osp_order_id = p_osp_order_id
6138: AND osp.vendor_site_id = cust.vendor_site_id;
6139:

Line 6440: ahl_osp_orders_b osph,

6436: ospl.status_code osp_line_status_code,
6437: osph.status_code osp_header_status_code,
6438: osph.order_type_code
6439: FROM ahl_osp_order_lines ospl,
6440: ahl_osp_orders_b osph,
6441: oe_order_lines_all oesh,
6442: oe_order_lines_all oert
6443: WHERE ospl.osp_order_line_id = c_osp_order_line_id
6444: AND ospl.osp_order_id = osph.osp_order_id