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

Line 2343: v_header_id oe_order_lines_all.header_id%TYPE;

2339: * 4 p_order_type_id
2340: * 5 p_ship_from_org_id
2341: *******************************************************************/
2342:
2343: v_header_id oe_order_lines_all.header_id%TYPE;
2344: v_line_id oe_order_lines_all.line_id%TYPE;
2345: v_line_number oe_order_lines_all.line_number%TYPE;
2346: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
2347: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;

Line 2344: v_line_id oe_order_lines_all.line_id%TYPE;

2340: * 5 p_ship_from_org_id
2341: *******************************************************************/
2342:
2343: v_header_id oe_order_lines_all.header_id%TYPE;
2344: v_line_id oe_order_lines_all.line_id%TYPE;
2345: v_line_number oe_order_lines_all.line_number%TYPE;
2346: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
2347: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
2348: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

Line 2345: v_line_number oe_order_lines_all.line_number%TYPE;

2341: *******************************************************************/
2342:
2343: v_header_id oe_order_lines_all.header_id%TYPE;
2344: v_line_id oe_order_lines_all.line_id%TYPE;
2345: v_line_number oe_order_lines_all.line_number%TYPE;
2346: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
2347: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
2348: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
2349: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;

Line 2346: v_shipment_number oe_order_lines_all.shipment_number%TYPE;

2342:
2343: v_header_id oe_order_lines_all.header_id%TYPE;
2344: v_line_id oe_order_lines_all.line_id%TYPE;
2345: v_line_number oe_order_lines_all.line_number%TYPE;
2346: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
2347: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
2348: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
2349: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;
2350: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;

Line 2347: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;

2343: v_header_id oe_order_lines_all.header_id%TYPE;
2344: v_line_id oe_order_lines_all.line_id%TYPE;
2345: v_line_number oe_order_lines_all.line_number%TYPE;
2346: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
2347: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
2348: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
2349: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;
2350: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;
2351: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;

Line 2348: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

2344: v_line_id oe_order_lines_all.line_id%TYPE;
2345: v_line_number oe_order_lines_all.line_number%TYPE;
2346: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
2347: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
2348: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
2349: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;
2350: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;
2351: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;
2352:

Line 2349: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;

2345: v_line_number oe_order_lines_all.line_number%TYPE;
2346: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
2347: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
2348: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
2349: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;
2350: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;
2351: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;
2352:
2353: v_last_update_date oe_order_lines_all.last_update_date%TYPE;

Line 2350: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;

2346: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
2347: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
2348: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
2349: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;
2350: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;
2351: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;
2352:
2353: v_last_update_date oe_order_lines_all.last_update_date%TYPE;
2354: v_last_updated_by oe_order_lines_all.last_updated_by%TYPE;

Line 2351: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;

2347: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
2348: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
2349: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;
2350: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;
2351: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;
2352:
2353: v_last_update_date oe_order_lines_all.last_update_date%TYPE;
2354: v_last_updated_by oe_order_lines_all.last_updated_by%TYPE;
2355: v_last_update_login oe_order_lines_all.last_update_login%TYPE;

Line 2353: v_last_update_date oe_order_lines_all.last_update_date%TYPE;

2349: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;
2350: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;
2351: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;
2352:
2353: v_last_update_date oe_order_lines_all.last_update_date%TYPE;
2354: v_last_updated_by oe_order_lines_all.last_updated_by%TYPE;
2355: v_last_update_login oe_order_lines_all.last_update_login%TYPE;
2356:
2357: /* commented by cbabu for Bug#2496481

Line 2354: v_last_updated_by oe_order_lines_all.last_updated_by%TYPE;

2350: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;
2351: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;
2352:
2353: v_last_update_date oe_order_lines_all.last_update_date%TYPE;
2354: v_last_updated_by oe_order_lines_all.last_updated_by%TYPE;
2355: v_last_update_login oe_order_lines_all.last_update_login%TYPE;
2356:
2357: /* commented by cbabu for Bug#2496481
2358: v_created_by oe_order_lines_all.created_by%TYPE;

Line 2355: v_last_update_login oe_order_lines_all.last_update_login%TYPE;

2351: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;
2352:
2353: v_last_update_date oe_order_lines_all.last_update_date%TYPE;
2354: v_last_updated_by oe_order_lines_all.last_updated_by%TYPE;
2355: v_last_update_login oe_order_lines_all.last_update_login%TYPE;
2356:
2357: /* commented by cbabu for Bug#2496481
2358: v_created_by oe_order_lines_all.created_by%TYPE;
2359: v_creation_date oe_order_lines_all.creation_date%TYPE;

Line 2358: v_created_by oe_order_lines_all.created_by%TYPE;

2354: v_last_updated_by oe_order_lines_all.last_updated_by%TYPE;
2355: v_last_update_login oe_order_lines_all.last_update_login%TYPE;
2356:
2357: /* commented by cbabu for Bug#2496481
2358: v_created_by oe_order_lines_all.created_by%TYPE;
2359: v_creation_date oe_order_lines_all.creation_date%TYPE;
2360: v_transaction_name varchar2(30) := 'SO_LINES_UPDATE';
2361: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
2362: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;

Line 2359: v_creation_date oe_order_lines_all.creation_date%TYPE;

2355: v_last_update_login oe_order_lines_all.last_update_login%TYPE;
2356:
2357: /* commented by cbabu for Bug#2496481
2358: v_created_by oe_order_lines_all.created_by%TYPE;
2359: v_creation_date oe_order_lines_all.creation_date%TYPE;
2360: v_transaction_name varchar2(30) := 'SO_LINES_UPDATE';
2361: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
2362: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
2363: v_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;

Line 2361: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;

2357: /* commented by cbabu for Bug#2496481
2358: v_created_by oe_order_lines_all.created_by%TYPE;
2359: v_creation_date oe_order_lines_all.creation_date%TYPE;
2360: v_transaction_name varchar2(30) := 'SO_LINES_UPDATE';
2361: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
2362: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
2363: v_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;
2364: v_source_document_id oe_order_lines_all.source_document_id%TYPE;
2365: v_source_document_line_id oe_order_lines_all.source_document_line_id%TYPE;

Line 2362: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;

2358: v_created_by oe_order_lines_all.created_by%TYPE;
2359: v_creation_date oe_order_lines_all.creation_date%TYPE;
2360: v_transaction_name varchar2(30) := 'SO_LINES_UPDATE';
2361: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
2362: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
2363: v_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;
2364: v_source_document_id oe_order_lines_all.source_document_id%TYPE;
2365: v_source_document_line_id oe_order_lines_all.source_document_line_id%TYPE;
2366: v_source_order_category varchar2(30);

Line 2363: v_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;

2359: v_creation_date oe_order_lines_all.creation_date%TYPE;
2360: v_transaction_name varchar2(30) := 'SO_LINES_UPDATE';
2361: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
2362: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
2363: v_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;
2364: v_source_document_id oe_order_lines_all.source_document_id%TYPE;
2365: v_source_document_line_id oe_order_lines_all.source_document_line_id%TYPE;
2366: v_source_order_category varchar2(30);
2367: v_source_header_id Number;

Line 2364: v_source_document_id oe_order_lines_all.source_document_id%TYPE;

2360: v_transaction_name varchar2(30) := 'SO_LINES_UPDATE';
2361: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
2362: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
2363: v_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;
2364: v_source_document_id oe_order_lines_all.source_document_id%TYPE;
2365: v_source_document_line_id oe_order_lines_all.source_document_line_id%TYPE;
2366: v_source_order_category varchar2(30);
2367: v_source_header_id Number;
2368: v_source_id Number;

Line 2365: v_source_document_line_id oe_order_lines_all.source_document_line_id%TYPE;

2361: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
2362: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
2363: v_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;
2364: v_source_document_id oe_order_lines_all.source_document_id%TYPE;
2365: v_source_document_line_id oe_order_lines_all.source_document_line_id%TYPE;
2366: v_source_order_category varchar2(30);
2367: v_source_header_id Number;
2368: v_source_id Number;
2369: */

Line 2370: v_source_document_type_id oe_order_lines_all.source_document_type_id%TYPE;

2366: v_source_order_category varchar2(30);
2367: v_source_header_id Number;
2368: v_source_id Number;
2369: */
2370: v_source_document_type_id oe_order_lines_all.source_document_type_id%TYPE;
2371: v_Line_Category_Code oe_order_lines_all.line_category_code%TYPE;
2372: v_reference_line_id oe_order_lines_all.reference_line_id%TYPE; -- used for return lines
2373: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
2374: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;

Line 2371: v_Line_Category_Code oe_order_lines_all.line_category_code%TYPE;

2367: v_source_header_id Number;
2368: v_source_id Number;
2369: */
2370: v_source_document_type_id oe_order_lines_all.source_document_type_id%TYPE;
2371: v_Line_Category_Code oe_order_lines_all.line_category_code%TYPE;
2372: v_reference_line_id oe_order_lines_all.reference_line_id%TYPE; -- used for return lines
2373: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
2374: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;
2375: v_operating_id oe_order_lines_all.org_id%TYPE;

Line 2372: v_reference_line_id oe_order_lines_all.reference_line_id%TYPE; -- used for return lines

2368: v_source_id Number;
2369: */
2370: v_source_document_type_id oe_order_lines_all.source_document_type_id%TYPE;
2371: v_Line_Category_Code oe_order_lines_all.line_category_code%TYPE;
2372: v_reference_line_id oe_order_lines_all.reference_line_id%TYPE; -- used for return lines
2373: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
2374: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;
2375: v_operating_id oe_order_lines_all.org_id%TYPE;
2376: v_old_assessable_value JAI_OM_OE_SO_LINES.assessable_value%TYPE;

Line 2373: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

2369: */
2370: v_source_document_type_id oe_order_lines_all.source_document_type_id%TYPE;
2371: v_Line_Category_Code oe_order_lines_all.line_category_code%TYPE;
2372: v_reference_line_id oe_order_lines_all.reference_line_id%TYPE; -- used for return lines
2373: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
2374: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;
2375: v_operating_id oe_order_lines_all.org_id%TYPE;
2376: v_old_assessable_value JAI_OM_OE_SO_LINES.assessable_value%TYPE;
2377: v_line_amount NUMBER := 0;

Line 2374: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;

2370: v_source_document_type_id oe_order_lines_all.source_document_type_id%TYPE;
2371: v_Line_Category_Code oe_order_lines_all.line_category_code%TYPE;
2372: v_reference_line_id oe_order_lines_all.reference_line_id%TYPE; -- used for return lines
2373: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
2374: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;
2375: v_operating_id oe_order_lines_all.org_id%TYPE;
2376: v_old_assessable_value JAI_OM_OE_SO_LINES.assessable_value%TYPE;
2377: v_line_amount NUMBER := 0;
2378:

Line 2375: v_operating_id oe_order_lines_all.org_id%TYPE;

2371: v_Line_Category_Code oe_order_lines_all.line_category_code%TYPE;
2372: v_reference_line_id oe_order_lines_all.reference_line_id%TYPE; -- used for return lines
2373: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
2374: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;
2375: v_operating_id oe_order_lines_all.org_id%TYPE;
2376: v_old_assessable_value JAI_OM_OE_SO_LINES.assessable_value%TYPE;
2377: v_line_amount NUMBER := 0;
2378:
2379: v_original_system_reference VARCHAR2(50);

Line 2468: FROM oe_order_headers_all head, oe_order_lines_all base, JAI_OM_OE_SO_LINES ja

2464: base.SOURCE_DOCUMENT_TYPE_ID, ja.assessable_value,
2465: NVL(head.org_id,0) org_id1, head.SOLD_TO_ORG_ID, head.SOURCE_DOCUMENT_ID hsdi, head.order_number,
2466: head.price_list_id, head.ORDER_CATEGORY_CODE, head.ORIG_SYS_DOCUMENT_REF, head.TRANSACTIONAL_CURR_CODE,
2467: head.conversion_type_code, head.conversion_rate, head.CONVERSION_RATE_DATE, nvl(head.ORDERED_DATE, head.creation_date) ordered_date
2468: FROM oe_order_headers_all head, oe_order_lines_all base, JAI_OM_OE_SO_LINES ja
2469: WHERE head.header_id = base.header_id
2470: and base.line_id = ja.line_id
2471: and base.OPEN_FLAG = 'Y'
2472: and base.line_category_code = 'ORDER'