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 416: cursor c_get_base_line_id(cp_line_id oe_order_lines_all.line_id%type)

412: select vat_exemption_flag from jai_om_oe_so_lines
413: where line_id = cp_line_id;
414: lv_vat_exemption_flag char(1) := 'N';
415:
416: cursor c_get_base_line_id(cp_line_id oe_order_lines_all.line_id%type)
417: is
418: select wdd.source_line_id from wsh_delivery_details wdd, jai_om_oe_rma_lines joorl
419: where wdd.delivery_detail_id = joorl.delivery_detail_id
420: and joorl.rma_line_id = cp_line_id;

Line 421: lv_reference_Line_id oe_order_lines_all.Reference_Line_id%type;

417: is
418: select wdd.source_line_id from wsh_delivery_details wdd, jai_om_oe_rma_lines joorl
419: where wdd.delivery_detail_id = joorl.delivery_detail_id
420: and joorl.rma_line_id = cp_line_id;
421: lv_reference_Line_id oe_order_lines_all.Reference_Line_id%type;
422:
423: cursor c_excise_exemption_rma(cp_line_id number) IS
424: select excise_exempt_type from jai_om_oe_so_lines
425: where excise_exempt_type IS NOT NULL AND

Line 3395: v_header_id oe_order_lines_all.header_id%TYPE;

3391: * 4 p_order_type_id
3392: * 5 p_ship_from_org_id
3393: *******************************************************************/
3394:
3395: v_header_id oe_order_lines_all.header_id%TYPE;
3396: v_line_id oe_order_lines_all.line_id%TYPE;
3397: v_line_number oe_order_lines_all.line_number%TYPE;
3398: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
3399: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;

Line 3396: v_line_id oe_order_lines_all.line_id%TYPE;

3392: * 5 p_ship_from_org_id
3393: *******************************************************************/
3394:
3395: v_header_id oe_order_lines_all.header_id%TYPE;
3396: v_line_id oe_order_lines_all.line_id%TYPE;
3397: v_line_number oe_order_lines_all.line_number%TYPE;
3398: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
3399: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
3400: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

Line 3397: v_line_number oe_order_lines_all.line_number%TYPE;

3393: *******************************************************************/
3394:
3395: v_header_id oe_order_lines_all.header_id%TYPE;
3396: v_line_id oe_order_lines_all.line_id%TYPE;
3397: v_line_number oe_order_lines_all.line_number%TYPE;
3398: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
3399: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
3400: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3401: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;

Line 3398: v_shipment_number oe_order_lines_all.shipment_number%TYPE;

3394:
3395: v_header_id oe_order_lines_all.header_id%TYPE;
3396: v_line_id oe_order_lines_all.line_id%TYPE;
3397: v_line_number oe_order_lines_all.line_number%TYPE;
3398: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
3399: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
3400: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3401: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;
3402: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;

Line 3399: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;

3395: v_header_id oe_order_lines_all.header_id%TYPE;
3396: v_line_id oe_order_lines_all.line_id%TYPE;
3397: v_line_number oe_order_lines_all.line_number%TYPE;
3398: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
3399: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
3400: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3401: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;
3402: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;
3403: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;

Line 3400: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;

3396: v_line_id oe_order_lines_all.line_id%TYPE;
3397: v_line_number oe_order_lines_all.line_number%TYPE;
3398: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
3399: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
3400: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3401: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;
3402: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;
3403: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;
3404:

Line 3401: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;

3397: v_line_number oe_order_lines_all.line_number%TYPE;
3398: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
3399: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
3400: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3401: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;
3402: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;
3403: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;
3404:
3405: v_last_update_date oe_order_lines_all.last_update_date%TYPE;

Line 3402: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;

3398: v_shipment_number oe_order_lines_all.shipment_number%TYPE;
3399: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
3400: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3401: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;
3402: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;
3403: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;
3404:
3405: v_last_update_date oe_order_lines_all.last_update_date%TYPE;
3406: v_last_updated_by oe_order_lines_all.last_updated_by%TYPE;

Line 3403: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;

3399: v_ship_to_site_use_id oe_order_lines_all.ship_to_ORG_id%TYPE;
3400: v_inventory_item_id oe_order_lines_all.inventory_item_id%TYPE;
3401: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;
3402: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;
3403: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;
3404:
3405: v_last_update_date oe_order_lines_all.last_update_date%TYPE;
3406: v_last_updated_by oe_order_lines_all.last_updated_by%TYPE;
3407: v_last_update_login oe_order_lines_all.last_update_login%TYPE;

Line 3405: v_last_update_date oe_order_lines_all.last_update_date%TYPE;

3401: v_line_quantity oe_order_lines_all.ordered_quantity%TYPE;
3402: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;
3403: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;
3404:
3405: v_last_update_date oe_order_lines_all.last_update_date%TYPE;
3406: v_last_updated_by oe_order_lines_all.last_updated_by%TYPE;
3407: v_last_update_login oe_order_lines_all.last_update_login%TYPE;
3408:
3409: /* commented by cbabu for Bug#2496481

Line 3406: v_last_updated_by oe_order_lines_all.last_updated_by%TYPE;

3402: v_uom_code oe_order_lines_all.order_quantity_uom%TYPE;
3403: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;
3404:
3405: v_last_update_date oe_order_lines_all.last_update_date%TYPE;
3406: v_last_updated_by oe_order_lines_all.last_updated_by%TYPE;
3407: v_last_update_login oe_order_lines_all.last_update_login%TYPE;
3408:
3409: /* commented by cbabu for Bug#2496481
3410: v_created_by oe_order_lines_all.created_by%TYPE;

Line 3407: v_last_update_login oe_order_lines_all.last_update_login%TYPE;

3403: v_warehouse_id oe_order_lines_all.SHIP_FROM_ORG_ID%TYPE;
3404:
3405: v_last_update_date oe_order_lines_all.last_update_date%TYPE;
3406: v_last_updated_by oe_order_lines_all.last_updated_by%TYPE;
3407: v_last_update_login oe_order_lines_all.last_update_login%TYPE;
3408:
3409: /* commented by cbabu for Bug#2496481
3410: v_created_by oe_order_lines_all.created_by%TYPE;
3411: v_creation_date oe_order_lines_all.creation_date%TYPE;

Line 3410: v_created_by oe_order_lines_all.created_by%TYPE;

3406: v_last_updated_by oe_order_lines_all.last_updated_by%TYPE;
3407: v_last_update_login oe_order_lines_all.last_update_login%TYPE;
3408:
3409: /* commented by cbabu for Bug#2496481
3410: v_created_by oe_order_lines_all.created_by%TYPE;
3411: v_creation_date oe_order_lines_all.creation_date%TYPE;
3412: v_transaction_name varchar2(30) := 'SO_LINES_UPDATE';
3413: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
3414: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;

Line 3411: v_creation_date oe_order_lines_all.creation_date%TYPE;

3407: v_last_update_login oe_order_lines_all.last_update_login%TYPE;
3408:
3409: /* commented by cbabu for Bug#2496481
3410: v_created_by oe_order_lines_all.created_by%TYPE;
3411: v_creation_date oe_order_lines_all.creation_date%TYPE;
3412: v_transaction_name varchar2(30) := 'SO_LINES_UPDATE';
3413: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
3414: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
3415: v_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;

Line 3413: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;

3409: /* commented by cbabu for Bug#2496481
3410: v_created_by oe_order_lines_all.created_by%TYPE;
3411: v_creation_date oe_order_lines_all.creation_date%TYPE;
3412: v_transaction_name varchar2(30) := 'SO_LINES_UPDATE';
3413: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
3414: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
3415: v_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;
3416: v_source_document_id oe_order_lines_all.source_document_id%TYPE;
3417: v_source_document_line_id oe_order_lines_all.source_document_line_id%TYPE;

Line 3414: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;

3410: v_created_by oe_order_lines_all.created_by%TYPE;
3411: v_creation_date oe_order_lines_all.creation_date%TYPE;
3412: v_transaction_name varchar2(30) := 'SO_LINES_UPDATE';
3413: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
3414: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
3415: v_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;
3416: v_source_document_id oe_order_lines_all.source_document_id%TYPE;
3417: v_source_document_line_id oe_order_lines_all.source_document_line_id%TYPE;
3418: v_source_order_category varchar2(30);

Line 3415: v_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;

3411: v_creation_date oe_order_lines_all.creation_date%TYPE;
3412: v_transaction_name varchar2(30) := 'SO_LINES_UPDATE';
3413: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
3414: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
3415: v_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;
3416: v_source_document_id oe_order_lines_all.source_document_id%TYPE;
3417: v_source_document_line_id oe_order_lines_all.source_document_line_id%TYPE;
3418: v_source_order_category varchar2(30);
3419: v_source_header_id Number;

Line 3416: v_source_document_id oe_order_lines_all.source_document_id%TYPE;

3412: v_transaction_name varchar2(30) := 'SO_LINES_UPDATE';
3413: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
3414: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
3415: v_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;
3416: v_source_document_id oe_order_lines_all.source_document_id%TYPE;
3417: v_source_document_line_id oe_order_lines_all.source_document_line_id%TYPE;
3418: v_source_order_category varchar2(30);
3419: v_source_header_id Number;
3420: v_source_id Number;

Line 3417: v_source_document_line_id oe_order_lines_all.source_document_line_id%TYPE;

3413: v_original_system_line_ref oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
3414: v_original_line_reference oe_order_lines_all.ORIG_SYS_LINE_REF%TYPE;
3415: v_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;
3416: v_source_document_id oe_order_lines_all.source_document_id%TYPE;
3417: v_source_document_line_id oe_order_lines_all.source_document_line_id%TYPE;
3418: v_source_order_category varchar2(30);
3419: v_source_header_id Number;
3420: v_source_id Number;
3421: */

Line 3422: v_source_document_type_id oe_order_lines_all.source_document_type_id%TYPE;

3418: v_source_order_category varchar2(30);
3419: v_source_header_id Number;
3420: v_source_id Number;
3421: */
3422: v_source_document_type_id oe_order_lines_all.source_document_type_id%TYPE;
3423: v_Line_Category_Code oe_order_lines_all.line_category_code%TYPE;
3424: v_reference_line_id oe_order_lines_all.reference_line_id%TYPE; -- used for return lines
3425: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
3426: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;

Line 3423: v_Line_Category_Code oe_order_lines_all.line_category_code%TYPE;

3419: v_source_header_id Number;
3420: v_source_id Number;
3421: */
3422: v_source_document_type_id oe_order_lines_all.source_document_type_id%TYPE;
3423: v_Line_Category_Code oe_order_lines_all.line_category_code%TYPE;
3424: v_reference_line_id oe_order_lines_all.reference_line_id%TYPE; -- used for return lines
3425: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
3426: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;
3427: v_operating_id oe_order_lines_all.org_id%TYPE;

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

3420: v_source_id Number;
3421: */
3422: v_source_document_type_id oe_order_lines_all.source_document_type_id%TYPE;
3423: v_Line_Category_Code oe_order_lines_all.line_category_code%TYPE;
3424: v_reference_line_id oe_order_lines_all.reference_line_id%TYPE; -- used for return lines
3425: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
3426: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;
3427: v_operating_id oe_order_lines_all.org_id%TYPE;
3428: v_old_assessable_value JAI_OM_OE_SO_LINES.assessable_value%TYPE;

Line 3425: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

3421: */
3422: v_source_document_type_id oe_order_lines_all.source_document_type_id%TYPE;
3423: v_Line_Category_Code oe_order_lines_all.line_category_code%TYPE;
3424: v_reference_line_id oe_order_lines_all.reference_line_id%TYPE; -- used for return lines
3425: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
3426: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;
3427: v_operating_id oe_order_lines_all.org_id%TYPE;
3428: v_old_assessable_value JAI_OM_OE_SO_LINES.assessable_value%TYPE;
3429: v_line_amount NUMBER := 0;

Line 3426: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;

3422: v_source_document_type_id oe_order_lines_all.source_document_type_id%TYPE;
3423: v_Line_Category_Code oe_order_lines_all.line_category_code%TYPE;
3424: v_reference_line_id oe_order_lines_all.reference_line_id%TYPE; -- used for return lines
3425: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
3426: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;
3427: v_operating_id oe_order_lines_all.org_id%TYPE;
3428: v_old_assessable_value JAI_OM_OE_SO_LINES.assessable_value%TYPE;
3429: v_line_amount NUMBER := 0;
3430:

Line 3427: v_operating_id oe_order_lines_all.org_id%TYPE;

3423: v_Line_Category_Code oe_order_lines_all.line_category_code%TYPE;
3424: v_reference_line_id oe_order_lines_all.reference_line_id%TYPE; -- used for return lines
3425: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
3426: v_unit_selling_price oe_order_lines_all.unit_selling_price%TYPE;
3427: v_operating_id oe_order_lines_all.org_id%TYPE;
3428: v_old_assessable_value JAI_OM_OE_SO_LINES.assessable_value%TYPE;
3429: v_line_amount NUMBER := 0;
3430:
3431: v_original_system_reference VARCHAR2(50);

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

3516: base.SOURCE_DOCUMENT_TYPE_ID, ja.assessable_value,
3517: NVL(head.org_id,0) org_id1, head.SOLD_TO_ORG_ID, head.SOURCE_DOCUMENT_ID hsdi, head.order_number,
3518: head.price_list_id, head.ORDER_CATEGORY_CODE, head.ORIG_SYS_DOCUMENT_REF, head.TRANSACTIONAL_CURR_CODE,
3519: head.conversion_type_code, head.conversion_rate, head.CONVERSION_RATE_DATE, nvl(head.ORDERED_DATE, head.creation_date) ordered_date
3520: FROM oe_order_headers_all head, oe_order_lines_all base, JAI_OM_OE_SO_LINES ja
3521: WHERE head.header_id = base.header_id
3522: and base.line_id = ja.line_id
3523: and base.OPEN_FLAG = 'Y'
3524: and base.line_category_code = 'ORDER'