APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on CSI_ITEM_INSTANCES

Line 431: FROM csi_item_instances

427: BEGIN
428:
429: SELECT 'X'
430: INTO l_found
431: FROM csi_item_instances
432: WHERE instance_id = p_object_id;
433:
434: x_return_status := fnd_api.g_ret_sts_success;
435:

Line 563: l_inst_item_id csi_item_instances.inventory_item_id%type;

559: l_src_uom_code VARCHAR2(3);
560: l_src_primary_qty NUMBER;
561: l_mo_org_id oe_order_lines_all.org_id%type;
562:
563: l_inst_item_id csi_item_instances.inventory_item_id%type;
564: l_inst_organization_id csi_item_instances.inv_organization_id%type;
565: l_inst_quantity csi_item_instances.quantity%type;
566: l_inst_uom_code csi_item_instances.unit_of_measure%type;
567:

Line 564: l_inst_organization_id csi_item_instances.inv_organization_id%type;

560: l_src_primary_qty NUMBER;
561: l_mo_org_id oe_order_lines_all.org_id%type;
562:
563: l_inst_item_id csi_item_instances.inventory_item_id%type;
564: l_inst_organization_id csi_item_instances.inv_organization_id%type;
565: l_inst_quantity csi_item_instances.quantity%type;
566: l_inst_uom_code csi_item_instances.unit_of_measure%type;
567:
568: l_dtl_item_id csi_t_txn_line_details.inventory_item_id%type;

Line 565: l_inst_quantity csi_item_instances.quantity%type;

561: l_mo_org_id oe_order_lines_all.org_id%type;
562:
563: l_inst_item_id csi_item_instances.inventory_item_id%type;
564: l_inst_organization_id csi_item_instances.inv_organization_id%type;
565: l_inst_quantity csi_item_instances.quantity%type;
566: l_inst_uom_code csi_item_instances.unit_of_measure%type;
567:
568: l_dtl_item_id csi_t_txn_line_details.inventory_item_id%type;
569: l_dtl_organization_id csi_t_txn_line_details.inv_organization_id%type;

Line 566: l_inst_uom_code csi_item_instances.unit_of_measure%type;

562:
563: l_inst_item_id csi_item_instances.inventory_item_id%type;
564: l_inst_organization_id csi_item_instances.inv_organization_id%type;
565: l_inst_quantity csi_item_instances.quantity%type;
566: l_inst_uom_code csi_item_instances.unit_of_measure%type;
567:
568: l_dtl_item_id csi_t_txn_line_details.inventory_item_id%type;
569: l_dtl_organization_id csi_t_txn_line_details.inv_organization_id%type;
570: l_dtl_quantity csi_t_txn_line_details.quantity%type;

Line 657: FROM csi_item_instances

653: INTO l_inst_item_id,
654: l_inst_organization_id,
655: l_inst_uom_code,
656: l_inst_quantity
657: FROM csi_item_instances
658: WHERE instance_id = p_txn_line_dtl_tbl(l_index).instance_id;
659:
660: l_dtl_item_id := l_inst_item_id;
661: l_dtl_organization_id := l_inst_organization_id;

Line 1508: FROM csi_item_instances

1504: BEGIN
1505:
1506: SELECT 'X'
1507: INTO l_found
1508: FROM csi_item_instances
1509: WHERE instance_id = p_instance_id;
1510: -- AND unexpired condition
1511:
1512: x_return_status := fnd_api.g_ret_sts_success;

Line 2189: FROM csi_item_instances

2185: BEGIN
2186:
2187: SELECT location_type_code
2188: INTO l_loc_type
2189: FROM csi_item_instances
2190: WHERE instance_id = l_iir_rec.subject_id -- either one should not be in Inventory
2191: AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);
2192: EXCEPTION
2193: WHEN OTHERS THEN

Line 2211: FROM csi_item_instances

2207: BEGIN
2208:
2209: SELECT 'Y'
2210: INTO l_found
2211: FROM csi_item_instances
2212: WHERE instance_id = l_instance_id
2213: AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);
2214: EXCEPTION
2215: WHEN no_data_found THEN

Line 2371: FROM csi_item_instances

2367: l_sysdate DATE ;
2368: CURSOR get_inst_id_cur (c_sysdate IN DATE)
2369: IS
2370: SELECT instance_id
2371: FROM csi_item_instances
2372: WHERE config_inst_hdr_id = p_config_inst_hdr_id
2373: AND config_inst_rev_num = p_config_inst_rev_num
2374: AND config_inst_item_id = p_config_inst_item_id
2375: AND trunc(active_start_date) <= c_sysdate