DBA Data[Home] [Help]

APPS.OM_TAX_UTIL dependencies on OE_ORDER_LINES_ALL

Line 96: OE_ORDER_LINES_ALL L

92: (L.ORDERED_QUANTITY* nvl(P.ADJUSTED_AMOUNT,0)))
93: ,OE_ORDER_UTIL.G_Precision)
94: BULK COLLECT INTO l_charge_tbl
95: FROM OE_PRICE_ADJUSTMENTS P,
96: OE_ORDER_LINES_ALL L
97: WHERE P.HEADER_ID = p_header_id
98: AND P.LINE_ID = p_line_id
99: AND P.LINE_ID = L.LINE_ID
100: AND P.LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'

Line 2080: FROM oe_order_lines_all

2076: l_num_tbl num_tbl := num_tbl();
2077:
2078: CURSOR order_line_cur IS
2079: SELECT line_id
2080: FROM oe_order_lines_all
2081: WHERE header_id = p_header_id
2082: AND open_flag = 'Y'; -- OPEN_FLAG added for bug 9897108
2083:
2084: BEGIN