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 1187: FROM oe_order_lines_all

1183: AND booked_flag = 'N';
1184:
1185: CURSOR ahl_is_line_deleteable_csr(p_line_id IN NUMBER) IS
1186: SELECT 1
1187: FROM oe_order_lines_all
1188: WHERE line_id = p_line_id
1189: AND shipped_quantity IS NULL
1190: AND booked_flag = 'N';
1191:

Line 2198: FROM AHL_OSP_ORDER_LINES a, OE_ORDER_LINES_ALL oe1,

2194: --Modified by mpothuku on 21-Feb-06 to fix the Perf Bug #4919255
2195: /*
2196: SELECT distinct oe1.line_id, oe1.schedule_ship_date,
2197: oe2.line_id, oe2.schedule_ship_date
2198: FROM AHL_OSP_ORDER_LINES a, OE_ORDER_LINES_ALL oe1,
2199: OE_ORDER_LINES_ALL oe2, AHL_WORKORDERS_OSP_V b
2200: WHERE a.oe_ship_line_id = oe1.line_id (+)
2201: AND a.oe_return_line_id = oe2.line_id (+)
2202: AND a.workorder_id = b.workorder_id

Line 2199: OE_ORDER_LINES_ALL oe2, AHL_WORKORDERS_OSP_V b

2195: /*
2196: SELECT distinct oe1.line_id, oe1.schedule_ship_date,
2197: oe2.line_id, oe2.schedule_ship_date
2198: FROM AHL_OSP_ORDER_LINES a, OE_ORDER_LINES_ALL oe1,
2199: OE_ORDER_LINES_ALL oe2, AHL_WORKORDERS_OSP_V b
2200: WHERE a.oe_ship_line_id = oe1.line_id (+)
2201: AND a.oe_return_line_id = oe2.line_id (+)
2202: AND a.workorder_id = b.workorder_id
2203: AND a.osp_order_id = p_osp_id

Line 2209: OE_ORDER_LINES_ALL oe1,

2205: */
2206: SELECT distinct oe1.line_id, oe1.schedule_ship_date,
2207: oe2.line_id, oe2.schedule_ship_date
2208: FROM AHL_OSP_ORDER_LINES ospl,
2209: OE_ORDER_LINES_ALL oe1,
2210: OE_ORDER_LINES_ALL oe2,
2211: AHL_WORKORDERS wo,
2212: ahl_visit_tasks_b vts
2213: WHERE ospl.oe_ship_line_id = oe1.line_id (+)

Line 2210: OE_ORDER_LINES_ALL oe2,

2206: SELECT distinct oe1.line_id, oe1.schedule_ship_date,
2207: oe2.line_id, oe2.schedule_ship_date
2208: FROM AHL_OSP_ORDER_LINES ospl,
2209: OE_ORDER_LINES_ALL oe1,
2210: OE_ORDER_LINES_ALL oe2,
2211: AHL_WORKORDERS wo,
2212: ahl_visit_tasks_b vts
2213: WHERE ospl.oe_ship_line_id = oe1.line_id (+)
2214: AND ospl.oe_return_line_id = oe2.line_id (+)

Line 2229: FROM AHL_OSP_ORDER_LINES a, OE_ORDER_LINES_ALL oe1,

2225: p_lot_number IN VARCHAR2,
2226: p_inv_item_uom IN VARCHAR2) IS
2227: SELECT oe1.line_id, oe1.schedule_ship_date,
2228: oe2.line_id, oe2.schedule_ship_date
2229: FROM AHL_OSP_ORDER_LINES a, OE_ORDER_LINES_ALL oe1,
2230: OE_ORDER_LINES_ALL oe2
2231: WHERE a.oe_ship_line_id = oe1.line_id (+)
2232: AND a.oe_return_line_id = oe2.line_id (+)
2233: AND a.osp_order_id = p_osp_id

Line 2230: OE_ORDER_LINES_ALL oe2

2226: p_inv_item_uom IN VARCHAR2) IS
2227: SELECT oe1.line_id, oe1.schedule_ship_date,
2228: oe2.line_id, oe2.schedule_ship_date
2229: FROM AHL_OSP_ORDER_LINES a, OE_ORDER_LINES_ALL oe1,
2230: OE_ORDER_LINES_ALL oe2
2231: WHERE a.oe_ship_line_id = oe1.line_id (+)
2232: AND a.oe_return_line_id = oe2.line_id (+)
2233: AND a.osp_order_id = p_osp_id
2234: AND a.inventory_item_id = p_inv_item_id

Line 2400: oe_order_lines_all oel,

2396: decode(csi.instance_id, null, ospl.lot_number, csi.lot_number) lot_number,
2397: ospl.inventory_item_uom ,
2398: ospl.inventory_item_quantity
2399: from ahl_osp_order_lines ospl,
2400: oe_order_lines_all oel,
2401: csi_t_transaction_lines tl,
2402: csi_t_txn_line_details tld,
2403: csi_item_instances csi
2404: where ospl.osp_order_id = p_osp_order_id

Line 2519: FROM oe_order_lines_all

2515: SELECT open_flag,
2516: flow_status_code,
2517: ordered_quantity,
2518: cancelled_quantity
2519: FROM oe_order_lines_all
2520: WHERE line_id = c_line_id;
2521:
2522: l_get_so_line_details get_so_line_details%rowtype;
2523: --mpothuku End

Line 4988: FROM oe_order_lines_all

4984:
4985: -- get oe line details.
4986: CURSOR oe_order_lines_csr (p_oe_line_id IN NUMBER) IS
4987: SELECT inventory_item_id, ordered_quantity, ship_from_org_id, order_quantity_uom
4988: FROM oe_order_lines_all
4989: WHERE line_id = p_oe_line_id;
4990:
4991: -- get instance details.
4992: CURSOR csi_item_instances_csr (p_instance_id IN NUMBER) IS

Line 5009: oe_order_lines_all OEL

5005:
5006: CURSOR get_sold_to_org(p_oe_line_id IN NUMBER) IS
5007: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,
5008: OE_ORDER_HEADERS_ALL OE,
5009: oe_order_lines_all OEL
5010: WHERE OEL.line_id = p_oe_line_id AND
5011: OE.HEADER_ID = OEL.HEADER_ID AND
5012: HZ.CUST_ACCOUNT_ID = OE.SOLD_TO_ORG_ID;
5013:

Line 5552: from ahl_osp_order_lines OSPL, oe_order_lines_all OE

5548: --mpothuku added distinct on 13-Feb-2007 for implementing the Osp Receiving feature.
5549: --If there are multiple services for the same physical item, the following query will return the same return line id multiple
5550: --times, and this leads to calls to Delete_Cancel_Order multiple times leading to a run-time error.
5551: SELECT DISTINCT OSPL.OE_RETURN_LINE_ID, OE.shipped_quantity, OE.booked_flag
5552: from ahl_osp_order_lines OSPL, oe_order_lines_all OE
5553: where OSPL.osp_order_id = p_osp_order_id AND
5554: OSPL.OE_RETURN_LINE_ID IS NOT NULL AND
5555: OE.line_id = OSPL.OE_RETURN_LINE_ID;
5556:

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

5749: SELECT OSPL.OE_SHIP_LINE_ID,
5750: ospl.item_instance_id,
5751: --wo.item_instance_id, --Jeli on 01/24/2006 for ER 4746426
5752: NVL(OE.shipped_quantity, 0)
5753: from ahl_osp_order_lines_v OSPL, oe_order_lines_all OE --, AHL_WORKORDERS_OSP_V wo
5754: where OSPL.osp_order_id = p_osp_order_id AND
5755: --ospl.workorder_id = wo.workorder_id AND
5756: OSPL.OE_SHIP_LINE_ID IS NOT NULL AND
5757: OE.line_id = OSPL.OE_SHIP_LINE_ID;

Line 5763: oe_order_lines_all OE,

5759: SELECT OSPL.OE_SHIP_LINE_ID,
5760: decode(wo.workorder_id, null, csii.instance_id, vts.instance_id) item_instance_id,
5761: NVL(OE.shipped_quantity, 0)
5762: from ahl_osp_order_lines OSPL,
5763: oe_order_lines_all OE,
5764: ahl_workorders wo,
5765: ahl_visit_tasks_b vts,
5766: csi_item_instances csii
5767: where OSPL.osp_order_id = p_osp_order_id

Line 5789: oe_order_lines_all OEL

5785:
5786: CURSOR get_sold_to_org(p_oe_line_id IN NUMBER) IS
5787: SELECT HZ.PARTY_ID, HZ.CUST_ACCOUNT_ID from HZ_CUST_ACCOUNTS HZ,
5788: OE_ORDER_HEADERS_ALL OE,
5789: oe_order_lines_all OEL
5790: WHERE OEL.line_id = p_oe_line_id AND
5791: OE.HEADER_ID = OEL.HEADER_ID AND
5792: HZ.CUST_ACCOUNT_ID = OE.SOLD_TO_ORG_ID;
5793:

Line 6141: select line_id from oe_order_lines_all

6137: WHERE osp.osp_order_id = p_osp_order_id
6138: AND osp.vendor_site_id = cust.vendor_site_id;
6139:
6140: CURSOR get_oe_order_lines(c_oe_header_id IN NUMBER) IS
6141: select line_id from oe_order_lines_all
6142: where header_id = c_oe_header_id;
6143:
6144: l_vendor_cust_dtls ahl_order_vendor_detls_csr%ROWTYPE;
6145: l_oe_header_id NUMBER;

Line 6441: oe_order_lines_all oesh,

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

Line 6442: oe_order_lines_all oert

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

Line 6653: oe_order_lines_all retl

6649: ospl.oe_return_line_id,
6650: retl.ship_from_org_id receiving_org_id,
6651: ospl.osp_order_id
6652: FROM ahl_osp_order_lines ospl,
6653: oe_order_lines_all retl
6654: WHERE osp_order_line_id = c_osp_order_line_id
6655: AND ospl.oe_return_line_id = retl.line_id(+);
6656:
6657: CURSOR get_ship_line_instance(c_osp_order_line_id IN NUMBER) IS