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.OZF_ADJUSTMENT_EXT_PVT dependencies on OE_ORDER_LINES_ALL

Line 104: ,line_category_code oe_order_lines_all.line_category_code%TYPE

100: ,inventory_item_id NUMBER
101: ,unit_list_price NUMBER
102: ,quantity NUMBER
103: ,transactional_curr_code oe_order_headers_all.transactional_curr_code%TYPE
104: ,line_category_code oe_order_lines_all.line_category_code%TYPE
105: ,reference_line_id NUMBER
106: ,order_number NUMBER
107: ,group_nos VARCHAR2(256)
108: ,uom_ratio NUMBER

Line 213: FROM oe_order_lines_all line, oe_order_headers_all header,

209: NVL(line.shipped_quantity, NVL(line.ordered_quantity, 0)) quantity,
210: header.transactional_curr_code, line.invoice_to_org_id,
211: line.sold_to_org_id, line.ship_to_org_id,line.line_category_code, line.reference_line_id,
212: header.order_number, header.org_id, line.order_quantity_uom, line.pricing_quantity_uom
213: FROM oe_order_lines_all line, oe_order_headers_all header,
214: (SELECT DISTINCT eligibility_id FROM ozf_temp_eligibility) temp
215: WHERE trunc(NVL(line.pricing_date, NVL(line.actual_shipment_date, line.fulfillment_date)))
216: BETWEEN p_start_date AND p_end_date
217: AND line.booked_flag = 'Y'

Line 230: FROM oe_order_lines_all line, oe_order_headers_all header,

226: NVL(line.shipped_quantity, NVL(line.ordered_quantity, 0)) quantity,
227: header.transactional_curr_code, line.invoice_to_org_id,
228: line.sold_to_org_id, line.ship_to_org_id,line.line_category_code, line.reference_line_id,
229: header.order_number, header.org_id, line.order_quantity_uom, line.pricing_quantity_uom
230: FROM oe_order_lines_all line, oe_order_headers_all header,
231: (SELECT DISTINCT eligibility_id FROM ozf_temp_eligibility) temp
232: WHERE trunc(NVL(line.pricing_date, NVL(line.actual_shipment_date, line.fulfillment_date)))
233: BETWEEN p_start_date AND p_end_date
234: AND line.booked_flag = 'Y'

Line 277: TYPE lineCatCodeTbl IS TABLE OF oe_order_lines_all.line_category_code%TYPE;

273: AND ROWNUM = 1;
274:
275: TYPE numberTbl IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
276: TYPE orderCurrTbl IS TABLE OF oe_order_headers_all.transactional_curr_code%TYPE;
277: TYPE lineCatCodeTbl IS TABLE OF oe_order_lines_all.line_category_code%TYPE;
278: TYPE groupNosTbl IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;
279: TYPE uomTbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
280:
281: l_headerIdTbl numberTbl;

Line 637: FROM oe_order_lines_all

633:
634: CURSOR c_order_line (p_order_line_id IN NUMBER) IS
635: SELECT NVL(invoiced_quantity, NVL(shipped_quantity, 0)) quantity,
636: ship_to_org_id, invoice_to_org_id
637: FROM oe_order_lines_all
638: WHERE line_id = p_order_line_id;
639:
640: l_order_org_id NUMBER;
641: l_exchange_rate_type VARCHAR2(30) := FND_API.G_MISS_CHAR;

Line 649: FROM oe_order_lines_all line, oe_order_headers_all header

645:
646: -- Added for bug 7030415. get order's org_id
647: CURSOR c_order_org_id (p_line_id IN NUMBER) IS
648: SELECT header.org_id
649: FROM oe_order_lines_all line, oe_order_headers_all header
650: WHERE line_id = p_line_id
651: AND line.header_id = header.header_id;
652:
653: -- get conversion type

Line 1058: FROM oe_order_lines_all

1054: CURSOR c_order_line_details (p_line_id IN NUMBER) IS
1055: SELECT actual_shipment_date, shipped_quantity, flow_status_code, invoice_interface_status_code,
1056: invoiced_quantity, sold_to_org_id, invoice_to_org_id, ship_to_org_id, shipping_quantity_uom,
1057: order_quantity_uom, unit_selling_price, org_id, ordered_quantity
1058: FROM oe_order_lines_all
1059: WHERE line_id = p_line_id;
1060:
1061: CURSOR c_invoice_date(p_line_id IN NUMBER, p_order_number IN VARCHAR2) IS
1062: SELECT cust.trx_date -- transaction(invoice) date

Line 1979: --Given that it is joined with oe_order_lines_all we need to go via

1975:
1976:
1977: --ozf_temp_eligibility table can have huge volume of data given that the
1978: --prod categories will be denormed and added there.
1979: --Given that it is joined with oe_order_lines_all we need to go via
1980: --perf team's suggestion on the HINTs, so it requires now 2 cursors
1981: -- Reason for 2 more cursors is explained below
1982:
1983: CURSOR c_order_header1 IS

Line 2043: FROM oe_order_lines_all line,

2039: line.shipping_quantity, -- Catch Weight ER
2040: line.shipping_quantity_uom2, -- Catch Weight ER
2041: line.shipping_quantity2, -- Catch Weight ER
2042: line.fulfillment_base -- Catch Weight ER
2043: FROM oe_order_lines_all line,
2044: ozf_adj_temp_eligibility temp,
2045: ozf_offer_adjustments_b adj,
2046: ozf_offer_adjustment_lines adj_line,
2047: ozf_offers off,

Line 2142: FROM oe_order_lines_all line,

2138: line.shipping_quantity, -- Catch Weight ER
2139: line.shipping_quantity_uom2, -- Catch Weight ER
2140: line.shipping_quantity2, -- Catch Weight ER
2141: line.fulfillment_base -- Catch Weight ER
2142: FROM oe_order_lines_all line,
2143: ozf_adj_temp_eligibility temp,
2144: ozf_offer_adjustments_b adj,
2145: ozf_offer_adjustment_lines adj_line,
2146: ozf_offers off,

Line 2248: FROM oe_order_lines_all line,

2244: line.shipping_quantity, -- Catch Weight ER
2245: line.shipping_quantity_uom2, -- Catch Weight ER
2246: line.shipping_quantity2, -- Catch Weight ER
2247: line.fulfillment_base -- Catch Weight ER
2248: FROM oe_order_lines_all line,
2249: ozf_adj_temp_eligibility temp,
2250: ozf_offer_adjustments_b adj,
2251: ozf_offer_adjustment_lines adj_line,
2252: ozf_offers off,

Line 2346: FROM oe_order_lines_all line,

2342: line.shipping_quantity, -- Catch Weight ER
2343: line.shipping_quantity_uom2, -- Catch Weight ER
2344: line.shipping_quantity2, -- Catch Weight ER
2345: line.fulfillment_base -- Catch Weight ER
2346: FROM oe_order_lines_all line,
2347: ozf_adj_temp_eligibility temp,
2348: ozf_offer_adjustments_b adj,
2349: ozf_offer_adjustment_tiers adj_line,
2350: ozf_offer_discount_lines orig_disc,

Line 2432: FROM oe_order_lines_all line,

2428: line.shipping_quantity, -- Catch Weight ER
2429: line.shipping_quantity_uom2, -- Catch Weight ER
2430: line.shipping_quantity2, -- Catch Weight ER
2431: line.fulfillment_base -- Catch Weight ER
2432: FROM oe_order_lines_all line,
2433: ozf_adj_temp_eligibility temp,
2434: ozf_offer_adjustments_b adj,
2435: ozf_offer_adjustment_lines adj_line,
2436: ozf_offers off,

Line 2530: FROM oe_order_lines_all line,

2526: line.shipping_quantity, -- Catch Weight ER
2527: line.shipping_quantity_uom2, -- Catch Weight ER
2528: line.shipping_quantity2, -- Catch Weight ER
2529: line.fulfillment_base -- Catch Weight ER
2530: FROM oe_order_lines_all line,
2531: ozf_adj_temp_eligibility temp,
2532: ozf_offer_adjustments_b adj,
2533: ozf_offer_adjustment_tiers adj_line,
2534: ozf_offer_discount_lines orig_disc,

Line 2628: TYPE lineCatCodeTbl IS TABLE OF oe_order_lines_all.line_category_code%TYPE;

2624: l_justification VARCHAR2(50);
2625:
2626:
2627: TYPE orderCurrTbl IS TABLE OF oe_order_headers_all.transactional_curr_code%TYPE;
2628: TYPE lineCatCodeTbl IS TABLE OF oe_order_lines_all.line_category_code%TYPE;
2629: TYPE groupNosTbl IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;
2630: TYPE uomTbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
2631: TYPE pricingDateTbl IS TABLE OF oe_order_lines_all.pricing_date%TYPE;
2632: TYPE actualShipDateTbl IS TABLE OF oe_order_lines_all.actual_shipment_date%TYPE;

Line 2631: TYPE pricingDateTbl IS TABLE OF oe_order_lines_all.pricing_date%TYPE;

2627: TYPE orderCurrTbl IS TABLE OF oe_order_headers_all.transactional_curr_code%TYPE;
2628: TYPE lineCatCodeTbl IS TABLE OF oe_order_lines_all.line_category_code%TYPE;
2629: TYPE groupNosTbl IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;
2630: TYPE uomTbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
2631: TYPE pricingDateTbl IS TABLE OF oe_order_lines_all.pricing_date%TYPE;
2632: TYPE actualShipDateTbl IS TABLE OF oe_order_lines_all.actual_shipment_date%TYPE;
2633: TYPE requestDateTbl IS TABLE OF oe_order_lines_all.request_date%TYPE;
2634: TYPE fulfillmentDateTbl IS TABLE OF oe_order_lines_all.fulfillment_date%TYPE;
2635: TYPE offCurrTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;

Line 2632: TYPE actualShipDateTbl IS TABLE OF oe_order_lines_all.actual_shipment_date%TYPE;

2628: TYPE lineCatCodeTbl IS TABLE OF oe_order_lines_all.line_category_code%TYPE;
2629: TYPE groupNosTbl IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;
2630: TYPE uomTbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
2631: TYPE pricingDateTbl IS TABLE OF oe_order_lines_all.pricing_date%TYPE;
2632: TYPE actualShipDateTbl IS TABLE OF oe_order_lines_all.actual_shipment_date%TYPE;
2633: TYPE requestDateTbl IS TABLE OF oe_order_lines_all.request_date%TYPE;
2634: TYPE fulfillmentDateTbl IS TABLE OF oe_order_lines_all.fulfillment_date%TYPE;
2635: TYPE offCurrTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
2636: TYPE arithOperTbl IS TABLE OF qp_list_lines.arithmetic_operator%TYPE;

Line 2633: TYPE requestDateTbl IS TABLE OF oe_order_lines_all.request_date%TYPE;

2629: TYPE groupNosTbl IS TABLE OF VARCHAR2(256) INDEX BY BINARY_INTEGER;
2630: TYPE uomTbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
2631: TYPE pricingDateTbl IS TABLE OF oe_order_lines_all.pricing_date%TYPE;
2632: TYPE actualShipDateTbl IS TABLE OF oe_order_lines_all.actual_shipment_date%TYPE;
2633: TYPE requestDateTbl IS TABLE OF oe_order_lines_all.request_date%TYPE;
2634: TYPE fulfillmentDateTbl IS TABLE OF oe_order_lines_all.fulfillment_date%TYPE;
2635: TYPE offCurrTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
2636: TYPE arithOperTbl IS TABLE OF qp_list_lines.arithmetic_operator%TYPE;
2637:

Line 2634: TYPE fulfillmentDateTbl IS TABLE OF oe_order_lines_all.fulfillment_date%TYPE;

2630: TYPE uomTbl IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
2631: TYPE pricingDateTbl IS TABLE OF oe_order_lines_all.pricing_date%TYPE;
2632: TYPE actualShipDateTbl IS TABLE OF oe_order_lines_all.actual_shipment_date%TYPE;
2633: TYPE requestDateTbl IS TABLE OF oe_order_lines_all.request_date%TYPE;
2634: TYPE fulfillmentDateTbl IS TABLE OF oe_order_lines_all.fulfillment_date%TYPE;
2635: TYPE offCurrTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
2636: TYPE arithOperTbl IS TABLE OF qp_list_lines.arithmetic_operator%TYPE;
2637:
2638: TYPE custPONumberTbl IS TABLE OF oe_order_lines_all.cust_po_number%TYPE;

Line 2638: TYPE custPONumberTbl IS TABLE OF oe_order_lines_all.cust_po_number%TYPE;

2634: TYPE fulfillmentDateTbl IS TABLE OF oe_order_lines_all.fulfillment_date%TYPE;
2635: TYPE offCurrTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
2636: TYPE arithOperTbl IS TABLE OF qp_list_lines.arithmetic_operator%TYPE;
2637:
2638: TYPE custPONumberTbl IS TABLE OF oe_order_lines_all.cust_po_number%TYPE;
2639: TYPE shipmentPriorityCodeTbl IS TABLE OF oe_order_lines_all.shipment_priority_code%TYPE;
2640: TYPE shippableFlagTbl IS TABLE OF oe_order_lines_all.shippable_flag%TYPE;
2641: TYPE scheduleShipDateTbl IS TABLE OF oe_order_lines_all.schedule_ship_date%TYPE;
2642: TYPE sourceTypeCodeTbl IS TABLE OF oe_order_lines_all.source_type_code%TYPE;

Line 2639: TYPE shipmentPriorityCodeTbl IS TABLE OF oe_order_lines_all.shipment_priority_code%TYPE;

2635: TYPE offCurrTbl IS TABLE OF ozf_offers.transaction_currency_code%TYPE;
2636: TYPE arithOperTbl IS TABLE OF qp_list_lines.arithmetic_operator%TYPE;
2637:
2638: TYPE custPONumberTbl IS TABLE OF oe_order_lines_all.cust_po_number%TYPE;
2639: TYPE shipmentPriorityCodeTbl IS TABLE OF oe_order_lines_all.shipment_priority_code%TYPE;
2640: TYPE shippableFlagTbl IS TABLE OF oe_order_lines_all.shippable_flag%TYPE;
2641: TYPE scheduleShipDateTbl IS TABLE OF oe_order_lines_all.schedule_ship_date%TYPE;
2642: TYPE sourceTypeCodeTbl IS TABLE OF oe_order_lines_all.source_type_code%TYPE;
2643: TYPE freightTermsCodeTbl IS TABLE OF oe_order_lines_all.freight_terms_code%TYPE;

Line 2640: TYPE shippableFlagTbl IS TABLE OF oe_order_lines_all.shippable_flag%TYPE;

2636: TYPE arithOperTbl IS TABLE OF qp_list_lines.arithmetic_operator%TYPE;
2637:
2638: TYPE custPONumberTbl IS TABLE OF oe_order_lines_all.cust_po_number%TYPE;
2639: TYPE shipmentPriorityCodeTbl IS TABLE OF oe_order_lines_all.shipment_priority_code%TYPE;
2640: TYPE shippableFlagTbl IS TABLE OF oe_order_lines_all.shippable_flag%TYPE;
2641: TYPE scheduleShipDateTbl IS TABLE OF oe_order_lines_all.schedule_ship_date%TYPE;
2642: TYPE sourceTypeCodeTbl IS TABLE OF oe_order_lines_all.source_type_code%TYPE;
2643: TYPE freightTermsCodeTbl IS TABLE OF oe_order_lines_all.freight_terms_code%TYPE;
2644: TYPE shippingMethodCodeTbl IS TABLE OF oe_order_lines_all.shipping_method_code%TYPE;

Line 2641: TYPE scheduleShipDateTbl IS TABLE OF oe_order_lines_all.schedule_ship_date%TYPE;

2637:
2638: TYPE custPONumberTbl IS TABLE OF oe_order_lines_all.cust_po_number%TYPE;
2639: TYPE shipmentPriorityCodeTbl IS TABLE OF oe_order_lines_all.shipment_priority_code%TYPE;
2640: TYPE shippableFlagTbl IS TABLE OF oe_order_lines_all.shippable_flag%TYPE;
2641: TYPE scheduleShipDateTbl IS TABLE OF oe_order_lines_all.schedule_ship_date%TYPE;
2642: TYPE sourceTypeCodeTbl IS TABLE OF oe_order_lines_all.source_type_code%TYPE;
2643: TYPE freightTermsCodeTbl IS TABLE OF oe_order_lines_all.freight_terms_code%TYPE;
2644: TYPE shippingMethodCodeTbl IS TABLE OF oe_order_lines_all.shipping_method_code%TYPE;
2645: TYPE itemIdentifierTypeTbl IS TABLE OF oe_order_lines_all.item_identifier_type%TYPE;

Line 2642: TYPE sourceTypeCodeTbl IS TABLE OF oe_order_lines_all.source_type_code%TYPE;

2638: TYPE custPONumberTbl IS TABLE OF oe_order_lines_all.cust_po_number%TYPE;
2639: TYPE shipmentPriorityCodeTbl IS TABLE OF oe_order_lines_all.shipment_priority_code%TYPE;
2640: TYPE shippableFlagTbl IS TABLE OF oe_order_lines_all.shippable_flag%TYPE;
2641: TYPE scheduleShipDateTbl IS TABLE OF oe_order_lines_all.schedule_ship_date%TYPE;
2642: TYPE sourceTypeCodeTbl IS TABLE OF oe_order_lines_all.source_type_code%TYPE;
2643: TYPE freightTermsCodeTbl IS TABLE OF oe_order_lines_all.freight_terms_code%TYPE;
2644: TYPE shippingMethodCodeTbl IS TABLE OF oe_order_lines_all.shipping_method_code%TYPE;
2645: TYPE itemIdentifierTypeTbl IS TABLE OF oe_order_lines_all.item_identifier_type%TYPE;
2646: TYPE unitPercentBasePriceTbl IS TABLE OF oe_order_lines_all.unit_percent_base_price%TYPE;

Line 2643: TYPE freightTermsCodeTbl IS TABLE OF oe_order_lines_all.freight_terms_code%TYPE;

2639: TYPE shipmentPriorityCodeTbl IS TABLE OF oe_order_lines_all.shipment_priority_code%TYPE;
2640: TYPE shippableFlagTbl IS TABLE OF oe_order_lines_all.shippable_flag%TYPE;
2641: TYPE scheduleShipDateTbl IS TABLE OF oe_order_lines_all.schedule_ship_date%TYPE;
2642: TYPE sourceTypeCodeTbl IS TABLE OF oe_order_lines_all.source_type_code%TYPE;
2643: TYPE freightTermsCodeTbl IS TABLE OF oe_order_lines_all.freight_terms_code%TYPE;
2644: TYPE shippingMethodCodeTbl IS TABLE OF oe_order_lines_all.shipping_method_code%TYPE;
2645: TYPE itemIdentifierTypeTbl IS TABLE OF oe_order_lines_all.item_identifier_type%TYPE;
2646: TYPE unitPercentBasePriceTbl IS TABLE OF oe_order_lines_all.unit_percent_base_price%TYPE;
2647: TYPE preferredGradeTbl IS TABLE OF oe_order_lines_all.preferred_grade%TYPE;

Line 2644: TYPE shippingMethodCodeTbl IS TABLE OF oe_order_lines_all.shipping_method_code%TYPE;

2640: TYPE shippableFlagTbl IS TABLE OF oe_order_lines_all.shippable_flag%TYPE;
2641: TYPE scheduleShipDateTbl IS TABLE OF oe_order_lines_all.schedule_ship_date%TYPE;
2642: TYPE sourceTypeCodeTbl IS TABLE OF oe_order_lines_all.source_type_code%TYPE;
2643: TYPE freightTermsCodeTbl IS TABLE OF oe_order_lines_all.freight_terms_code%TYPE;
2644: TYPE shippingMethodCodeTbl IS TABLE OF oe_order_lines_all.shipping_method_code%TYPE;
2645: TYPE itemIdentifierTypeTbl IS TABLE OF oe_order_lines_all.item_identifier_type%TYPE;
2646: TYPE unitPercentBasePriceTbl IS TABLE OF oe_order_lines_all.unit_percent_base_price%TYPE;
2647: TYPE preferredGradeTbl IS TABLE OF oe_order_lines_all.preferred_grade%TYPE;
2648: TYPE blanketNumberTbl IS TABLE OF oe_order_lines_all.Blanket_number%TYPE;

Line 2645: TYPE itemIdentifierTypeTbl IS TABLE OF oe_order_lines_all.item_identifier_type%TYPE;

2641: TYPE scheduleShipDateTbl IS TABLE OF oe_order_lines_all.schedule_ship_date%TYPE;
2642: TYPE sourceTypeCodeTbl IS TABLE OF oe_order_lines_all.source_type_code%TYPE;
2643: TYPE freightTermsCodeTbl IS TABLE OF oe_order_lines_all.freight_terms_code%TYPE;
2644: TYPE shippingMethodCodeTbl IS TABLE OF oe_order_lines_all.shipping_method_code%TYPE;
2645: TYPE itemIdentifierTypeTbl IS TABLE OF oe_order_lines_all.item_identifier_type%TYPE;
2646: TYPE unitPercentBasePriceTbl IS TABLE OF oe_order_lines_all.unit_percent_base_price%TYPE;
2647: TYPE preferredGradeTbl IS TABLE OF oe_order_lines_all.preferred_grade%TYPE;
2648: TYPE blanketNumberTbl IS TABLE OF oe_order_lines_all.Blanket_number%TYPE;
2649: TYPE blanketLineNumberTbl IS TABLE OF oe_order_lines_all.blanket_line_number%TYPE;

Line 2646: TYPE unitPercentBasePriceTbl IS TABLE OF oe_order_lines_all.unit_percent_base_price%TYPE;

2642: TYPE sourceTypeCodeTbl IS TABLE OF oe_order_lines_all.source_type_code%TYPE;
2643: TYPE freightTermsCodeTbl IS TABLE OF oe_order_lines_all.freight_terms_code%TYPE;
2644: TYPE shippingMethodCodeTbl IS TABLE OF oe_order_lines_all.shipping_method_code%TYPE;
2645: TYPE itemIdentifierTypeTbl IS TABLE OF oe_order_lines_all.item_identifier_type%TYPE;
2646: TYPE unitPercentBasePriceTbl IS TABLE OF oe_order_lines_all.unit_percent_base_price%TYPE;
2647: TYPE preferredGradeTbl IS TABLE OF oe_order_lines_all.preferred_grade%TYPE;
2648: TYPE blanketNumberTbl IS TABLE OF oe_order_lines_all.Blanket_number%TYPE;
2649: TYPE blanketLineNumberTbl IS TABLE OF oe_order_lines_all.blanket_line_number%TYPE;
2650: TYPE transactionPhaseCodeTbl IS TABLE OF oe_order_lines_all.transaction_phase_code%TYPE;

Line 2647: TYPE preferredGradeTbl IS TABLE OF oe_order_lines_all.preferred_grade%TYPE;

2643: TYPE freightTermsCodeTbl IS TABLE OF oe_order_lines_all.freight_terms_code%TYPE;
2644: TYPE shippingMethodCodeTbl IS TABLE OF oe_order_lines_all.shipping_method_code%TYPE;
2645: TYPE itemIdentifierTypeTbl IS TABLE OF oe_order_lines_all.item_identifier_type%TYPE;
2646: TYPE unitPercentBasePriceTbl IS TABLE OF oe_order_lines_all.unit_percent_base_price%TYPE;
2647: TYPE preferredGradeTbl IS TABLE OF oe_order_lines_all.preferred_grade%TYPE;
2648: TYPE blanketNumberTbl IS TABLE OF oe_order_lines_all.Blanket_number%TYPE;
2649: TYPE blanketLineNumberTbl IS TABLE OF oe_order_lines_all.blanket_line_number%TYPE;
2650: TYPE transactionPhaseCodeTbl IS TABLE OF oe_order_lines_all.transaction_phase_code%TYPE;
2651: TYPE chargePeriodicityCodeTbl IS TABLE OF oe_order_lines_all.charge_periodicity_code%TYPE;

Line 2648: TYPE blanketNumberTbl IS TABLE OF oe_order_lines_all.Blanket_number%TYPE;

2644: TYPE shippingMethodCodeTbl IS TABLE OF oe_order_lines_all.shipping_method_code%TYPE;
2645: TYPE itemIdentifierTypeTbl IS TABLE OF oe_order_lines_all.item_identifier_type%TYPE;
2646: TYPE unitPercentBasePriceTbl IS TABLE OF oe_order_lines_all.unit_percent_base_price%TYPE;
2647: TYPE preferredGradeTbl IS TABLE OF oe_order_lines_all.preferred_grade%TYPE;
2648: TYPE blanketNumberTbl IS TABLE OF oe_order_lines_all.Blanket_number%TYPE;
2649: TYPE blanketLineNumberTbl IS TABLE OF oe_order_lines_all.blanket_line_number%TYPE;
2650: TYPE transactionPhaseCodeTbl IS TABLE OF oe_order_lines_all.transaction_phase_code%TYPE;
2651: TYPE chargePeriodicityCodeTbl IS TABLE OF oe_order_lines_all.charge_periodicity_code%TYPE;
2652:

Line 2649: TYPE blanketLineNumberTbl IS TABLE OF oe_order_lines_all.blanket_line_number%TYPE;

2645: TYPE itemIdentifierTypeTbl IS TABLE OF oe_order_lines_all.item_identifier_type%TYPE;
2646: TYPE unitPercentBasePriceTbl IS TABLE OF oe_order_lines_all.unit_percent_base_price%TYPE;
2647: TYPE preferredGradeTbl IS TABLE OF oe_order_lines_all.preferred_grade%TYPE;
2648: TYPE blanketNumberTbl IS TABLE OF oe_order_lines_all.Blanket_number%TYPE;
2649: TYPE blanketLineNumberTbl IS TABLE OF oe_order_lines_all.blanket_line_number%TYPE;
2650: TYPE transactionPhaseCodeTbl IS TABLE OF oe_order_lines_all.transaction_phase_code%TYPE;
2651: TYPE chargePeriodicityCodeTbl IS TABLE OF oe_order_lines_all.charge_periodicity_code%TYPE;
2652:
2653: TYPE hdrRequestDateTbl IS TABLE OF oe_order_headers_all.request_date%TYPE;

Line 2650: TYPE transactionPhaseCodeTbl IS TABLE OF oe_order_lines_all.transaction_phase_code%TYPE;

2646: TYPE unitPercentBasePriceTbl IS TABLE OF oe_order_lines_all.unit_percent_base_price%TYPE;
2647: TYPE preferredGradeTbl IS TABLE OF oe_order_lines_all.preferred_grade%TYPE;
2648: TYPE blanketNumberTbl IS TABLE OF oe_order_lines_all.Blanket_number%TYPE;
2649: TYPE blanketLineNumberTbl IS TABLE OF oe_order_lines_all.blanket_line_number%TYPE;
2650: TYPE transactionPhaseCodeTbl IS TABLE OF oe_order_lines_all.transaction_phase_code%TYPE;
2651: TYPE chargePeriodicityCodeTbl IS TABLE OF oe_order_lines_all.charge_periodicity_code%TYPE;
2652:
2653: TYPE hdrRequestDateTbl IS TABLE OF oe_order_headers_all.request_date%TYPE;
2654: TYPE hdrPricingDateTbl IS TABLE OF oe_order_headers_all.pricing_date%TYPE;

Line 2651: TYPE chargePeriodicityCodeTbl IS TABLE OF oe_order_lines_all.charge_periodicity_code%TYPE;

2647: TYPE preferredGradeTbl IS TABLE OF oe_order_lines_all.preferred_grade%TYPE;
2648: TYPE blanketNumberTbl IS TABLE OF oe_order_lines_all.Blanket_number%TYPE;
2649: TYPE blanketLineNumberTbl IS TABLE OF oe_order_lines_all.blanket_line_number%TYPE;
2650: TYPE transactionPhaseCodeTbl IS TABLE OF oe_order_lines_all.transaction_phase_code%TYPE;
2651: TYPE chargePeriodicityCodeTbl IS TABLE OF oe_order_lines_all.charge_periodicity_code%TYPE;
2652:
2653: TYPE hdrRequestDateTbl IS TABLE OF oe_order_headers_all.request_date%TYPE;
2654: TYPE hdrPricingDateTbl IS TABLE OF oe_order_headers_all.pricing_date%TYPE;
2655: TYPE hdrOrderedDateTbl IS TABLE OF oe_order_headers_all.ordered_date%TYPE;

Line 2666: TYPE invoiceInterfaceStatusTbl IS TABLE OF oe_order_lines_all.invoice_interface_status_code%TYPE;

2662: TYPE hdrConversionRateDateTbl IS TABLE OF oe_order_headers_all.conversion_rate_date%TYPE;
2663: TYPE hdrConversionRateTbl IS TABLE OF oe_order_headers_all.conversion_rate%TYPE;
2664: TYPE hdrConversionTypeCodeTbl IS TABLE OF oe_order_headers_all.conversion_type_code%TYPE;
2665: TYPE hdrBlanketNumberTbl IS TABLE OF oe_order_headers_all.blanket_number%TYPE;
2666: TYPE invoiceInterfaceStatusTbl IS TABLE OF oe_order_lines_all.invoice_interface_status_code%TYPE;
2667: TYPE shippingQuantityUomTbl IS TABLE OF oe_order_lines_all.shipping_quantity_uom%TYPE;
2668: -- Catch Weight ER
2669: TYPE shippingQuantityTbl IS TABLE OF oe_order_lines_all.shipping_quantity%TYPE;
2670: TYPE fulfillmentBaseTbl IS TABLE OF oe_order_lines_all.fulfillment_base%TYPE;

Line 2667: TYPE shippingQuantityUomTbl IS TABLE OF oe_order_lines_all.shipping_quantity_uom%TYPE;

2663: TYPE hdrConversionRateTbl IS TABLE OF oe_order_headers_all.conversion_rate%TYPE;
2664: TYPE hdrConversionTypeCodeTbl IS TABLE OF oe_order_headers_all.conversion_type_code%TYPE;
2665: TYPE hdrBlanketNumberTbl IS TABLE OF oe_order_headers_all.blanket_number%TYPE;
2666: TYPE invoiceInterfaceStatusTbl IS TABLE OF oe_order_lines_all.invoice_interface_status_code%TYPE;
2667: TYPE shippingQuantityUomTbl IS TABLE OF oe_order_lines_all.shipping_quantity_uom%TYPE;
2668: -- Catch Weight ER
2669: TYPE shippingQuantityTbl IS TABLE OF oe_order_lines_all.shipping_quantity%TYPE;
2670: TYPE fulfillmentBaseTbl IS TABLE OF oe_order_lines_all.fulfillment_base%TYPE;
2671: -- Catch Weight ER

Line 2669: TYPE shippingQuantityTbl IS TABLE OF oe_order_lines_all.shipping_quantity%TYPE;

2665: TYPE hdrBlanketNumberTbl IS TABLE OF oe_order_headers_all.blanket_number%TYPE;
2666: TYPE invoiceInterfaceStatusTbl IS TABLE OF oe_order_lines_all.invoice_interface_status_code%TYPE;
2667: TYPE shippingQuantityUomTbl IS TABLE OF oe_order_lines_all.shipping_quantity_uom%TYPE;
2668: -- Catch Weight ER
2669: TYPE shippingQuantityTbl IS TABLE OF oe_order_lines_all.shipping_quantity%TYPE;
2670: TYPE fulfillmentBaseTbl IS TABLE OF oe_order_lines_all.fulfillment_base%TYPE;
2671: -- Catch Weight ER
2672:
2673: TYPE numberTblType IS TABLE OF NUMBER;

Line 2670: TYPE fulfillmentBaseTbl IS TABLE OF oe_order_lines_all.fulfillment_base%TYPE;

2666: TYPE invoiceInterfaceStatusTbl IS TABLE OF oe_order_lines_all.invoice_interface_status_code%TYPE;
2667: TYPE shippingQuantityUomTbl IS TABLE OF oe_order_lines_all.shipping_quantity_uom%TYPE;
2668: -- Catch Weight ER
2669: TYPE shippingQuantityTbl IS TABLE OF oe_order_lines_all.shipping_quantity%TYPE;
2670: TYPE fulfillmentBaseTbl IS TABLE OF oe_order_lines_all.fulfillment_base%TYPE;
2671: -- Catch Weight ER
2672:
2673: TYPE numberTblType IS TABLE OF NUMBER;
2674:

Line 4835: FROM oe_order_lines_all

4831: CURSOR c_order_line(p_order_line_id IN NUMBER) IS
4832: SELECT nvl(invoiced_quantity, nvl(shipped_quantity, 0)) quantity,
4833: ship_to_org_id,
4834: invoice_to_org_id
4835: FROM oe_order_lines_all
4836: WHERE line_id = p_order_line_id;
4837:
4838: CURSOR c_order_adjustment_amt(p_object_id IN NUMBER,
4839: p_order_line_id IN NUMBER,

Line 5068: l_stmt := 'SELECT ' || l_column_name ||' FROM oe_order_lines_all WHERE line_id = :1 AND org_id = :2';

5064: MO_GLOBAL.set_policy_context('S', l_order_org_id);
5065: l_column_name := FND_PROFILE.VALUE('OZF_ITEM_COST_COLUMN');
5066:
5067: IF l_column_name IS NOT NULL AND l_column_name <> FND_API.G_MISS_CHAR THEN
5068: l_stmt := 'SELECT ' || l_column_name ||' FROM oe_order_lines_all WHERE line_id = :1 AND org_id = :2';
5069: IF g_debug_flag = 'Y' THEN
5070: ozf_utility_pvt.write_conc_log('Query to obtain purchase price '||l_stmt);
5071: END IF;
5072:

Line 5354: FROM oe_order_lines_all

5350: CURSOR c_order_line(p_order_line_id IN NUMBER) IS
5351: SELECT nvl(invoiced_quantity, nvl(shipped_quantity, 0)) quantity,
5352: ship_to_org_id,
5353: invoice_to_org_id
5354: FROM oe_order_lines_all
5355: WHERE line_id = p_order_line_id;
5356:
5357: CURSOR c_order_adjustment_amt(p_object_id IN NUMBER,
5358: p_order_line_id IN NUMBER,

Line 6031: oe_order_lines_all ol,

6027: ,util.exchange_rate_type
6028: FROM ozf_funds_utilized_all_b util,
6029: ozf_temp_eligibility temp,
6030: ozf_offer_adjustment_lines adjl,
6031: oe_order_lines_all ol,
6032: oe_price_adjustments oe
6033: WHERE util.plan_type = 'OFFR'
6034: AND product_id IS NOT NULL
6035: AND util.plan_id = p_qp_list_header_id

Line 6173: oe_order_lines_all ol,

6169: ,util.exchange_rate_type
6170: FROM ozf_funds_utilized_all_b util,
6171: ozf_temp_eligibility temp,
6172: ozf_offer_adjustment_lines adjl,
6173: oe_order_lines_all ol,
6174: oe_price_adjustments oe
6175: WHERE util.plan_type = 'OFFR'
6176: AND product_id IS NOT NULL
6177: AND util.plan_id = p_qp_list_header_id

Line 6277: oe_order_lines_all ol,

6273: ,util.exchange_rate_type
6274: FROM ozf_funds_utilized_all_b util,
6275: ozf_temp_eligibility temp,
6276: ozf_offer_adjustment_lines adjl,
6277: oe_order_lines_all ol,
6278: oe_price_adjustments oe
6279: WHERE util.plan_type = 'OFFR'
6280: AND product_id IS NOT NULL
6281: AND util.plan_id = p_qp_list_header_id

Line 6374: oe_order_lines_all ol,

6370: ,util.reference_id
6371: ,util.exchange_rate_type
6372: FROM ozf_funds_utilized_all_b util,
6373: ozf_offer_adjustment_lines adjl,
6374: oe_order_lines_all ol,
6375: oe_price_adjustments oe
6376: WHERE util.plan_type = 'OFFR'
6377: AND util.plan_id = p_qp_list_header_id
6378: -- kdass 31-MAR-2006 fix bug 5101720 offer adjustment creates new list_line_id

Line 6424: oe_order_lines_all ol,

6420: ,util.exchange_rate_type
6421: FROM ozf_funds_utilized_all_b util,
6422: ozf_temp_eligibility temp,
6423: ozf_offer_adjustment_lines adjl,
6424: oe_order_lines_all ol,
6425: oe_price_adjustments oe
6426: WHERE util.plan_type = 'OFFR'
6427: AND product_id IS NOT NULL
6428: AND util.plan_id = p_qp_list_header_id

Line 7552: FROM oe_order_lines_all line, oe_price_Adjustments adj, oe_order_headers_all header

7548: --kdass 11-MAY-2005 Bug 4362575 changed unit_selling_price to unit_list_price
7549: SELECT SUM(DECODE(p_amt_qty, 'amt', line.unit_list_price, 1)*
7550: NVL(line.invoiced_quantity, NVL(line.shipped_quantity, NVL(line.ordered_quantity, 0)))
7551: ), header.transactional_curr_code
7552: FROM oe_order_lines_all line, oe_price_Adjustments adj, oe_order_headers_all header
7553: WHERE line.line_id = adj.line_id
7554: AND line.header_id = header.header_id
7555: AND line.header_id = adj.header_id
7556: AND adj.list_header_id = p_list_header_id

Line 7570: FROM oe_order_lines_all line, oe_price_Adjustments adj, oe_order_headers_all header

7566: --kdass 11-MAY-2005 Bug 4362575 changed unit_selling_price to unit_list_price
7567: SELECT SUM(DECODE(p_amt_qty, 'amt', line.unit_list_price, 1)*
7568: NVL(line.invoiced_quantity, NVL(line.shipped_quantity, NVL(line.ordered_quantity, 0)))
7569: ), header.transactional_curr_code
7570: FROM oe_order_lines_all line, oe_price_Adjustments adj, oe_order_headers_all header
7571: WHERE line.line_id = adj.line_id
7572: AND line.header_id = header.header_id
7573: AND line.header_id = adj.header_id
7574: AND adj.list_header_id = p_list_header_id

Line 7807: FROM oe_order_lines_all line, oe_order_headers_all header

7803: line.shipping_quantity_uom, -- Catch Weight ER
7804: line.shipping_quantity2, -- Catch Weight ER
7805: line.shipping_quantity_uom2, -- Catch Weight ER
7806: line.fulfillment_base -- Catch Weight ER
7807: FROM oe_order_lines_all line, oe_order_headers_all header
7808: WHERE line.line_id = p_order_line_id
7809: AND line.header_id = header.header_id;
7810:
7811:

Line 8867: FROM oe_order_lines_all line

8863:
8864: /* CURSOR c_order_line_qty(p_order_line_id IN NUMBER) IS
8865: SELECT DECODE(line.line_category_code,'ORDER',line.ordered_quantity,
8866: 'RETURN', -line.ordered_quantity) ordered_quantity
8867: FROM oe_order_lines_all line
8868: WHERE line.line_id = p_order_line_id;*/
8869:
8870:
8871: /* CURSOR c_all_orders (p_list_header_id IN NUMBER) IS

Line 8874: select sum(ordered_quantity) ordered_quantity from oe_order_lines_all

8870:
8871: /* CURSOR c_all_orders (p_list_header_id IN NUMBER) IS
8872: select sum(ordered_quantity)
8873: FROM (
8874: select sum(ordered_quantity) ordered_quantity from oe_order_lines_all
8875: where line_id IN
8876: (SELECT order_line_id FROM ozf_funds_utilized_all_b
8877: WHERE plan_id = p_list_header_id
8878: AND plan_type = 'OFFR'

Line 8899: from oe_order_lines_all oe,

8895: select sum(ordered_quantity)
8896: FROM (
8897: SELECT SUM(DECODE(line_category_code,'ORDER',ordered_quantity,
8898: 'RETURN', -ordered_quantity)) ordered_quantity
8899: from oe_order_lines_all oe,
8900: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b
8901: WHERE plan_id = p_list_header_id
8902: AND plan_type = 'OFFR'
8903: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')

Line 8970: FROM oe_order_lines_all line, oe_order_headers_all header

8966: line.fulfillment_date, -- invoiced date ?????
8967: line.inventory_item_id,
8968: header.transactional_curr_code,
8969: header.header_id
8970: FROM oe_order_lines_all line, oe_order_headers_all header
8971: WHERE line.line_id = p_order_line_id
8972: AND line.header_id = header.header_id;
8973:
8974:

Line 9012: FROM oe_order_lines_all

9008: WHERE qp_list_header_id = p_list_header_id;
9009:
9010: CURSOR c_order_line_details (p_line_id IN NUMBER) IS
9011: SELECT invoice_to_org_id, ship_to_org_id
9012: FROM oe_order_lines_all
9013: WHERE line_id = p_line_id;
9014:
9015: CURSOR c_cust_number (p_header_id IN NUMBER) IS
9016: SELECT cust.cust_account_id

Line 9055: from oe_order_lines_all oe,

9051: select sum(ordered_quantity)
9052: FROM (
9053: SELECT SUM (DECODE(line_category_code,'ORDER',ordered_quantity,
9054: 'RETURN', -ordered_quantity)) ordered_quantity
9055: from oe_order_lines_all oe,
9056: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b
9057: WHERE plan_id = p_list_header_id
9058: AND plan_type = 'OFFR'
9059: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')

Line 9083: from oe_order_lines_all oe,

9079: select sum(ordered_quantity)
9080: FROM (
9081: SELECT SUM (DECODE(line_category_code,'ORDER',ordered_quantity,
9082: 'RETURN', -ordered_quantity)) ordered_quantity
9083: from oe_order_lines_all oe,
9084: (SELECT distinct order_line_id FROM ozf_funds_utilized_all_b
9085: WHERE plan_id = p_list_header_id
9086: AND plan_type = 'OFFR'
9087: AND utilization_type IN ( 'ACCRUAL','SALES_ACCRUAL','LEAD_ACCRUAL','UTILIZED', 'ADJUSTMENT', 'LEAD_ADJUSTMENT')