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 1535: FROM csi_item_instances

1531: BEGIN
1532:
1533: SELECT 'X'
1534: INTO l_found
1535: FROM csi_item_instances
1536: WHERE instance_id = p_instance_id;
1537: -- AND unexpired condition
1538:
1539: x_return_status := fnd_api.g_ret_sts_success;

Line 2216: FROM csi_item_instances

2212: BEGIN
2213:
2214: SELECT location_type_code
2215: INTO l_loc_type
2216: FROM csi_item_instances
2217: WHERE instance_id = l_iir_rec.subject_id -- either one should not be in Inventory
2218: AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);
2219: EXCEPTION
2220: WHEN OTHERS THEN

Line 2238: FROM csi_item_instances

2234: BEGIN
2235:
2236: SELECT 'Y'
2237: INTO l_found
2238: FROM csi_item_instances
2239: WHERE instance_id = l_instance_id
2240: AND sysdate between nvl(active_start_date, sysdate) and nvl(active_end_date,sysdate);
2241: EXCEPTION
2242: WHEN no_data_found THEN

Line 2398: FROM csi_item_instances

2394: l_sysdate DATE ;
2395: CURSOR get_inst_id_cur (c_sysdate IN DATE)
2396: IS
2397: SELECT instance_id
2398: FROM csi_item_instances
2399: WHERE config_inst_hdr_id = p_config_inst_hdr_id
2400: AND config_inst_rev_num = p_config_inst_rev_num
2401: AND config_inst_item_id = p_config_inst_item_id
2402: AND trunc(active_start_date) <= c_sysdate