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_INVOICE_PUB dependencies on OE_ORDER_HEADERS_ALL

Line 468: Update oe_order_headers_all

464: IF l_debug_level > 0 THEN
465: oe_debug_pub.add( 'Inside Update Header Flow Status');
466: END IF;
467:
468: Update oe_order_headers_all
469: Set flow_status_code = p_flow_status_code
470: , last_update_date = sysdate --BUG#9539541
471: , last_updated_by = NVL(oe_standard_wf.g_user_id, fnd_global.user_id) --BUG#9539541
472: Where header_id = p_header_id;

Line 1090: oe_order_headers_all oh /* MOAC SQL CHANGE */

1086: IF l_inv_cust_trx_type_id = 0 THEN
1087: SELECT NVL(ot.cust_trx_type_id,0)
1088: INTO l_inv_cust_trx_type_id
1089: FROM oe_order_types_v ot,
1090: oe_order_headers_all oh /* MOAC SQL CHANGE */
1091: WHERE ot.order_type_id = oh.order_type_id
1092: AND oh.header_id = (SELECT header_id
1093: FROM oe_order_lines_all /* MOAC SQL CHANGE */
1094: WHERE line_id = p_line_rec.reference_line_id);

Line 1135: oe_order_headers_all oh /* MOAC SQL CHANGE */

1131: -- Get cust_trx_type_id from order type
1132: SELECT NVL(ot.cust_trx_type_id, 0)
1133: INTO l_inv_cust_trx_type_id
1134: FROM oe_order_types_v ot,
1135: oe_order_headers_all oh /* MOAC SQL CHANGE */
1136: WHERE ot.order_type_id = oh.order_type_id
1137: AND oh.header_id = p_line_rec.header_id;
1138: END IF;
1139: IF l_debug_level > 0 THEN

Line 1626: oe_order_headers_all oh /* MOAC SQL CHANGE */

1622: ot.non_delivery_invoice_source_id)
1623: INTO l_invoice_source_id
1624: FROM oe_line_types_v lt,
1625: oe_order_types_v ot,
1626: oe_order_headers_all oh /* MOAC SQL CHANGE */
1627: WHERE lt.line_type_id = p_line_rec.line_type_id
1628: AND ot.order_type_id = oh.order_type_id
1629: AND oh.header_id = p_line_rec.header_id;
1630: IF l_invoice_source_id IS NOT NULL THEN

Line 1652: oe_order_headers_all oh /* MOAC SQL CHANGE */

1648: ot.invoice_source_id)
1649: INTO l_invoice_source_id
1650: FROM oe_line_types_v lt,
1651: oe_order_types_v ot,
1652: oe_order_headers_all oh /* MOAC SQL CHANGE */
1653: WHERE lt.line_type_id = p_line_rec.line_type_id
1654: AND ot.order_type_id = oh.order_type_id
1655: AND oh.header_id = p_line_rec.header_id;
1656: IF l_invoice_source_id IS NOT NULL THEN

Line 1757: oe_order_headers_all oh /* MOAC SQL CHANGE */

1753: IF l_cust_trx_type_id = 0 THEN
1754: SELECT NVL(ot.cust_trx_type_id, 0)
1755: INTO l_cust_trx_type_id
1756: FROM oe_order_types_v ot,
1757: oe_order_headers_all oh /* MOAC SQL CHANGE */
1758: WHERE ot.order_type_id = oh.order_type_id
1759: AND oh.header_id = p_line_rec.header_id;
1760: IF l_debug_level > 0 THEN
1761: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM ORDER TYPE : '||L_CUST_TRX_TYPE_ID , 5 ) ;

Line 1817: oe_order_headers_all oh /* MOAC SQL CHANGE */

1813: IF l_inv_cust_trx_type_id = 0 THEN
1814: SELECT NVL(ot.cust_trx_type_id,0)
1815: INTO l_inv_cust_trx_type_id
1816: FROM oe_order_types_v ot,
1817: oe_order_headers_all oh /* MOAC SQL CHANGE */
1818: WHERE ot.order_type_id = oh.order_type_id
1819: AND oh.header_id = p_line_rec.header_id;
1820: IF l_debug_level > 0 THEN
1821: oe_debug_pub.add( 'CUSTOMER TRANSACTION TYPE ID FROM ORDER TYPE: '||L_INV_CUST_TRX_TYPE_ID , 5 ) ;

Line 1884: oe_order_headers_all oh /* MOAC SQL CHANGE */

1880: INTO l_accting_credit_method_code,
1881: l_invcing_credit_method_code
1882: FROM oe_line_types_v lt,
1883: oe_order_types_v ot,
1884: oe_order_headers_all oh /* MOAC SQL CHANGE */
1885: WHERE lt.line_type_id = p_line_rec.line_type_id
1886: AND ot.order_type_id = oh.order_type_id
1887: AND oh.header_id = p_line_rec.header_id;
1888: x_accting_credit_method_code := l_accting_credit_method_code;

Line 5120: oe_order_headers_all ooh, /* MOAC SQL CHANGE */

5116: , ool.line_id
5117: , ooh.order_number
5118: , ott.name order_type
5119: FROM oe_order_lines ool,
5120: oe_order_headers_all ooh, /* MOAC SQL CHANGE */
5121: oe_transaction_types_tl ott
5122: WHERE ool.line_id = c_line_id
5123: AND ooh.header_id = ool.header_id
5124: AND ott.transaction_type_id = ooh.order_type_id

Line 5645: FROM oe_order_headers_all

5641: -- bug 4680186
5642: IF NOT Return_Line(p_line_rec) THEN
5643: BEGIN
5644: SELECT payment_term_id INTO l_hdr_payment_term_id
5645: FROM oe_order_headers_all
5646: WHERE header_id = p_line_rec.header_id;
5647: EXCEPTION
5648: WHEN NO_DATA_FOUND THEN
5649: l_hdr_payment_term_id := null;

Line 10160: from oe_order_headers_all where header_id = p_header_id;

10156:
10157: /* ------------ Bug# 9370369 : Start : Moving this code of bug# 8993414 little below -----
10158: ---Bug 8683948 : Start
10159: select source_document_type_id into l_source_document_type_id
10160: from oe_order_headers_all where header_id = p_header_id;
10161:
10162: if l_source_document_type_id = 10 THEN
10163: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
10164: x_return_status := FND_API.G_RET_STS_SUCCESS ;

Line 10201: from oe_order_headers_all where header_id = p_header_id;

10197: CLOSE order_line_cursor;
10198:
10199: ---- Bug# 9370369 : Start
10200: select source_document_type_id into l_source_document_type_id
10201: from oe_order_headers_all where header_id = p_header_id;
10202: oe_debug_pub.add( ' l_source_document_type_id = '|| l_source_document_type_id , 5) ;
10203:
10204: if l_source_document_type_id = 10 THEN
10205: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;