DBA Data[Home] [Help]

APPS.INV_MWB_TREE dependencies on MTL_SYSTEM_ITEMS

Line 1612: FROM mtl_system_items

1608: IF p_organization_id IS NOT NULL
1609: AND p_inventory_item_id IS NOT NULL THEN
1610: SELECT serial_number_control_code
1611: INTO serial_control
1612: FROM mtl_system_items
1613: WHERE organization_id = p_organization_id
1614: AND inventory_item_id = p_inventory_item_id;
1615: END IF;
1616:

Line 5928: item mtl_system_items_kfv.concatenated_segments%TYPE;

5924: rows_processed NUMBER;
5925: lpn wms_license_plate_numbers.license_plate_number%TYPE;
5926: lpn_id wms_license_plate_numbers.lpn_id%TYPE;
5927: item_id wms_license_plate_numbers.inventory_item_id%TYPE;
5928: item mtl_system_items_kfv.concatenated_segments%TYPE;
5929: i NUMBER := x_tbl_index;
5930: j NUMBER := x_node_value;
5931: is_bind_required BOOLEAN := TRUE;
5932: table_required VARCHAR2(200);

Line 6616: FROM mtl_system_items_kfv

6612: IF item_id IS NOT NULL
6613: AND item_id <> 0 THEN
6614: SELECT concatenated_segments
6615: INTO item
6616: FROM mtl_system_items_kfv
6617: WHERE organization_id = p_organization_id
6618: AND inventory_item_id = item_id;
6619:
6620: item := ' (' || item || ')';

Line 6709: item_id mtl_system_items_kfv.inventory_item_id%TYPE;

6705: ) IS
6706: query_str VARCHAR2(10000);
6707: query_hdl NUMBER;
6708: rows_processed NUMBER;
6709: item_id mtl_system_items_kfv.inventory_item_id%TYPE;
6710: item mtl_system_items_kfv.concatenated_segments%TYPE;
6711: i NUMBER := x_tbl_index;
6712: j NUMBER := x_node_value;
6713: table_required VARCHAR2(300);

Line 6710: item mtl_system_items_kfv.concatenated_segments%TYPE;

6706: query_str VARCHAR2(10000);
6707: query_hdl NUMBER;
6708: rows_processed NUMBER;
6709: item_id mtl_system_items_kfv.inventory_item_id%TYPE;
6710: item mtl_system_items_kfv.concatenated_segments%TYPE;
6711: i NUMBER := x_tbl_index;
6712: j NUMBER := x_node_value;
6713: table_required VARCHAR2(300);
6714:

Line 7336: || ' ( select null from mtl_system_items msi WHERE ';

7332: query_str := query_str || 'AND lpn_id IS NOT NULL ';
7333: END IF;
7334:
7335: /*query_str := query_str || ' AND eixsts ';
7336: || ' ( select null from mtl_system_items msi WHERE ';
7337: || ' moq.organization_id = msi.organization_id and ';
7338: || ' moq.inventory_item_id = msi.inventory_item_id) and ';
7339: || ' serial_number_control_code in (1,6) ) ';*/
7340:

Line 8180: item mtl_system_items_kfv.concatenated_segments%TYPE;

8176: ) IS
8177: query_str VARCHAR2(10000);
8178: query_hdl NUMBER;
8179: rows_processed NUMBER;
8180: item mtl_system_items_kfv.concatenated_segments%TYPE;
8181: rev mtl_onhand_quantities.revision%TYPE;
8182: rev_control NUMBER;
8183: i NUMBER := x_tbl_index;
8184: j NUMBER := x_node_value;

Line 8199: FROM mtl_system_items

8195: IF p_organization_id IS NOT NULL
8196: AND p_inventory_item_id IS NOT NULL THEN
8197: SELECT revision_qty_control_code
8198: INTO rev_control
8199: FROM mtl_system_items
8200: WHERE organization_id = p_organization_id
8201: AND inventory_item_id = p_inventory_item_id;
8202:
8203: IF rev_control = 1 THEN

Line 9344: FROM mtl_system_items

9340: IF p_organization_id IS NOT NULL
9341: AND p_inventory_item_id IS NOT NULL THEN
9342: SELECT lot_control_code
9343: INTO lot_control
9344: FROM mtl_system_items
9345: WHERE organization_id = p_organization_id
9346: AND inventory_item_id = p_inventory_item_id;
9347:
9348: IF lot_control = 1 THEN

Line 9833: || ' ( select null from mtl_system_items msi WHERE '

9829: -- query_str := query_str || 'AND serial_number_control_code in (1,6) ';
9830: query_str :=
9831: query_str
9832: || ' AND exists '
9833: || ' ( select null from mtl_system_items msi WHERE '
9834: || ' moq.organization_id = msi.organization_id and '
9835: || ' moq.inventory_item_id = msi.inventory_item_id and '
9836: || ' item_serial_control in (1,6) ) ';
9837:

Line 10185: || ' ( select null from mtl_system_items msi WHERE '

10181: IF p_serial_controlled = 1 THEN
10182: query_str :=
10183: query_str
10184: || ' AND exists '
10185: || ' ( select null from mtl_system_items msi WHERE '
10186: || ' mol.organization_id = msi.organization_id and '
10187: || ' mol.inventory_item_id = msi.inventory_item_id and '
10188: || ' item_serial_control in (1,6) ) ';
10189: ELSIF p_serial_controlled = 2 THEN

Line 10193: || ' ( select null from mtl_system_items msi WHERE '

10189: ELSIF p_serial_controlled = 2 THEN
10190: query_str :=
10191: query_str
10192: || ' AND exists '
10193: || ' ( select null from mtl_system_items msi WHERE '
10194: || ' mol.organization_id = msi.organization_id and '
10195: || ' mol.inventory_item_id = msi.inventory_item_id and '
10196: || ' item_serial_control in (2,5) ) ';
10197: END IF;

Line 10482: FROM mtl_system_items

10478: IF p_organization_id IS NOT NULL
10479: AND p_inventory_item_id IS NOT NULL THEN
10480: SELECT serial_number_control_code
10481: INTO serial_control
10482: FROM mtl_system_items
10483: WHERE organization_id = p_organization_id
10484: AND inventory_item_id = p_inventory_item_id;
10485:
10486: IF serial_control IN(1, 6) THEN

Line 11167: grade_control mtl_system_items.GRADE_CONTROL_FLAG%TYPE ;

11163: org_id mtl_onhand_quantities.organization_id%TYPE;
11164: org_code mtl_parameters.organization_code%TYPE;
11165: i NUMBER := x_tbl_index;
11166: j NUMBER := x_node_value;
11167: grade_control mtl_system_items.GRADE_CONTROL_FLAG%TYPE ;
11168: table_required VARCHAR2(300);
11169: --ER(3338592) Changes
11170: group_str VARCHAR2(10000) ;
11171: having_str VARCHAR2(10000) := ' HAVING 1=1 ';

Line 11183: FROM mtl_system_items

11179: IF p_organization_id IS NOT NULL
11180: AND p_inventory_item_id IS NOT NULL THEN
11181: SELECT DISTINCT grade_control_flag
11182: INTO grade_control
11183: FROM mtl_system_items
11184: WHERE inventory_item_id = p_inventory_item_id;
11185: IF ( grade_control IN ('N','n') ) THEN
11186: RETURN;
11187: END IF;