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.CTO_WORKFLOW_API_PK dependencies on OE_ORDER_LINES

Line 102: | from oe_order_lines_all This is added during Unit test

Line 424: from oe_order_lines_all

420: -- line ou and reset after the worklfow node is completed.
421:
422: Select org_id
423: into l_line_org_id
424: from oe_order_lines_all
425: where line_id = p_itemkey;
426:
427: -- Modified by Renga Kannan on 04/28/06
428: -- CAlling Utility API to Switch to order line context

Line 467: context to the org_id on oe_order_lines_all. After

463: Fix for bug 1494878 :
464: The operating unit can be set differently for
465: OM and WIP reponsibilities. Hence, before calling OM's
466: function to update the line status, we set the org
467: context to the org_id on oe_order_lines_all. After
468: returning from the OM function, we reset the org
469: context to the WIP operating unit (profile MO:op unit)
470:
471: fix for bug 1895563 :

Line 489: l_ship_from_org_id Oe_order_lines_all.ship_from_org_id%type;

485: x_return_status VARCHAR2(1);
486: l_stmt_num number;
487: v_inv_item_id NUMBER;
488: l_message NUMBER;
489: l_ship_from_org_id Oe_order_lines_all.ship_from_org_id%type;
490: l_change_status Varchar2(100);
491: l_item_type_code Varchar2(100);
492: v_source_type_code Varchar2(100);
493: --Bugfix 9826828

Line 494: --v_shipped_quantity oe_order_lines_all.shipped_quantity%type;

490: l_change_status Varchar2(100);
491: l_item_type_code Varchar2(100);
492: v_source_type_code Varchar2(100);
493: --Bugfix 9826828
494: --v_shipped_quantity oe_order_lines_all.shipped_quantity%type;
495: --v_shipped_qty number; -- 2972186
496: v_shipped_qty oe_order_lines_all.shipped_quantity%type;
497: l_msg_count NUMBER;
498: l_msg_data VARCHAR2(200);

Line 496: v_shipped_qty oe_order_lines_all.shipped_quantity%type;

492: v_source_type_code Varchar2(100);
493: --Bugfix 9826828
494: --v_shipped_quantity oe_order_lines_all.shipped_quantity%type;
495: --v_shipped_qty number; -- 2972186
496: v_shipped_qty oe_order_lines_all.shipped_quantity%type;
497: l_msg_count NUMBER;
498: l_msg_data VARCHAR2(200);
499: l_ato_line_id NUMBER;
500: l_top_model_line_id NUMBER;

Line 550: from oe_order_lines_all oel,

546: v_shipped_qty,
547: l_ato_line_id,
548: l_top_model_line_id,
549: l_booked_flag
550: from oe_order_lines_all oel,
551: mtl_system_items msi
552: where line_id = p_order_line_id
553: and oel.inventory_item_id = msi.inventory_item_id
554: and oel.ship_from_org_id = msi.organization_id;

Line 743: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

739: )
740: IS
741:
742: l_api_name CONSTANT varchar2(40) := 'inventory_reservation_check';
743: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
744: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
745: v_activity_status_code varchar2(8);
746: v_source_type_code oe_order_lines.source_type_code%type ;
747:

Line 744: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

740: IS
741:
742: l_api_name CONSTANT varchar2(40) := 'inventory_reservation_check';
743: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
744: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
745: v_activity_status_code varchar2(8);
746: v_source_type_code oe_order_lines.source_type_code%type ;
747:
748: l_stmt_num number;

Line 746: v_source_type_code oe_order_lines.source_type_code%type ;

742: l_api_name CONSTANT varchar2(40) := 'inventory_reservation_check';
743: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
744: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
745: v_activity_status_code varchar2(8);
746: v_source_type_code oe_order_lines.source_type_code%type ;
747:
748: l_stmt_num number;
749:
750: v_header_id oe_order_lines_all.header_id%type ;

Line 750: v_header_id oe_order_lines_all.header_id%type ;

746: v_source_type_code oe_order_lines.source_type_code%type ;
747:
748: l_stmt_num number;
749:
750: v_header_id oe_order_lines_all.header_id%type ;
751: v_po_header_id po_headers_all.po_header_id%type ;
752: v_authorization_status po_headers_all.authorization_status%type ;
753:
754:

Line 775: from oe_order_lines_all

771: into v_item_type_code
772: , v_ato_line_id
773: , v_source_type_code
774: , v_header_id
775: from oe_order_lines_all
776: where line_id = p_order_line_id;
777:
778: -- here, we pass the Standard item line,
779: -- namely, it will return a success. */

Line 975: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

971: )
972: IS
973:
974: l_api_name CONSTANT varchar2(40) := 'wf_update_after_inv_reserv';
975: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
976: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
977: v_activity_status_code varchar2(8);
978: return_value integer :=1; --fix for bug#1895563
979: /*******************************************************

Line 976: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

972: IS
973:
974: l_api_name CONSTANT varchar2(40) := 'wf_update_after_inv_reserv';
975: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
976: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
977: v_activity_status_code varchar2(8);
978: return_value integer :=1; --fix for bug#1895563
979: /*******************************************************
980: return value is intialized to 1 in the begining,

Line 1006: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'Before selecting info from oe_order_lines_all');

1002: x_return_status := FND_API.G_RET_STS_SUCCESS;
1003: l_stmt_num := 10;
1004:
1005: If PG_DEBUG <> 0 Then
1006: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'Before selecting info from oe_order_lines_all');
1007: End if;
1008:
1009:
1010: select item_type_code,

Line 1014: from oe_order_lines_all

1010: select item_type_code,
1011: ato_line_id
1012: into v_item_type_code,
1013: v_ato_line_id
1014: from oe_order_lines_all
1015: where line_id = p_order_line_id;
1016: If PG_DEBUG <> 0 Then
1017: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'ato_line_id = '||v_ato_line_id);
1018: cto_wip_workflow_api_pk.cto_debug('WF_UPDATE_AFTER_INV_RESERV', 'v_item_type_code = '||v_item_type_code);

Line 1416: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

1412: )
1413: IS
1414:
1415: l_api_name CONSTANT VARCHAR2(40) := 'inventory_unreservation_check';
1416: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
1417: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
1418: v_activity_status_code VARCHAR2(8);
1419: l_stmt_num number;
1420:

Line 1417: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

1413: IS
1414:
1415: l_api_name CONSTANT VARCHAR2(40) := 'inventory_unreservation_check';
1416: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
1417: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
1418: v_activity_status_code VARCHAR2(8);
1419: l_stmt_num number;
1420:
1421: BEGIN

Line 1432: from oe_order_lines_all

1428: l_stmt_num := 10;
1429:
1430: select item_type_code, ato_line_id
1431: into v_item_type_code, v_ato_line_id
1432: from oe_order_lines_all
1433: where line_id = p_order_line_id;
1434:
1435: --
1436: -- For CONFIG items, unreservation is allowed only when the workflow has moved to SHIP LINE.

Line 1589: v_item_type_code oe_order_lines_all.item_type_code%TYPE;

1585: )
1586: IS
1587:
1588: l_api_name CONSTANT varchar2(40) := 'wf_update_after_inv_unreserv';
1589: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
1590: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
1591: v_activity_status_code varchar2(8);
1592: v_counter integer;
1593: v_counter2 integer;

Line 1590: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;

1586: IS
1587:
1588: l_api_name CONSTANT varchar2(40) := 'wf_update_after_inv_unreserv';
1589: v_item_type_code oe_order_lines_all.item_type_code%TYPE;
1590: v_ato_line_id oe_order_lines_all.ato_line_id%TYPE;
1591: v_activity_status_code varchar2(8);
1592: v_counter integer;
1593: v_counter2 integer;
1594: return_value integer;

Line 1599: l_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;

1595: l_stmt_num number;
1596: l_source_document_type_id number; -- bugfix 1799874
1597: l_message varchar2(100);
1598: l_po_req_qty Number;
1599: l_split_from_line_id oe_order_lines_all.split_from_line_id%TYPE;
1600:
1601: l_dummy number;
1602:
1603:

Line 1682: from oe_order_lines_all

1678: l_inventory_item_id,
1679: l_ship_from_org_id,
1680: l_ship_xfaced_flag, -- Bug fix 4863275
1681: v_open_flag -- Bugfix 7214005
1682: from oe_order_lines_all
1683: where line_id = p_order_line_id;
1684:
1685: If PG_DEBUG <> 0 Then
1686: cto_wip_workflow_api_pk.cto_debug('wf_update_after_inv_unreserv', 'ATO Line Id = '||v_ato_line_id);

Line 2184: from oe_order_lines_all

2180:
2181: v_count := 0;
2182: l_stmt_num := 20;
2183: select count(*) into v_count
2184: from oe_order_lines_all
2185: where header_id = v_header_id
2186: and ato_line_id = v_model_id
2187: and item_type_code = 'CONFIG';
2188:

Line 2267: from oe_order_lines_all

2263:
2264: l_stmt_num := 5;
2265: select ato_line_id, header_id
2266: into l_ato_line_id, l_header_id
2267: from oe_order_lines_all
2268: where line_id = oe_line_security.g_record.line_id
2269: and item_type_code <> 'STANDARD'
2270: and ato_line_id is not null;
2271:

Line 2277: from oe_order_lines_all

2273: -- adding join to header_id for performance
2274: l_stmt_num := 10;
2275: select 1
2276: into l_config_exists
2277: from oe_order_lines_all
2278: where header_id = l_header_id
2279: and ato_line_id = l_ato_line_id
2280: and item_type_code = 'CONFIG';
2281:

Line 2449: from oe_order_lines_all

2445: l_stmt_num := 5;
2446:
2447: select 1
2448: into l_config_item
2449: from oe_order_lines_all
2450: where line_id = oe_line_security.g_record.line_id
2451: and item_type_code = 'CONFIG';
2452:
2453: IF PG_DEBUG <> 0 THEN

Line 2530: from oe_order_lines_all

2526: l_stmt_num NUMBER;
2527:
2528: CURSOR c_config_exists IS
2529: select ato_line_id
2530: from oe_order_lines_all
2531: where top_model_line_id = oe_line_security.g_record.top_model_line_id
2532: and item_type_code = 'CONFIG';
2533:
2534: BEGIN

Line 2563: from oe_order_lines_all

2559:
2560: l_stmt_num := 30;
2561: select 1
2562: into l_config_exists
2563: from oe_order_lines_all
2564: where top_model_line_id = oe_line_security.g_record.top_model_line_id
2565: and item_type_code = 'CONFIG'
2566: and rownum = 1;
2567:

Line 2591: from oe_order_lines_all

2587:
2588: l_stmt_num := 50;
2589: select link_to_line_id
2590: into l_current_model_line
2591: from oe_order_lines_all
2592: where line_id = l_current_model_line;
2593:
2594: IF l_current_model_line = l_pto_line THEN
2595: IF PG_DEBUG <> 0 THEN

Line 2681: from oe_order_lines_all

2677: l_stmt_num := 5;
2678:
2679: select 1
2680: into l_top_ato_model
2681: from oe_order_lines_all
2682: where line_id = oe_line_security.g_record.line_id
2683: and ato_line_id = line_id;
2684:
2685: x_result := 1; /* the condition is true */

Line 2752: from oe_order_lines_all

2748: l_stmt_num := 5;
2749:
2750: select 1
2751: into l_config_item
2752: from oe_order_lines_all
2753: where line_id = oe_line_security.g_record.line_id
2754: and item_type_code = 'CONFIG';
2755:
2756: IF PG_DEBUG <> 0 THEN

Line 2802: lFlowStatusCode oe_order_lines_all.flow_status_code%type; --bugfix 2825486

2798:
2799: -- local parameters
2800: l_message VARCHAR2(100);
2801: l_stmt_num NUMBER;
2802: lFlowStatusCode oe_order_lines_all.flow_status_code%type; --bugfix 2825486
2803: l_current_mode varchar2(100);
2804: l_current_org Number;
2805: L_CHANGE_CONTEXT_BACK Varchar2(100);
2806: l_cancelled_flag varchar2(1); --Bugfix 7292113

Line 2821: from oe_order_lines_all

2817: -- bugfix 2825486: added select to get the current flow_status_code.
2818: l_stmt_num := 20;
2819: select nvl(flow_status_code,'N'), cancelled_flag --Bugfix 7292113
2820: into lFlowStatusCode, l_cancelled_flag
2821: from oe_order_lines_all
2822: where header_id = p_header_id
2823: and line_id = p_line_id;
2824:
2825:

Line 2972: p_new_order_quantity oe_order_lines_all.ordered_quantity%TYPE;

2968: p_organization_id VARCHAR2(100);
2969: p_offset_days NUMBER;
2970: x_return_status VARCHAR2(100);
2971: l_stmt_num NUMBER;
2972: p_new_order_quantity oe_order_lines_all.ordered_quantity%TYPE;
2973: v_x_error_msg_count NUMBER;
2974: v_x_hold_result_out VARCHAR2(1);
2975: v_x_hold_return_status VARCHAR2(1);
2976: v_x_error_msg VARCHAR2(150);

Line 2977: so_line oe_order_lines_all%ROWTYPE;

2973: v_x_error_msg_count NUMBER;
2974: v_x_hold_result_out VARCHAR2(1);
2975: v_x_hold_return_status VARCHAR2(1);
2976: v_x_error_msg VARCHAR2(150);
2977: so_line oe_order_lines_all%ROWTYPE;
2978: p_program_id NUMBER;
2979: l_res BOOLEAN;
2980: p_order_number VARCHAR2(100);
2981:

Line 3029: FROM oe_order_lines_all

3025: -- this cursor will fetch only one record from the table as the parameter passed in is the primary key.
3026: --
3027: SELECT *
3028: INTO so_line
3029: FROM oe_order_lines_all
3030: WHERE line_id = to_number(p_itemkey);
3031:
3032: SELECT order_number
3033: INTO p_order_number

Line 3034: FROM oe_order_lines_all a, oe_order_headers_all b

3030: WHERE line_id = to_number(p_itemkey);
3031:
3032: SELECT order_number
3033: INTO p_order_number
3034: FROM oe_order_lines_all a, oe_order_headers_all b
3035: WHERE a.header_id = b.header_id
3036: AND a.line_id = to_number(p_itemkey);
3037:
3038: -- get the line source document type ID

Line 3270: FROM OE_ORDER_LINES_ALL

3266: INTO l_item_type_code,
3267: l_ato_line_id,
3268: l_inv_item_id,
3269: l_ship_org
3270: FROM OE_ORDER_LINES_ALL
3271: WHERE line_id = oe_line_security.g_record.line_id;
3272:
3273:
3274: --Adding INCLUDED item type code for SUN ER#9793792

Line 3389: from oe_order_lines_all

3385: END IF;
3386: l_stmt_num := 5;
3387: select ato_line_id, header_id , inventory_item_id
3388: into l_ato_line_id, l_header_id , l_cfg_item_id
3389: from oe_order_lines_all
3390: where line_id = oe_line_security.g_record.line_id
3391: and item_type_code <> 'STANDARD'
3392: and ato_line_id is not null;
3393:

Line 3401: from oe_order_lines_all

3397: l_stmt_num := 10;
3398:
3399: select line_id
3400: into l_config_line_id
3401: from oe_order_lines_all
3402: where header_id = l_header_id
3403: and ato_line_id = l_ato_line_id
3404: and item_type_code = 'CONFIG';
3405:

Line 3429: from oe_order_lines_all oel,

3425: --this query catches the CIB contsraint when OM calls for model line
3426: --instead of waiting for a call for config line
3427: select nvl(msi.config_orgs,1)
3428: into l_config_orgs
3429: from oe_order_lines_all oel,
3430: mtl_system_items msi
3431: where oel.line_id = l_ato_line_id
3432: and msi.inventory_item_id = oel.inventory_item_id
3433: and msi.organization_id = oel.ship_from_org_id;