[Home] [Help]
2221: /* -- 6/3/2002 mpande changed as per PM specifications --
2222: We should accrue to the bill to org but not o the sold to org
2223: CURSOR c_cust_number (p_header_id IN NUMBER) IS
2224: SELECT sold_to_org_id
2225: FROM oe_order_headers_all
2226: WHERE header_id = p_header_id;
2227: */
2228: CURSOR c_cust_number (p_header_id IN NUMBER) IS
2229: SELECT cust.cust_account_id, header.invoice_to_org_id, header.ship_to_org_id
2229: SELECT cust.cust_account_id, header.invoice_to_org_id, header.ship_to_org_id
2230: FROM hz_cust_acct_sites_all acct_site,
2231: hz_cust_site_uses_all site_use,
2232: hz_cust_accounts cust,
2233: oe_order_headers_all header
2234: WHERE header.header_id = p_header_id
2235: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
2236: AND acct_site.cust_account_id = cust.cust_account_id
2237: AND site_use.site_use_id = header.invoice_to_org_id ;
2237: AND site_use.site_use_id = header.invoice_to_org_id ;
2238:
2239: -- Cursor to get the org_id for order
2240: CURSOR c_org_id (p_order_header_id IN NUMBER)IS
2241: SELECT org_id FROM oe_order_headers_all
2242: WHERE header_id = p_order_header_id;
2243:
2244: --nirprasa,ER 8399134
2245: CURSOR c_offer_info (p_list_header_id IN NUMBER) IS
2425: SELECT cust.cust_account_id, header.invoice_to_org_id, header.ship_to_org_id
2426: FROM hz_cust_acct_sites_all acct_site,
2427: hz_cust_site_uses_all site_use,
2428: hz_cust_accounts cust,
2429: oe_order_headers_all header
2430: WHERE header.header_id = p_header_id
2431: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id
2432: AND acct_site.cust_account_id = cust.cust_account_id
2433: AND site_use.site_use_id = header.invoice_to_org_id ;
2434:
2435: --Added for bug 7030415, get order's org_id
2436: CURSOR c_order_org_id (p_line_id IN NUMBER) IS
2437: SELECT header.org_id
2438: FROM oe_order_lines_all line, oe_order_headers_all header
2439: WHERE line_id = p_line_id
2440: AND line.header_id = header.header_id;
2441:
2442: CURSOR c_offer_type (p_offer_id IN NUMBER) IS
2845: line.shipping_quantity2, -- Catch Weight ER
2846: line.shipping_quantity_uom2, -- Catch Weight ER
2847: line.fulfillment_base, -- Catch Weight ER
2848: line.order_quantity_uom -- Catch Weight ER
2849: FROM oe_order_lines_all line, oe_order_headers_all header
2850: WHERE line_id = p_line_id
2851: AND line.header_id = header.header_id;
2852:
2853: -- Catch Weight ER - start
3849: booked_flag,
3850: transactional_curr_code,
3851: order_number,
3852: org_id
3853: FROM oe_order_headers_all
3854: WHERE header_id = p_header_id;
3855:
3856: CURSOR c_all_price_adjustments (p_line_id IN NUMBER) IS
3857: SELECT price_adjustment_id,
4024: DECODE(line.line_category_code,'ORDER',NVL(line.shipped_quantity,0),
4025: 'RETURN', line.invoiced_quantity,
4026: line.ordered_quantity) shipped_quantity
4027:
4028: FROM oe_order_lines_all line, oe_order_headers_all header
4029: WHERE line.line_id = p_order_line_id
4030: AND line.header_id = header.header_id;
4031:
4032:
6218: CURSOR c_invoice_date(p_headerId IN NUMBER, p_lineId IN NUMBER) IS
6219: SELECT trunc(cust.trx_date) -- transaction(invoice) date
6220: FROM ra_customer_trx_all cust,
6221: ra_customer_trx_lines_all cust_lines,
6222: oe_order_headers_all oeh
6223: WHERE cust.customer_trx_id = cust_lines.customer_trx_id
6224: AND cust_lines.interface_line_attribute1 = oeh.order_number
6225: AND cust_lines.interface_line_attribute6 = TO_CHAR(p_lineId)
6226: AND cust_lines.interface_line_context = 'ORDER ENTRY'
6411:
6412: -- added for 3917556
6413: CURSOR c_get_offer_info (p_header_id IN NUMBER) IS
6414: SELECT order_number
6415: FROM oe_order_headers_all
6416: WHERE header_id = p_header_id;
6417:
6418: BEGIN
6419: x_retcode := 0;