DBA Data[Home] [Help]

APPS.OZF_ADJUSTMENT_EXT_PVT dependencies on OE_ORDER_HEADERS_ALL

Line 103: ,transactional_curr_code oe_order_headers_all.transactional_curr_code%TYPE

99: ,order_line_id NUMBER
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)

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 276: TYPE orderCurrTbl IS TABLE OF oe_order_headers_all.transactional_curr_code%TYPE;

272: AND object_id = p_list_header_id
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:

Line 603: oe_order_headers_all header

599: SELECT cust.cust_account_id
600: FROM hz_cust_acct_sites_all acct_site,
601: hz_cust_site_uses_all site_use,
602: hz_cust_accounts cust,
603: oe_order_headers_all header
604: WHERE header.header_id = p_header_id
605: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
606: AND acct_site.cust_account_id = cust.cust_account_id
607: AND site_use.site_use_id = header.invoice_to_org_id ;

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 1107: oe_order_headers_all header

1103: SELECT cust.cust_account_id
1104: FROM hz_cust_acct_sites_all acct_site,
1105: hz_cust_site_uses_all site_use,
1106: hz_cust_accounts cust,
1107: oe_order_headers_all header
1108: WHERE header.header_id = p_header_id
1109: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
1110: AND acct_site.cust_account_id = cust.cust_account_id
1111: AND site_use.site_use_id = header.invoice_to_org_id ;

Line 2562: FROM oe_order_headers_all

2558: agreement_id, cust_po_number, ship_from_org_id, order_category_code,
2559: shipment_priority_code, freight_terms_code, payment_term_id, shipping_method_code,
2560: conversion_rate_date, conversion_rate, conversion_type_code, minisite_id,
2561: blanket_number
2562: FROM oe_order_headers_all
2563: WHERE header_id = p_header_id;
2564:
2565: CURSOR c_customer_qualified(p_invoice_to_org_id IN NUMBER, p_ship_to_org_id IN NUMBER, p_party_id NUMBER, p_list_header_id NUMBER) IS
2566: SELECT 'Y', object_type, qp_qualifier_group

Line 2627: TYPE orderCurrTbl IS TABLE OF oe_order_headers_all.transactional_curr_code%TYPE;

2623: l_index NUMBER := 1;
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;

Line 2653: TYPE hdrRequestDateTbl IS TABLE OF oe_order_headers_all.request_date%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;
2656:
2657: TYPE hdrCustPONumberTbl IS TABLE OF oe_order_headers_all.cust_po_number%TYPE;

Line 2654: TYPE hdrPricingDateTbl IS TABLE OF oe_order_headers_all.pricing_date%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;
2656:
2657: TYPE hdrCustPONumberTbl IS TABLE OF oe_order_headers_all.cust_po_number%TYPE;
2658: TYPE hdrOrderCategoryCodeTbl IS TABLE OF oe_order_headers_all.order_category_code%TYPE;

Line 2655: TYPE hdrOrderedDateTbl IS TABLE OF oe_order_headers_all.ordered_date%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;
2656:
2657: TYPE hdrCustPONumberTbl IS TABLE OF oe_order_headers_all.cust_po_number%TYPE;
2658: TYPE hdrOrderCategoryCodeTbl IS TABLE OF oe_order_headers_all.order_category_code%TYPE;
2659: TYPE hdrShipmentPriorityCodeTbl IS TABLE OF oe_order_headers_all.shipment_priority_code%TYPE;

Line 2657: TYPE hdrCustPONumberTbl IS TABLE OF oe_order_headers_all.cust_po_number%TYPE;

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;
2656:
2657: TYPE hdrCustPONumberTbl IS TABLE OF oe_order_headers_all.cust_po_number%TYPE;
2658: TYPE hdrOrderCategoryCodeTbl IS TABLE OF oe_order_headers_all.order_category_code%TYPE;
2659: TYPE hdrShipmentPriorityCodeTbl IS TABLE OF oe_order_headers_all.shipment_priority_code%TYPE;
2660: TYPE hdrFreightTermsCodeTbl IS TABLE OF oe_order_headers_all.freight_terms_code%TYPE;
2661: TYPE hdrShippingMethodCodeTbl IS TABLE OF oe_order_headers_all.shipping_method_code%TYPE;

Line 2658: TYPE hdrOrderCategoryCodeTbl IS TABLE OF oe_order_headers_all.order_category_code%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;
2656:
2657: TYPE hdrCustPONumberTbl IS TABLE OF oe_order_headers_all.cust_po_number%TYPE;
2658: TYPE hdrOrderCategoryCodeTbl IS TABLE OF oe_order_headers_all.order_category_code%TYPE;
2659: TYPE hdrShipmentPriorityCodeTbl IS TABLE OF oe_order_headers_all.shipment_priority_code%TYPE;
2660: TYPE hdrFreightTermsCodeTbl IS TABLE OF oe_order_headers_all.freight_terms_code%TYPE;
2661: TYPE hdrShippingMethodCodeTbl IS TABLE OF oe_order_headers_all.shipping_method_code%TYPE;
2662: TYPE hdrConversionRateDateTbl IS TABLE OF oe_order_headers_all.conversion_rate_date%TYPE;

Line 2659: TYPE hdrShipmentPriorityCodeTbl IS TABLE OF oe_order_headers_all.shipment_priority_code%TYPE;

2655: TYPE hdrOrderedDateTbl IS TABLE OF oe_order_headers_all.ordered_date%TYPE;
2656:
2657: TYPE hdrCustPONumberTbl IS TABLE OF oe_order_headers_all.cust_po_number%TYPE;
2658: TYPE hdrOrderCategoryCodeTbl IS TABLE OF oe_order_headers_all.order_category_code%TYPE;
2659: TYPE hdrShipmentPriorityCodeTbl IS TABLE OF oe_order_headers_all.shipment_priority_code%TYPE;
2660: TYPE hdrFreightTermsCodeTbl IS TABLE OF oe_order_headers_all.freight_terms_code%TYPE;
2661: TYPE hdrShippingMethodCodeTbl IS TABLE OF oe_order_headers_all.shipping_method_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;

Line 2660: TYPE hdrFreightTermsCodeTbl IS TABLE OF oe_order_headers_all.freight_terms_code%TYPE;

2656:
2657: TYPE hdrCustPONumberTbl IS TABLE OF oe_order_headers_all.cust_po_number%TYPE;
2658: TYPE hdrOrderCategoryCodeTbl IS TABLE OF oe_order_headers_all.order_category_code%TYPE;
2659: TYPE hdrShipmentPriorityCodeTbl IS TABLE OF oe_order_headers_all.shipment_priority_code%TYPE;
2660: TYPE hdrFreightTermsCodeTbl IS TABLE OF oe_order_headers_all.freight_terms_code%TYPE;
2661: TYPE hdrShippingMethodCodeTbl IS TABLE OF oe_order_headers_all.shipping_method_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;

Line 2661: TYPE hdrShippingMethodCodeTbl IS TABLE OF oe_order_headers_all.shipping_method_code%TYPE;

2657: TYPE hdrCustPONumberTbl IS TABLE OF oe_order_headers_all.cust_po_number%TYPE;
2658: TYPE hdrOrderCategoryCodeTbl IS TABLE OF oe_order_headers_all.order_category_code%TYPE;
2659: TYPE hdrShipmentPriorityCodeTbl IS TABLE OF oe_order_headers_all.shipment_priority_code%TYPE;
2660: TYPE hdrFreightTermsCodeTbl IS TABLE OF oe_order_headers_all.freight_terms_code%TYPE;
2661: TYPE hdrShippingMethodCodeTbl IS TABLE OF oe_order_headers_all.shipping_method_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;

Line 2662: TYPE hdrConversionRateDateTbl IS TABLE OF oe_order_headers_all.conversion_rate_date%TYPE;

2658: TYPE hdrOrderCategoryCodeTbl IS TABLE OF oe_order_headers_all.order_category_code%TYPE;
2659: TYPE hdrShipmentPriorityCodeTbl IS TABLE OF oe_order_headers_all.shipment_priority_code%TYPE;
2660: TYPE hdrFreightTermsCodeTbl IS TABLE OF oe_order_headers_all.freight_terms_code%TYPE;
2661: TYPE hdrShippingMethodCodeTbl IS TABLE OF oe_order_headers_all.shipping_method_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;

Line 2663: TYPE hdrConversionRateTbl IS TABLE OF oe_order_headers_all.conversion_rate%TYPE;

2659: TYPE hdrShipmentPriorityCodeTbl IS TABLE OF oe_order_headers_all.shipment_priority_code%TYPE;
2660: TYPE hdrFreightTermsCodeTbl IS TABLE OF oe_order_headers_all.freight_terms_code%TYPE;
2661: TYPE hdrShippingMethodCodeTbl IS TABLE OF oe_order_headers_all.shipping_method_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;

Line 2664: TYPE hdrConversionTypeCodeTbl IS TABLE OF oe_order_headers_all.conversion_type_code%TYPE;

2660: TYPE hdrFreightTermsCodeTbl IS TABLE OF oe_order_headers_all.freight_terms_code%TYPE;
2661: TYPE hdrShippingMethodCodeTbl IS TABLE OF oe_order_headers_all.shipping_method_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

Line 2665: TYPE hdrBlanketNumberTbl IS TABLE OF oe_order_headers_all.blanket_number%TYPE;

2661: TYPE hdrShippingMethodCodeTbl IS TABLE OF oe_order_headers_all.shipping_method_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;

Line 4149: oe_order_headers_all header

4145: SELECT cust.cust_account_id
4146: FROM hz_cust_acct_sites_all acct_site,
4147: hz_cust_site_uses_all site_use,
4148: hz_cust_accounts cust,
4149: oe_order_headers_all header
4150: WHERE header.header_id = p_header_id
4151: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
4152: AND acct_site.cust_account_id = cust.cust_account_id
4153: AND site_use.site_use_id = header.invoice_to_org_id;

Line 4817: oe_order_headers_all header

4813: SELECT cust.cust_account_id
4814: FROM hz_cust_acct_sites_all acct_site,
4815: hz_cust_site_uses_all site_use,
4816: hz_cust_accounts cust,
4817: oe_order_headers_all header
4818: WHERE header.header_id = p_header_id
4819: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
4820: AND acct_site.cust_account_id = cust.cust_account_id
4821: AND site_use.site_use_id = header.invoice_to_org_id;

Line 5336: oe_order_headers_all header

5332: SELECT cust.cust_account_id
5333: FROM hz_cust_acct_sites_all acct_site,
5334: hz_cust_site_uses_all site_use,
5335: hz_cust_accounts cust,
5336: oe_order_headers_all header
5337: WHERE header.header_id = p_header_id
5338: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
5339: AND acct_site.cust_account_id = cust.cust_account_id
5340: AND site_use.site_use_id = header.invoice_to_org_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 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 9020: oe_order_headers_all header

9016: SELECT cust.cust_account_id
9017: FROM hz_cust_acct_sites_all acct_site,
9018: hz_cust_site_uses_all site_use,
9019: hz_cust_accounts cust,
9020: oe_order_headers_all header
9021: WHERE header.header_id = p_header_id
9022: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
9023: AND acct_site.cust_account_id = cust.cust_account_id
9024: AND site_use.site_use_id = header.invoice_to_org_id ;