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 150: from oe_order_lines_all

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

Line 404: FROM oe_order_lines

400: l_hold_result VARCHAR2(30);
401:
402: CURSOR c_billto_lines IS
403: SELECT line_id
404: FROM oe_order_lines
405: WHERE header_id = p_header_id
406: AND invoice_to_org_id = nvl(p_invoice_to_org_id, invoice_to_org_id);
407:
408: --

Line 542: FROM oe_order_lines

538: l_apply_hold VARCHAR2(1) := 'N';
539:
540: CURSOR c_billto_lines IS
541: SELECT line_id, line_number
542: FROM oe_order_lines
543: WHERE header_id = p_header_id
544: AND invoice_to_org_id = p_invoice_to_org_id
545: AND open_flag = 'Y';
546:

Line 708: FROM oe_order_lines

704: l_return_status VARCHAR2(30) := NULL ;
705:
706: CURSOR C_credit_check_lines IS
707: SELECT invoice_to_org_id
708: FROM oe_order_lines
709: where header_id = l_header_rec.header_id
710: group by invoice_to_org_id;
711:
712: --

Line 1828: OE_ORDER_LINES OOL,

1824: SELECT COUNT(*)
1825: INTO l_ship_rule_count
1826: FROM WF_ITEM_ACTIVITY_STATUSES WIAS,
1827: WF_PROCESS_ACTIVITIES WPA,
1828: OE_ORDER_LINES OOL,
1829: OE_ORDER_HEADERS OOH
1830: WHERE WIAS.ITEM_TYPE = 'OEOL'
1831: AND WIAS.ACTIVITY_STATUS = 'COMPLETE'
1832: AND WIAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID

Line 1846: FROM OE_ORDER_LINES OOL

1842: FROM OE_ORDER_HEADERS_ALL OOH
1843: WHERE OOH.HEADER_ID = p_header_id
1844: AND EXISTS
1845: (SELECT 'Line Shipped'
1846: FROM OE_ORDER_LINES OOL
1847: WHERE OOL.HEADER_ID = OOH.HEADER_ID
1848: AND NVL(OOL.SHIPPED_QUANTITY, 0) > 0
1849: AND LINE_CATEGORY_CODE <> 'RETURN' ); -- bug 7676011
1850:

Line 1871: OE_ORDER_LINES OOL,

1867: SELECT COUNT(*) + l_ship_rule_count
1868: INTO l_ship_rule_count
1869: FROM WF_ITEM_ACTIVITY_STATUSES WIAS,
1870: WF_PROCESS_ACTIVITIES WPA,
1871: OE_ORDER_LINES OOL,
1872: OE_ORDER_HEADERS OOH
1873: WHERE WIAS.ITEM_TYPE = 'OEOL'
1874: AND WPA.ACTIVITY_NAME = 'PURCHASE RELEASE ELIGIBLE'
1875: AND WPA.INSTANCE_ID = WIAS.PROCESS_ACTIVITY

Line 1891: FROM OE_ORDER_LINES OOL, OE_DROP_SHIP_SOURCES ODSS

1887: WHERE OOH.PAYMENT_TYPE_CODE = 'CREDIT_CARD'
1888: AND OOH.HEADER_ID = p_header_id
1889: AND EXISTS
1890: (SELECT 'Purchase Released'
1891: FROM OE_ORDER_LINES OOL, OE_DROP_SHIP_SOURCES ODSS
1892: WHERE OOL.HEADER_ID = OOH.HEADER_ID
1893: AND ODSS.LINE_ID = OOL.LINE_ID
1894: AND ODSS.HEADER_id = OOL.HEADER_ID);
1895: EXCEPTION

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

5323: AND header_id = p_header_id;
5324:
5325: --R12 CC Encryption
5326:
5327: --bug3225795 changing the following cursor to look into oe_order_lines_all
5328: -- get those lines paid with payments other than the main one.
5329: CURSOR lines_cur(p_header_id IN NUMBER) IS
5330: SELECT line_id
5331: FROM oe_order_lines_all

Line 5331: FROM oe_order_lines_all

5327: --bug3225795 changing the following cursor to look into oe_order_lines_all
5328: -- get those lines paid with payments other than the main one.
5329: CURSOR lines_cur(p_header_id IN NUMBER) IS
5330: SELECT line_id
5331: FROM oe_order_lines_all
5332: WHERE header_id = p_header_id
5333: AND payment_type_code IS NOT NULL
5334: AND payment_type_code <> 'COMMITMENT'
5335: AND nvl(invoice_interface_status_code,'NO') <> 'YES';

Line 5340: FROM oe_order_lines_all

5336:
5337: --bug3225795 New cursor to fetch all the invoiced lines given the header_id
5338: CURSOR inv_lines_cur(p_header_id IN NUMBER) IS
5339: SELECT line_id
5340: FROM oe_order_lines_all
5341: WHERE header_id = p_header_id
5342: AND nvl(invoice_interface_status_code,'NO') = 'YES';
5343:
5344:

Line 5562: FROM oe_order_lines_all

5558: --bug3225795 start
5559: BEGIN
5560: SELECT invoice_interface_status_code
5561: INTO l_inv_interface_status_code
5562: FROM oe_order_lines_all
5563: WHERE line_id = l_payments_tbl(I).line_id;
5564: EXCEPTION
5565: WHEN NO_DATA_FOUND THEN
5566: null;

Line 5727: FROM oe_order_lines_all

5723: IF l_payments_tbl(I).line_id IS NOT NULL THEN
5724: BEGIN
5725: SELECT invoice_to_org_id, ship_to_org_id
5726: INTO l_invoice_to_org_id,l_ship_to_org_id
5727: FROM oe_order_lines_all
5728: WHERE line_id = l_payments_tbl(I).line_id;
5729: EXCEPTION WHEN NO_DATA_FOUND THEN
5730: null;
5731: END;

Line 5916: FROM oe_order_lines_all

5912: IF l_payments_tbl(I).line_id IS NOT NULL THEN
5913: BEGIN
5914: SELECT invoice_to_org_id, ship_to_org_id
5915: INTO l_invoice_to_org_id,l_ship_to_org_id
5916: FROM oe_order_lines_all
5917: WHERE line_id = l_payments_tbl(I).line_id;
5918: EXCEPTION WHEN NO_DATA_FOUND THEN
5919: null;
5920: END;

Line 5969: FROM oe_order_lines_all

5965: AND payment_type_code <> 'COMMITMENT';
5966:
5967: SELECT invoice_to_org_id, ship_from_org_id, ship_to_org_id
5968: INTO x_invoice_to_org_id, x_ship_from_org_id, x_ship_to_org_id
5969: FROM oe_order_lines_all
5970: WHERE line_id = l_payments_tbl(I).line_id;
5971: EXCEPTION WHEN NO_DATA_FOUND THEN
5972: IF l_debug_level > 0 THEN
5973: oe_debug_pub.add('Trxn extension id....'||nvl(l_trxn_extension_id,'0'));

Line 7259: FROM oe_order_lines_all

7255: END IF;
7256: BEGIN
7257: SELECT nvl(invoice_interface_status_code,'NO')
7258: INTO l_inv_interface_status_code
7259: FROM oe_order_lines_all
7260: WHERE line_id = p_line_id;
7261: EXCEPTION WHEN NO_DATA_FOUND THEN
7262: l_inv_interface_status_code:='NO';
7263: END;

Line 7401: FROM oe_order_lines_all ool

7397: INTO l_tax_value
7398: , l_extended_price
7399: , l_header_id
7400: , l_payment_term_id
7401: FROM oe_order_lines_all ool
7402: WHERE ool.line_id = p_line_id
7403: -- AND ool.open_flag = 'Y' --bug3225795
7404: AND ool.line_category_code <> 'RETURN'
7405: AND NVL(ool.service_bill_option_code,'FBOM') <> 'FBOKS' -- sol_ord_er #16014165

Line 7436: FROM mtl_system_items mti, oe_order_lines_all ool

7432: WHERE op.line_id = p_line_id
7433: AND op.header_id = p_header_id
7434: AND NOT EXISTS
7435: (SELECT 'Non Invoiceable Item Line'
7436: FROM mtl_system_items mti, oe_order_lines_all ool
7437: WHERE ool.line_id = op.line_id
7438: AND mti.inventory_item_id = ool.inventory_item_id
7439: AND mti.organization_id = nvl(ool.ship_from_org_id,
7440: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 7447: FROM oe_order_lines_all ool

7443: ELSE
7444: SELECT --nvl(ool.Ordered_Quantity,0) *(ool.unit_selling_price) -- sol_ord_er #16014165
7445: nvl(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0) * ool.unit_selling_price)
7446: INTO l_commitment_applied
7447: FROM oe_order_lines_all ool
7448: WHERE ool.line_id = p_line_id
7449: AND ool.commitment_id is not null
7450: --AND ool.open_flag = 'Y'
7451: --AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795

Line 7491: OE_ORDER_LINES_ALL L

7487: ,OE_ORDER_UTIL.G_Precision ) --8241416
7488: )
7489: INTO l_charge_amount
7490: FROM OE_PRICE_ADJUSTMENTS P,
7491: OE_ORDER_LINES_ALL L
7492: WHERE P.LINE_ID = p_line_id
7493: AND P.LINE_ID = L.LINE_ID
7494: AND NVL(L.SERVICE_BILL_OPTION_CODE,'FBOM') = 'FBOM' -- sol_ord_er #16014165
7495: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'

Line 7677: FROM oe_order_lines_all ool

7673: INTO l_tax_value
7674: , l_extended_price
7675: , l_header_id
7676: , l_payment_term_id
7677: FROM oe_order_lines_all ool
7678: WHERE ool.line_id = p_line_id
7679: -- AND ool.open_flag = 'Y'
7680: AND ool.line_category_code <> 'RETURN'
7681: AND NVL(ool.service_bill_option_code,'FBOM') <> 'FBOKS' -- sol_ord_er #16014165

Line 7711: FROM mtl_system_items mti, oe_order_lines_all ool

7707: WHERE op.line_id = p_line_id
7708: AND op.header_id = p_header_id
7709: AND NOT EXISTS
7710: (SELECT 'Non Invoiceable Item Line'
7711: FROM mtl_system_items mti, oe_order_lines_all ool
7712: WHERE ool.line_id = op.line_id
7713: AND mti.inventory_item_id = ool.inventory_item_id
7714: AND mti.organization_id = nvl(ool.ship_from_org_id,
7715: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 7722: FROM oe_order_lines_all ool

7718: ELSE
7719: SELECT --nvl(ool.Ordered_Quantity,0) *(ool.unit_selling_price) -- sol_ord_er #16014165
7720: nvl(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0) * ool.unit_selling_price)
7721: INTO l_commitment_applied
7722: FROM oe_order_lines_all ool
7723: WHERE ool.line_id = p_line_id
7724: AND ool.commitment_id is not null
7725: AND ool.line_category_code <> 'RETURN'
7726: AND NVL(ool.service_bill_option_code,'FBOM') <> 'FBOKS' -- sol_ord_er #16014165

Line 7760: OE_ORDER_LINES_ALL L

7756: )
7757: )
7758: INTO l_charge_amount
7759: FROM OE_PRICE_ADJUSTMENTS P,
7760: OE_ORDER_LINES_ALL L
7761: WHERE P.LINE_ID = p_line_id
7762: AND P.LINE_ID = L.LINE_ID
7763: AND NVL(L.SERVICE_BILL_OPTION_CODE,'FBOM') = 'FBOM' -- sol_ord_er #16014165
7764: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'

Line 7915: FROM oe_order_lines_all ool

7911: ,SUM(ROUND(NVL(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0)*(ool.unit_selling_price)),OE_ORDER_UTIL.G_Precision))
7912: INTO
7913: l_tax_total
7914: , l_order_total
7915: FROM oe_order_lines_all ool
7916: WHERE ool.header_id = p_header_id
7917: AND ool.open_flag = 'Y'
7918: AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795
7919: AND ool.line_category_code <> 'RETURN'

Line 7935: oe_order_lines_all ool --bug3225795

7931: -- Select the committment applied amount if Commitment Sequencing "On"
7932: SELECT SUM(ROUND(nvl(op.commitment_applied_amount,0),OE_ORDER_UTIL.G_Precision))
7933: INTO l_commitment_total
7934: FROM oe_payments op,
7935: oe_order_lines_all ool --bug3225795
7936: WHERE op.header_id = p_header_id
7937: AND ool.header_id = p_header_id --bug3225795
7938: AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795
7939: AND ool.line_id=op.line_id --bug3225795

Line 7942: FROM mtl_system_items mti, oe_order_lines_all ool

7938: AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795
7939: AND ool.line_id=op.line_id --bug3225795
7940: AND NOT EXISTS
7941: (SELECT 'Non Invoiceable Item Line'
7942: FROM mtl_system_items mti, oe_order_lines_all ool
7943: WHERE ool.line_id = op.line_id
7944: AND mti.inventory_item_id = ool.inventory_item_id
7945: AND mti.organization_id = nvl(ool.ship_from_org_id,
7946: oe_sys_parameters.value('MASTER_ORGANIZATION_ID', ool.org_id))

Line 7956: FROM oe_order_lines_all ool

7952: -- sol_ord_er #16014165
7953: -- First Period Bill Amt should not consider ordered quantity
7954: SUM(ROUND(NVL(ool.service_first_period_amount,nvl(ool.Ordered_Quantity,0)*(ool.unit_selling_price)),OE_ORDER_UTIL.G_Precision))
7955: INTO l_commitment_total
7956: FROM oe_order_lines_all ool
7957: WHERE ool.header_id = p_header_id
7958: AND ool.commitment_id is not null
7959: AND ool.open_flag = 'Y'
7960: AND nvl(ool.invoice_interface_status_code,'NO') <> 'YES' --bug3225795

Line 7998: OE_ORDER_LINES_ALL L

7994: ),OE_ORDER_UTIL.G_Precision)
7995: )
7996: INTO l_chgs_w_line_id
7997: FROM OE_PRICE_ADJUSTMENTS P,
7998: OE_ORDER_LINES_ALL L
7999: WHERE P.HEADER_ID = p_header_id
8000: AND P.LINE_ID = L.LINE_ID
8001: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
8002: AND P.APPLIED_FLAG = 'Y'

Line 8674: from oe_order_lines_all

8670: l_shipment_number,
8671: l_option_number,
8672: l_component_number,
8673: l_service_number
8674: from oe_order_lines_all
8675: where line_id = p_line_id;
8676:
8677:
8678: end;