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.OE_VERIFY_PAYMENT_PUB dependencies on OE_ORDER_LINES

Line 149: from oe_order_lines_all

145: l_shipment_number,
146: l_option_number,
147: l_component_number,
148: l_service_number
149: from oe_order_lines_all
150: where line_id = p_line_id;
151:
152:
153: end;

Line 338: FROM oe_order_lines

334: l_hold_result VARCHAR2(30);
335:
336: CURSOR c_billto_lines IS
337: SELECT line_id
338: FROM oe_order_lines
339: WHERE header_id = p_header_id
340: AND invoice_to_org_id = nvl(p_invoice_to_org_id, invoice_to_org_id);
341:
342: --

Line 476: FROM oe_order_lines

472: l_apply_hold VARCHAR2(1) := 'N';
473:
474: CURSOR c_billto_lines IS
475: SELECT line_id, line_number
476: FROM oe_order_lines
477: WHERE header_id = p_header_id
478: AND invoice_to_org_id = p_invoice_to_org_id
479: AND open_flag = 'Y';
480:

Line 642: FROM oe_order_lines

638: l_return_status VARCHAR2(30) := NULL ;
639:
640: CURSOR C_credit_check_lines IS
641: SELECT invoice_to_org_id
642: FROM oe_order_lines
643: where header_id = l_header_rec.header_id
644: group by invoice_to_org_id;
645:
646: --

Line 1756: OE_ORDER_LINES OOL,

1752: SELECT COUNT(*)
1753: INTO l_ship_rule_count
1754: FROM WF_ITEM_ACTIVITY_STATUSES WIAS,
1755: WF_PROCESS_ACTIVITIES WPA,
1756: OE_ORDER_LINES OOL,
1757: OE_ORDER_HEADERS OOH
1758: WHERE WIAS.ITEM_TYPE = 'OEOL'
1759: AND WIAS.ACTIVITY_STATUS = 'COMPLETE'
1760: AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID

Line 1774: FROM OE_ORDER_LINES OOL

1770: FROM OE_ORDER_HEADERS_ALL OOH
1771: WHERE OOH.HEADER_ID = p_header_id
1772: AND EXISTS
1773: (SELECT 'Line Shipped'
1774: FROM OE_ORDER_LINES OOL
1775: WHERE OOL.HEADER_ID = OOH.HEADER_ID
1776: AND NVL(OOL.SHIPPED_QUANTITY, 0) > 0);
1777:
1778: EXCEPTION

Line 1798: OE_ORDER_LINES OOL,

1794: SELECT COUNT(*) + l_ship_rule_count
1795: INTO l_ship_rule_count
1796: FROM WF_ITEM_ACTIVITY_STATUSES WIAS,
1797: WF_PROCESS_ACTIVITIES WPA,
1798: OE_ORDER_LINES OOL,
1799: OE_ORDER_HEADERS OOH
1800: WHERE WIAS.ITEM_TYPE = 'OEOL'
1801: AND WPA.ACTIVITY_NAME = 'PURCHASE RELEASE ELIGIBLE'
1802: AND WPA.INSTANCE_ID = WIAS.PROCESS_ACTIVITY

Line 1818: FROM OE_ORDER_LINES OOL, OE_DROP_SHIP_SOURCES ODSS

1814: WHERE OOH.PAYMENT_TYPE_CODE = 'CREDIT_CARD'
1815: AND OOH.HEADER_ID = p_header_id
1816: AND EXISTS
1817: (SELECT 'Purchase Released'
1818: FROM OE_ORDER_LINES OOL, OE_DROP_SHIP_SOURCES ODSS
1819: WHERE OOL.HEADER_ID = OOH.HEADER_ID
1820: AND ODSS.LINE_ID = OOL.LINE_ID
1821: AND ODSS.HEADER_id = OOL.HEADER_ID);
1822: EXCEPTION

Line 5243: --bug3225795 changing the following cursor to look into oe_order_lines_all

5239: AND header_id = p_header_id;
5240:
5241: --R12 CC Encryption
5242:
5243: --bug3225795 changing the following cursor to look into oe_order_lines_all
5244: -- get those lines paid with payments other than the main one.
5245: CURSOR lines_cur(p_header_id IN NUMBER) IS
5246: SELECT line_id
5247: FROM oe_order_lines_all

Line 5247: FROM oe_order_lines_all

5243: --bug3225795 changing the following cursor to look into oe_order_lines_all
5244: -- get those lines paid with payments other than the main one.
5245: CURSOR lines_cur(p_header_id IN NUMBER) IS
5246: SELECT line_id
5247: FROM oe_order_lines_all
5248: WHERE header_id = p_header_id
5249: AND payment_type_code IS NOT NULL
5250: AND payment_type_code <> 'COMMITMENT'
5251: AND nvl(invoice_interface_status_code,'NO') <> 'YES';

Line 5256: FROM oe_order_lines_all

5252:
5253: --bug3225795 New cursor to fetch all the invoiced lines given the header_id
5254: CURSOR inv_lines_cur(p_header_id IN NUMBER) IS
5255: SELECT line_id
5256: FROM oe_order_lines_all
5257: WHERE header_id = p_header_id
5258: AND nvl(invoice_interface_status_code,'NO') = 'YES';
5259:
5260:

Line 5408: FROM oe_order_lines_all

5404: --bug3225795 start
5405: BEGIN
5406: SELECT invoice_interface_status_code
5407: INTO l_inv_interface_status_code
5408: FROM oe_order_lines_all
5409: WHERE line_id = l_payments_tbl(I).line_id;
5410: EXCEPTION
5411: WHEN NO_DATA_FOUND THEN
5412: null;

Line 5573: FROM oe_order_lines_all

5569: IF l_payments_tbl(I).line_id IS NOT NULL THEN
5570: BEGIN
5571: SELECT invoice_to_org_id, ship_to_org_id
5572: INTO l_invoice_to_org_id,l_ship_to_org_id
5573: FROM oe_order_lines_all
5574: WHERE line_id = l_payments_tbl(I).line_id;
5575: EXCEPTION WHEN NO_DATA_FOUND THEN
5576: null;
5577: END;

Line 5752: FROM oe_order_lines_all

5748: IF l_payments_tbl(I).line_id IS NOT NULL THEN
5749: BEGIN
5750: SELECT invoice_to_org_id, ship_to_org_id
5751: INTO l_invoice_to_org_id,l_ship_to_org_id
5752: FROM oe_order_lines_all
5753: WHERE line_id = l_payments_tbl(I).line_id;
5754: EXCEPTION WHEN NO_DATA_FOUND THEN
5755: null;
5756: END;

Line 5805: FROM oe_order_lines_all

5801: AND payment_type_code <> 'COMMITMENT';
5802:
5803: SELECT invoice_to_org_id, ship_from_org_id, ship_to_org_id
5804: INTO x_invoice_to_org_id, x_ship_from_org_id, x_ship_to_org_id
5805: FROM oe_order_lines_all
5806: WHERE line_id = l_payments_tbl(I).line_id;
5807: EXCEPTION WHEN NO_DATA_FOUND THEN
5808: IF l_debug_level > 0 THEN
5809: oe_debug_pub.add('Trxn extension id....'||nvl(l_trxn_extension_id,'0'));

Line 6777: FROM oe_order_lines_all ool

6773: INTO l_tax_value
6774: , l_extended_price
6775: , l_header_id
6776: , l_payment_term_id
6777: FROM oe_order_lines_all ool
6778: WHERE ool.line_id = p_line_id
6779: -- AND ool.open_flag = 'Y' --bug3225795
6780: AND ool.line_category_code <> 'RETURN'
6781: AND NOT EXISTS

Line 6811: FROM mtl_system_items mti, oe_order_lines_all ool

6807: WHERE op.line_id = p_line_id
6808: AND op.header_id = p_header_id
6809: AND NOT EXISTS
6810: (SELECT 'Non Invoiceable Item Line'
6811: FROM mtl_system_items mti, oe_order_lines_all ool
6812: WHERE ool.line_id = op.line_id
6813: AND mti.inventory_item_id = ool.inventory_item_id
6814: AND mti.organization_id = nvl(ool.ship_from_org_id,
6815: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 6821: FROM oe_order_lines_all ool

6817: OR mti.invoice_enabled_flag = 'N'));
6818: ELSE
6819: SELECT nvl(ool.Ordered_Quantity,0) *(ool.unit_selling_price)
6820: INTO l_commitment_applied
6821: FROM oe_order_lines_all ool
6822: WHERE ool.line_id = p_line_id
6823: AND ool.commitment_id is not null
6824: --AND ool.open_flag = 'Y'
6825: --AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795

Line 6861: OE_ORDER_LINES_ALL L

6857: )
6858: )
6859: INTO l_charge_amount
6860: FROM OE_PRICE_ADJUSTMENTS P,
6861: OE_ORDER_LINES_ALL L
6862: WHERE P.LINE_ID = p_line_id
6863: AND P.LINE_ID = L.LINE_ID
6864: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
6865: AND P.APPLIED_FLAG = 'Y'

Line 7045: FROM oe_order_lines_all ool

7041: INTO l_tax_value
7042: , l_extended_price
7043: , l_header_id
7044: , l_payment_term_id
7045: FROM oe_order_lines_all ool
7046: WHERE ool.line_id = p_line_id
7047: -- AND ool.open_flag = 'Y'
7048: AND ool.line_category_code <> 'RETURN'
7049: AND NOT EXISTS

Line 7078: FROM mtl_system_items mti, oe_order_lines_all ool

7074: WHERE op.line_id = p_line_id
7075: AND op.header_id = p_header_id
7076: AND NOT EXISTS
7077: (SELECT 'Non Invoiceable Item Line'
7078: FROM mtl_system_items mti, oe_order_lines_all ool
7079: WHERE ool.line_id = op.line_id
7080: AND mti.inventory_item_id = ool.inventory_item_id
7081: AND mti.organization_id = nvl(ool.ship_from_org_id,
7082: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 7088: FROM oe_order_lines_all ool

7084: OR mti.invoice_enabled_flag = 'N'));
7085: ELSE
7086: SELECT nvl(ool.Ordered_Quantity,0) *(ool.unit_selling_price)
7087: INTO l_commitment_applied
7088: FROM oe_order_lines_all ool
7089: WHERE ool.line_id = p_line_id
7090: AND ool.commitment_id is not null
7091: AND ool.line_category_code <> 'RETURN'
7092: AND NOT EXISTS

Line 7125: OE_ORDER_LINES_ALL L

7121: )
7122: )
7123: INTO l_charge_amount
7124: FROM OE_PRICE_ADJUSTMENTS P,
7125: OE_ORDER_LINES_ALL L
7126: WHERE P.LINE_ID = p_line_id
7127: AND P.LINE_ID = L.LINE_ID
7128: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
7129: AND P.APPLIED_FLAG = 'Y';

Line 7277: FROM oe_order_lines_all ool

7273: *(ool.unit_selling_price),OE_ORDER_UTIL.G_Precision))
7274: INTO
7275: l_tax_total
7276: , l_order_total
7277: FROM oe_order_lines_all ool
7278: WHERE ool.header_id = p_header_id
7279: AND ool.open_flag = 'Y'
7280: AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795
7281: AND ool.line_category_code <> 'RETURN'

Line 7296: oe_order_lines_all ool --bug3225795

7292: -- Select the committment applied amount if Commitment Sequencing "On"
7293: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0),OE_ORDER_UTIL.G_Precision))
7294: INTO l_commitment_total
7295: FROM oe_payments op,
7296: oe_order_lines_all ool --bug3225795
7297: WHERE op.header_id = p_header_id
7298: AND ool.header_id = p_header_id --bug3225795
7299: AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795
7300: AND ool.line_id=op.line_id --bug3225795

Line 7303: FROM mtl_system_items mti, oe_order_lines_all ool

7299: AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795
7300: AND ool.line_id=op.line_id --bug3225795
7301: AND NOT EXISTS
7302: (SELECT 'Non Invoiceable Item Line'
7303: FROM mtl_system_items mti, oe_order_lines_all ool
7304: WHERE ool.line_id = op.line_id
7305: AND mti.inventory_item_id = ool.inventory_item_id
7306: AND mti.organization_id = nvl(ool.ship_from_org_id,
7307: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 7314: FROM oe_order_lines_all ool

7310: ELSE
7311: -- Select the Outbound Extended Price for lines that have committment
7312: SELECT SUM(ROUND(nvl(ool.Ordered_Quantity,0) * (ool.unit_selling_price),OE_ORDER_UTIL.G_Precision))
7313: INTO l_commitment_total
7314: FROM oe_order_lines_all ool
7315: WHERE ool.header_id = p_header_id
7316: AND ool.commitment_id is not null
7317: AND ool.open_flag = 'Y'
7318: AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795

Line 7355: OE_ORDER_LINES_ALL L

7351: ),OE_ORDER_UTIL.G_Precision)
7352: )
7353: INTO l_chgs_w_line_id
7354: FROM OE_PRICE_ADJUSTMENTS P,
7355: OE_ORDER_LINES_ALL L
7356: WHERE P.HEADER_ID = p_header_id
7357: AND P.LINE_ID = L.LINE_ID
7358: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
7359: AND P.APPLIED_FLAG = 'Y'

Line 8030: from oe_order_lines_all

8026: l_shipment_number,
8027: l_option_number,
8028: l_component_number,
8029: l_service_number
8030: from oe_order_lines_all
8031: where line_id = p_line_id;
8032:
8033:
8034: end;