eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_OSP_SHIPMENT_PUB dependencies on OE_ORDER_LINES_ALL

Line 22: G_TRANSACTION_TABLE CONSTANT VARCHAR2(30) := 'OE_ORDER_LINES_ALL';

18: --G_SUBTXN_EXC_ORDER CONSTANT VARCHAR2(30) := 'Ship Replacement';
19: -- Transaction sub type for Exchange order's Return lines
20: --G_SUBTXN_EXC_RETURN CONSTANT VARCHAR2(30) := 'Return for Replacement';
21: -- Source transaction table
22: G_TRANSACTION_TABLE CONSTANT VARCHAR2(30) := 'OE_ORDER_LINES_ALL';
23: G_CSI_T_SOURCE_LINE_REF CONSTANT VARCHAR2(50) := 'AHL_OSP_ORDER_LINES';
24:
25:
26: x_header_rec OE_ORDER_PUB.Header_Rec_Type;

Line 342: oe_order_lines_all oel

338: --mpothuku modified on 14-Sep-2007 to fix the Bug 6398921
339: CURSOR is_oe_item_IB_tracked(c_oe_line_id IN NUMBER, c_oe_org_id IN NUMBER) IS
340: SELECT 1
341: FROM mtl_system_items_b mtl,
342: oe_order_lines_all oel
343: WHERE oel.line_id = c_oe_line_id
344: AND mtl.inventory_item_id = oel.inventory_item_id
345: AND mtl.organization_id = c_oe_org_id
346: AND nvl(mtl.comms_nl_trackable_flag,'N') = 'Y' ;

Line 1152: FROM oe_order_lines_all

1148: AND booked_flag = 'N';
1149:
1150: CURSOR ahl_is_line_deleteable_csr(p_line_id IN NUMBER) IS
1151: SELECT 1
1152: FROM oe_order_lines_all
1153: WHERE line_id = p_line_id
1154: AND shipped_quantity IS NULL
1155: AND booked_flag = 'N';
1156:

Line 2163: FROM AHL_OSP_ORDER_LINES a, OE_ORDER_LINES_ALL oe1,

2159: --Modified by mpothuku on 21-Feb-06 to fix the Perf Bug #4919255
2160: /*
2161: SELECT distinct oe1.line_id, oe1.schedule_ship_date,
2162: oe2.line_id, oe2.schedule_ship_date
2163: FROM AHL_OSP_ORDER_LINES a, OE_ORDER_LINES_ALL oe1,
2164: OE_ORDER_LINES_ALL oe2, AHL_WORKORDERS_OSP_V b
2165: WHERE a.oe_ship_line_id = oe1.line_id (+)
2166: AND a.oe_return_line_id = oe2.line_id (+)
2167: AND a.workorder_id = b.workorder_id

Line 2164: OE_ORDER_LINES_ALL oe2, AHL_WORKORDERS_OSP_V b

2160: /*
2161: SELECT distinct oe1.line_id, oe1.schedule_ship_date,
2162: oe2.line_id, oe2.schedule_ship_date
2163: FROM AHL_OSP_ORDER_LINES a, OE_ORDER_LINES_ALL oe1,
2164: OE_ORDER_LINES_ALL oe2, AHL_WORKORDERS_OSP_V b
2165: WHERE a.oe_ship_line_id = oe1.line_id (+)
2166: AND a.oe_return_line_id = oe2.line_id (+)
2167: AND a.workorder_id = b.workorder_id
2168: AND a.osp_order_id = p_osp_id

Line 2174: OE_ORDER_LINES_ALL oe1,

2170: */
2171: SELECT distinct oe1.line_id, oe1.schedule_ship_date,
2172: oe2.line_id, oe2.schedule_ship_date
2173: FROM AHL_OSP_ORDER_LINES ospl,
2174: OE_ORDER_LINES_ALL oe1,
2175: OE_ORDER_LINES_ALL oe2,
2176: AHL_WORKORDERS wo,
2177: ahl_visit_tasks_b vts
2178: WHERE ospl.oe_ship_line_id = oe1.line_id (+)

Line 2175: OE_ORDER_LINES_ALL oe2,

2171: SELECT distinct oe1.line_id, oe1.schedule_ship_date,
2172: oe2.line_id, oe2.schedule_ship_date
2173: FROM AHL_OSP_ORDER_LINES ospl,
2174: OE_ORDER_LINES_ALL oe1,
2175: OE_ORDER_LINES_ALL oe2,
2176: AHL_WORKORDERS wo,
2177: ahl_visit_tasks_b vts
2178: WHERE ospl.oe_ship_line_id = oe1.line_id (+)
2179: AND ospl.oe_return_line_id = oe2.line_id (+)

Line 2194: FROM AHL_OSP_ORDER_LINES a, OE_ORDER_LINES_ALL oe1,

2190: p_lot_number IN VARCHAR2,
2191: p_inv_item_uom IN VARCHAR2) IS
2192: SELECT oe1.line_id, oe1.schedule_ship_date,
2193: oe2.line_id, oe2.schedule_ship_date
2194: FROM AHL_OSP_ORDER_LINES a, OE_ORDER_LINES_ALL oe1,
2195: OE_ORDER_LINES_ALL oe2
2196: WHERE a.oe_ship_line_id = oe1.line_id (+)
2197: AND a.oe_return_line_id = oe2.line_id (+)
2198: AND a.osp_order_id = p_osp_id

Line 2195: OE_ORDER_LINES_ALL oe2

2191: p_inv_item_uom IN VARCHAR2) IS
2192: SELECT oe1.line_id, oe1.schedule_ship_date,
2193: oe2.line_id, oe2.schedule_ship_date
2194: FROM AHL_OSP_ORDER_LINES a, OE_ORDER_LINES_ALL oe1,
2195: OE_ORDER_LINES_ALL oe2
2196: WHERE a.oe_ship_line_id = oe1.line_id (+)
2197: AND a.oe_return_line_id = oe2.line_id (+)
2198: AND a.osp_order_id = p_osp_id
2199: AND a.inventory_item_id = p_inv_item_id

Line 2365: oe_order_lines_all oel,

2361: decode(csi.instance_id, null, ospl.lot_number, csi.lot_number) lot_number,
2362: ospl.inventory_item_uom ,
2363: ospl.inventory_item_quantity
2364: from ahl_osp_order_lines ospl,
2365: oe_order_lines_all oel,
2366: csi_t_transaction_lines tl,
2367: csi_t_txn_line_details tld,
2368: csi_item_instances csi
2369: where ospl.osp_order_id = p_osp_order_id

Line 2484: FROM oe_order_lines_all

2480: SELECT open_flag,
2481: flow_status_code,
2482: ordered_quantity,
2483: cancelled_quantity
2484: FROM oe_order_lines_all
2485: WHERE line_id = c_line_id;
2486:
2487: l_get_so_line_details get_so_line_details%rowtype;
2488: --mpothuku End

Line 4943: FROM oe_order_lines_all

4939:
4940: -- get oe line details.
4941: CURSOR oe_order_lines_csr (p_oe_line_id IN NUMBER) IS
4942: SELECT inventory_item_id, ordered_quantity, ship_from_org_id, order_quantity_uom
4943: FROM oe_order_lines_all
4944: WHERE line_id = p_oe_line_id;
4945:
4946: -- get instance details.
4947: CURSOR csi_item_instances_csr (p_instance_id IN NUMBER) IS

Line 4964: oe_order_lines_all OEL

4960:
4961: CURSOR get_sold_to_org(p_oe_line_id IN NUMBER) IS
4962: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,
4963: OE_ORDER_HEADERS_ALL OE,
4964: oe_order_lines_all OEL
4965: WHERE OEL.line_id = p_oe_line_id AND
4966: OE.HEADER_ID = OEL.HEADER_ID AND
4967: HZ.CUST_ACCOUNT_ID = OE.SOLD_TO_ORG_ID;
4968:

Line 5507: from ahl_osp_order_lines OSPL, oe_order_lines_all OE

5503: --mpothuku added distinct on 13-Feb-2007 for implementing the Osp Receiving feature.
5504: --If there are multiple services for the same physical item, the following query will return the same return line id multiple
5505: --times, and this leads to calls to Delete_Cancel_Order multiple times leading to a run-time error.
5506: SELECT DISTINCT OSPL.OE_RETURN_LINE_ID, OE.shipped_quantity, OE.booked_flag
5507: from ahl_osp_order_lines OSPL, oe_order_lines_all OE
5508: where OSPL.osp_order_id = p_osp_order_id AND
5509: OSPL.OE_RETURN_LINE_ID IS NOT NULL AND
5510: OE.line_id = OSPL.OE_RETURN_LINE_ID;
5511:

Line 5708: from ahl_osp_order_lines_v OSPL, oe_order_lines_all OE --, AHL_WORKORDERS_OSP_V wo

5704: SELECT OSPL.OE_SHIP_LINE_ID,
5705: ospl.item_instance_id,
5706: --wo.item_instance_id, --Jeli on 01/24/2006 for ER 4746426
5707: NVL(OE.shipped_quantity, 0)
5708: from ahl_osp_order_lines_v OSPL, oe_order_lines_all OE --, AHL_WORKORDERS_OSP_V wo
5709: where OSPL.osp_order_id = p_osp_order_id AND
5710: --ospl.workorder_id = wo.workorder_id AND
5711: OSPL.OE_SHIP_LINE_ID IS NOT NULL AND
5712: OE.line_id = OSPL.OE_SHIP_LINE_ID;

Line 5718: oe_order_lines_all OE,

5714: SELECT OSPL.OE_SHIP_LINE_ID,
5715: decode(wo.workorder_id, null, csii.instance_id, vts.instance_id) item_instance_id,
5716: NVL(OE.shipped_quantity, 0)
5717: from ahl_osp_order_lines OSPL,
5718: oe_order_lines_all OE,
5719: ahl_workorders wo,
5720: ahl_visit_tasks_b vts,
5721: csi_item_instances csii
5722: where OSPL.osp_order_id = p_osp_order_id

Line 5744: oe_order_lines_all OEL

5740:
5741: CURSOR get_sold_to_org(p_oe_line_id IN NUMBER) IS
5742: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,
5743: OE_ORDER_HEADERS_ALL OE,
5744: oe_order_lines_all OEL
5745: WHERE OEL.line_id = p_oe_line_id AND
5746: OE.HEADER_ID = OEL.HEADER_ID AND
5747: HZ.CUST_ACCOUNT_ID = OE.SOLD_TO_ORG_ID;
5748:

Line 6096: select line_id from oe_order_lines_all

6092: WHERE osp.osp_order_id = p_osp_order_id
6093: AND osp.vendor_site_id = cust.vendor_site_id;
6094:
6095: CURSOR get_oe_order_lines(c_oe_header_id IN NUMBER) IS
6096: select line_id from oe_order_lines_all
6097: where header_id = c_oe_header_id;
6098:
6099: l_vendor_cust_dtls ahl_order_vendor_detls_csr%ROWTYPE;
6100: l_oe_header_id NUMBER;

Line 6396: oe_order_lines_all oesh,

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
6400: AND ospl.oe_ship_line_id = oesh.line_id(+)

Line 6397: oe_order_lines_all oert

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
6400: AND ospl.oe_ship_line_id = oesh.line_id(+)
6401: AND ospl.oe_return_line_id = oert.line_id(+);

Line 6608: oe_order_lines_all retl

6604: ospl.oe_return_line_id,
6605: retl.ship_from_org_id receiving_org_id,
6606: ospl.osp_order_id
6607: FROM ahl_osp_order_lines ospl,
6608: oe_order_lines_all retl
6609: WHERE osp_order_line_id = c_osp_order_line_id
6610: AND ospl.oe_return_line_id = retl.line_id(+);
6611:
6612: CURSOR get_ship_line_instance(c_osp_order_line_id IN NUMBER) IS